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)

What are the criticality that you have faced during your project in SAS?

2 Answers  

PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?

7 Answers   HP,

How will you assign all the variables of an dataset into a macro variable separated by a space? For example if a dataset has variables A,B,C. Assign them to a macro variable X as X=A B C

3 Answers   Accenture, Oracle,

I need to find the numeric field which contains blank in between..Ex:123 456...there is blank in between the 123 456..I need to know if there is any SAS function to find a field.. Please suggest...

5 Answers   TCS,

Explain what is data step?

0 Answers  

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

0 Answers  

proc means? proc sort? proc append? proc freq? proc print? proc content?

4 Answers   Oracle,

Differentiate between sas functions and sas procedures.

0 Answers  

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

0 Answers  

Explain input and put function?

0 Answers  

What is substr function?

0 Answers  

what is the need of INDEX in datasets?

6 Answers   CitiGroup,