How to convert .xls file into CSV format?
Answer Posted / khaja
proc import out=<datasetname>
datafile="path\file.xls"
dbms=excel replace;
sheet='sheetno$';
run;
proc export outfile=filepath data=<datasetname> dbms=csv
replace;
run;
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
what is ae onset date n what is RDS
What areas of SAS are you most interested in?
Mention what is PROC in SAS?
What is a method to debug and test your SAS program?
What are the scrubbing procedures in sas?
Did you used proc test? when?
why a stop statement is needed for the point= option on a set statement?
what is business intelligence? : Sas-bi
What is interleaving in SAS?
How can you limit the variables written to output dataset in data step?
Mention some common errors that are usually committed in sas programming.
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
For what purposes have you used sas macros? : sas-macro
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
What are the 3 components in sas programming?