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

In proc transpose and data step with arrays which one you pick?

3099


Describe the function and untility of the most difficult SAS macro that you have written.

2201


explain the concepts and capabilities of business object? : Sas-bi

951


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

1045


How can sas program be validated?

1022


describe the interaction table in sas di? : Sas-di

1024


How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2451


What are common programming errors committed in sas

1135


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

1331


What was the last computer book you purchased? Why?

2368


what are the scrubbing procedures in sas? : Sas programming

1276


What is a macro routine?

2706


Differentiate input and infile.

1089


Name validation tools used in SAS

1169


How substr function works in sas?

1208