How to convert .xls file into CSV format?
Answer Posted / krishna
proc import datafile=file.xls out=<datasetname> dbms=excel
replace;
sheet='sheetno$';
run;
proc export outfile=filepath data=<datasetname> dbms=csv
replace;
run;
Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
How do you delete duplicate observations in sas?
What is the use of PROC gplot?
Where do you use proc means over proc freq?
Do you know the features of sas?
Mention common programming errors committed in sas ?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
what are some differences between proc summary and proc means? : Sas programming
How does the internal authentication work in sas? : sas-grid-administration
How would you define the end of a macro?
What is the role of sas grid administrator? : sas-grid-administration
Are you sensitive to code walk-throughs peer review or QC review?
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What are the default statistics that proc means produce?
where to use sas business intelligence? : Sas-bi
what are the considerations when picking a SAS/STAT procedure?