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 proc Index? and what is proc document?
what is the use of proc contents and proc print in sas? : Sas-administrator
How do dates work in SAS data?
What is the use of PROC gplot?
how to debug and test the sas program? : Sas-administrator
what is sas and what are the functions? : Sas-administrator
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
What is a put statement?
What is the command used to find missing values?
How to test the debugging in sas?
What are the parameters of scan function?
I have a dataset concat having variable a b & c. How to rename a b to e & f?
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
How to read an input file in sas?
What are the statements in proc sql?