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 is proc sort?

1305


What is the maximum and minimum length of macro variable

1335


what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming

1294


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


How does proc sql work?

1144


What is a method to debug and test your SAS program?

1434


how do you want missing values handled? : Sas programming

1010


What is SAS informats?

1160


how would you create multiple observations from a single observation? : Sas programming

1051


How we can create SAS USER DEFINED CODE?

2148


Difference between nodup and nodupkey options?

1268


How to read an input file in sas?

1191


Of all your work, where have you been the most successful?

4715


In ARRAY processing, what does the DIM function do?

1230


explain the main difference between the nodup and nodupkey options? : Sas-administrator

1219