How to convert .xls file into CSV format?

Answers were Sorted based on User's Feedback



How to convert .xls file into CSV format?..

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

How to convert .xls file into CSV format?..

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

How to convert .xls file into CSV format?..

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

How to convert .xls file into CSV format?..

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

How to convert .xls file into CSV format?..

Answer / naveen

in excel just go on file then press save as and then click
on save type there you will find out csv comma delimiter,

Is This Answer Correct ?    0 Yes 0 No

How to convert .xls file into CSV format?..

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

Post New Answer

More SAS Interview Questions

Explain data_null_?

0 Answers  


Explain why double trailing @@ is used in input statement?

0 Answers  


How to sort in descending order?

0 Answers  


What are all the problems you faced while validating tables and reports?

0 Answers   Accenture, Quintiles,


i have a dataset with 100000 records. i want 100 records from that dataset and create a dataset.we need to pick the observations random order like 100obs,500obs,1020obs,1890obs,2565obs like that i need 100 obs in random order? how can we create this one?

5 Answers   L&T,


how does sas handle missing values in functions? : Sas programming

0 Answers  


What are the differences between sum function and using “+” operator?

0 Answers  


how many data types in sas? : Sas-administrator

1 Answers  


my problem is to export my report to xsl.i can do that.but the problem is my report has 3 headings first heading should be printed with the merging of (1-5)cells and heading 2 should be of merge(2-4)cells?how to do this condition?

2 Answers   Dr Reddys, Oracle,


what is null hypothesis? why do you consider that?

0 Answers   Accenture, Quintiles,


how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.

1 Answers   TCS,


Can Some one Explain How the Datasets from SAS can be loaded in to the MVS OS?

1 Answers   HCL,


Categories