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

Are you involved in writing the inferential analysis plan? Tables specifications?

4004


Explain the main difference between the sas procedures and functions? : Sas-administrator

1112


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

1103


What was the last computer book you purchased? Why?

2418


what is operational data and operational system? : Sas-di

1155


How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?

1403


What are the data types that sas contain?

1246


What are the different versions of sas that you have used until now? : sas-grid-administration

1389


How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1728


what is sas database server? : Sas-di

1189


If a variable contains letters or special characters, can it be numeric data type?

1278


What is SAS? What are the functions does it performs?

1243


what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1148


If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?

1206


In sas, what are the areas that you are most interested in? : sas-grid-administration

1129