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
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
What are the limitations for memory allocation for SAS variables
What do the mod and int function do? : Sas programming
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
how to change the execute of macro
Explain the purpose of substr functions in sas programming.
what is the use of proc sql? : Sas programming
How can I remove header from output data set?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
for report generation which one you used proc report or data_null_?
what is the use of sas management console? : Sas-di
Which date function advances a date, time or datetime value by a given interval?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
is data integration and etl programming is same? : Sas-di
Explain what is data step?