Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How to convert .xls file into CSV format?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does P-value signify about the statistical data?

1364


why is sas considered self-documenting? : Sas programming

1147


How to sort in descending order?

1259


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

1114


How to convert a numeric variable to a character variable?

1210


How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1539


Explain proc sort?

1117


how to do user inputs and command line arguments in sas?

3049


why is a stop statement needed for the point=option on a set statement? : Sas programming

1086


Where do you use proc means over proc freq?

1122


What do you know about symput and symget?

1251


what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1256


explain the difference between proc means and proc summary?

1126


How substr function works in sas?

1223


What is the maximum and minimum length of macro variable

1255