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 is proc sort?
What is the maximum and minimum length of macro variable
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
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?
How does proc sql work?
What is a method to debug and test your SAS program?
how do you want missing values handled? : Sas programming
What is SAS informats?
how would you create multiple observations from a single observation? : Sas programming
How we can create SAS USER DEFINED CODE?
Difference between nodup and nodupkey options?
How to read an input file in sas?
Of all your work, where have you been the most successful?
In ARRAY processing, what does the DIM function do?
explain the main difference between the nodup and nodupkey options? : Sas-administrator