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 are some good sas programming practices for processing very large data sets? : Sas programming
What is PROC in SAS?
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
Difference between sum function and using “+” operator?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Mention few capabilities of sas framework.
what is metadata? : Sas-bi
What is the difference between using drop = data set option in data statement and set statement?
what is the use of proc contents and proc print in sas? : Sas-administrator
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What is the SAS data set?
How to create an external dataset with sas code?
What does P-value signify about the statistical data?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
How do you specify the number of iterations and specific condition within a single do loop?