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
In proc transpose and data step with arrays which one you pick?
Describe the function and untility of the most difficult SAS macro that you have written.
explain the concepts and capabilities of business object? : Sas-bi
what is the use of proc contents and proc print in sas? : Sas-administrator
How can sas program be validated?
describe the interaction table in sas di? : Sas-di
How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?
What are common programming errors committed in sas
What are the different versions of sas that you have used until now? : sas-grid-administration
What was the last computer book you purchased? Why?
what are the scrubbing procedures in sas? : Sas programming
What is a macro routine?
Differentiate input and infile.
Name validation tools used in SAS
How substr function works in sas?