Friday, 7 October 2011

Export Data


Export data for SAS envirnoment to external files or source or server

proc import datafile='C:\Documents and Settings\mobileclub\Desktop\source\xls\constraints.xls'
out=medi dbms=excel replace;
sheet='sheet6$';
run;
proc sort data=medi out=medi1 nodupkey;
by pid visit;
run;

proc export outtable=mh dbms=access replace;
database='D:\clinical.mdb';
run;

data _null_;
file'D:report.rtf' mod;
put@30'SUBJECT DOSING INFORMATION';
put' ';
put@10'DATE:30-08-11' @60'TIME:04:44:44';
put@5 73 * '-';
put@10'pid' @35'visit' @55'drug';
put@5 73 * '-';
run;

data _null_;
set Medi1;
file'D:report.rtf'mod;
put@10pid@35visit@55 drug;
run;

data _null_;
file'D:report.rtf'mod;
put' ';
put@5 73 * '-';
put@10'version:sas9.0' ;
put@60'user:naveen';
run;


No comments:

Post a Comment