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

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;

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;

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;

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,

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)

how can you get the single data set from the library(which has the number of data sets)?

3 Answers   Accenture, Deloitte,

What is difference between N and n????

2 Answers   Sciformix,

What is highest missing value for numeric?

1 Answers  

create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers   WNS,

what is Global Symbol table and Local symbol table?

4 Answers   CitiGroup,

In sas, what are the areas that you are most interested in? : sas-grid-administration

0 Answers  

What is Linear Regression?

0 Answers  

What is data _null_?

0 Answers  

Explain by-group processing?

0 Answers  

How to Rename Library?

3 Answers  

What is the difference between SAS Data step and SAS PROC SQL, and which is better?

1 Answers   TCS,

What can you learn from the SAS log when debugging?

0 Answers   Quintiles,