How to create an excel file with sas variables -
sas code:
to create excel file youngest child contains (first name, dob , name).
last name first name dob of child name of child
brian geogg 20-nov-97 ginger serrano amelia 21-nov-00 garlic sinha ravi 17-oct-90 onion nagasaka kanoko 7-aug-96 bats
any input appreciated,
thanks
if have sas/access pc files licensed, proc export can handle you:
proc export data=<yourdata> outfile=<yourexcelfile.xls> dbms=excel replace; run;
if not, ods tagsets.excelxp best bet.
ods tagsets.excelxp file=<yourexcelfile.xls>; proc print data=<mydata>; run; ods tagsets.excelxp close;
there sorts of options you'd want use if way, google more information.
Comments
Post a Comment