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 does P-value signify about the statistical data?
why is sas considered self-documenting? : Sas programming
How to sort in descending order?
How to create list output for cross-tabulations in proc freq?
How to convert a numeric variable to a character variable?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Explain proc sort?
how to do user inputs and command line arguments in sas?
why is a stop statement needed for the point=option on a set statement? : Sas programming
Where do you use proc means over proc freq?
What do you know about symput and symget?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
explain the difference between proc means and proc summary?
How substr function works in sas?
What is the maximum and minimum length of macro variable