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

How do you delete duplicate observations in sas?

799


What is the use of PROC gplot?

857


Where do you use proc means over proc freq?

752


Do you know the features of sas?

800


Mention common programming errors committed in sas ?

833


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1670


what are some differences between proc summary and proc means? : Sas programming

746


How does the internal authentication work in sas? : sas-grid-administration

812


How would you define the end of a macro?

875


What is the role of sas grid administrator? : sas-grid-administration

1047


Are you sensitive to code walk-throughs peer review or QC review?

2882


explain the main difference between the nodup and nodupkey options? : Sas-administrator

913


What are the default statistics that proc means produce?

789


where to use sas business intelligence? : Sas-bi

773


what are the considerations when picking a SAS/STAT procedure?

3117