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 is the order of evaluation of the following operators + - * / ** () ???

2 Answers  

Explain the message 'Merge has one or more datasets with repeats of by variables'.

5 Answers  

Describe the function and utility of the most difficult SAS macro that you have written?

0 Answers   Oracle,

How to create list output for cross-tabulations in proc freq?

0 Answers  

what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

0 Answers  

Hot to suppress characters from a given string?

4 Answers   CTS,

Mention the validation tools used in SAS?

0 Answers  

You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..

3 Answers  

Explain what Proc glm does?

0 Answers  

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

0 Answers   Axis Bank,

The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?

6 Answers   Oracle,

What is the basic structure of the SAS base program?

0 Answers