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
Explain why double trailing @@ is used in input statement?
what is the basic structure sas administrator? : Sas-administrator
what are _numeric_ and _character_ and what do they do? : Sas programming
What is the difference between SAS functions and procedures?
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What is Linear Regression?
What sas features do you use to check errors and data validation?
WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?
what is the difference between unique key and primary key? : Sas-di
What is interleaving in SAS?
Explain what is data step?
how would you create multiple observations from a single observation? : Sas programming
where are dashboard components are created and maintained? : Sas-bi
What is the differnce between SDTM 3.1.2 to 3.1.1 version
How to create a permanent sas data set?