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 is proc Index? and what is proc document?

2643


what is the use of proc contents and proc print in sas? : Sas-administrator

1005


How do dates work in SAS data?

1130


What is the use of PROC gplot?

1070


how to debug and test the sas program? : Sas-administrator

989


what is sas and what are the functions? : Sas-administrator

938


hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana

5389


What is a put statement?

1149


What is the command used to find missing values?

1047


How to test the debugging in sas?

1118


What are the parameters of scan function?

1117


I have a dataset concat having variable a b & c. How to rename a b to e & f?

970


how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1284


How to read an input file in sas?

1101


What are the statements in proc sql?

1053