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

Popular posts from this blog

SPSS keyboard combination alters encoding -

Add new record to the table by click on the button in Microsoft Access -

CSS3 Transition to highlight new elements created in JQuery -