How to convert .xls file into CSV format?
- 6 Answers
- 21432 Views
- Quintiles, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / manjunath wadi
It is very simple.
1. Click on "FILE" menu of the MS Excel file
2. Select "Save As" Option and click on that
3. Now you can see a dialog box "Save As", type the file
name select location to save
4. Select the option CSV(comma delimited)option from Save as
Type drop down box and click Save button.
Its Done!
Note: Only active worksheet can be saved if you are saving
your file in CSV format
| Is This Answer Correct ? | 16 Yes | 5 No |
Answer / 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 |
Answer / paul
step#1:Import excel file into SAS
proc import datafile='file location/filename.xls'
out=datasetname dbms=excel replace;
sheet='sheetname$';
getnames=yes;
run;
step#2: Export file to csv file.
data _null_;
set datasetname;
file 'location/file1.csv';
put <var list> ;
run;
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
Answer / khaja
%macro imp (datasetname=,path=,fname=)
proc import out=&datasetname
datafile = "&path"
dbms = "&fname" replace;
getnames=yes;
run;
%mend;
%imp(datasetname=xyz,path="D:\docs...",fname=csv)
if you want to convert into txt,xls,mdb then simply you use
%imp(datasetname=xyz,path="D:\docs...",fname=mdb)
%imp(datasetname=xyz,path="D:\docs...",fname=txt)
%imp(datasetname=xyz,path="D:\docs...",fname=.xls)
| Is This Answer Correct ? | 0 Yes | 0 No |
Which date functions advances a date time or date/time value by agiven interval?
What are the difference between the sas data step and sas procs?
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
What is substr function?
WHAT DIFFERRENCE DID YOU FIND AMONG VERSION 6 8 AND 9 OF SAS.
what is slowly changing dimension? : Sas-di
what is sas metadata server? : Sas-di
How can you create a macro variable with in data step? : sas-macro
What is by-group processing?
Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?
name several ways to achieve efficiency in your program? : Sas programming
what is sas metadata repository? : Sas-bi
Teradata 
