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
Are you involved in writing the inferential analysis plan? Tables specifications?
Explain the main difference between the sas procedures and functions? : Sas-administrator
what is the use of proc contents and proc print in sas? : Sas-administrator
What was the last computer book you purchased? Why?
what is operational data and operational system? : Sas-di
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What are the data types that sas contain?
What are the different versions of sas that you have used until now? : sas-grid-administration
How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
what is sas database server? : Sas-di
If a variable contains letters or special characters, can it be numeric data type?
What is SAS? What are the functions does it performs?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
In sas, what are the areas that you are most interested in? : sas-grid-administration