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 / krishna

proc import datafile=file.xls out=<datasetname> dbms=excel
replace;
sheet='sheetno$';
run;

proc export outfile=filepath data=<datasetname> dbms=csv
replace;
run;

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what are some good sas programming practices for processing very large data sets? : Sas programming

875


What is PROC in SAS?

1000


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

1236


Difference between sum function and using “+” operator?

1084


hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?

2035


Mention few capabilities of sas framework.

1126


what is metadata? : Sas-bi

968


What is the difference between using drop = data set option in data statement and set statement?

1105


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

999


Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma

3467


What is the SAS data set?

1082


How to create an external dataset with sas code?

1069


What does P-value signify about the statistical data?

1303


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1056


How do you specify the number of iterations and specific condition within a single do loop?

1050