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


Please Help Members By Posting Answers For Below Questions

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

550


What are the limitations for memory allocation for SAS variables

934


What do the mod and int function do? : Sas programming

586


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

806


how to change the execute of macro

1684






Explain the purpose of substr functions in sas programming.

569


what is the use of proc sql? : Sas programming

600


How can I remove header from output data set?

2066


What are the different operating system platforms in which we can use sas? : sas-grid-administration

595


for report generation which one you used proc report or data_null_?

6610


what is the use of sas management console? : Sas-di

615


Which date function advances a date, time or datetime value by a given interval?

672


How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

1589


is data integration and etl programming is same? : Sas-di

578


Explain what is data step?

733