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

%macro imp (datasetname=,path=,fname=)
proc import out=&datasetname
datafile = "&path"
dbms = "&fname" replace;
getnames=yes;
run;
%mend;
%imp(datasetname=xyz,path="D:\docs...",fname=csv)

if you want to convert into txt,xls,mdb then simply you use

%imp(datasetname=xyz,path="D:\docs...",fname=mdb)
%imp(datasetname=xyz,path="D:\docs...",fname=txt)
%imp(datasetname=xyz,path="D:\docs...",fname=.xls)

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks

2197


Tell me about % include and % eval? : sas-macro

1093


How will you generate test data with no input data?

1098


In ARRAY processing, what does the DIM function do?

1111


What’s the difference between var b1 – b3 and var b1 — b3?

1275


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

2051


What are the default statistics for means procedure?

1162


what are several options for creating reports in web report studio? : Sas-bi

1074


Have you used macros? For what purpose you have used? : sas-macro

989


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

989


What is factor analysis?

1073


For what purpose would you use the RETAIN statement?

1462


what is sas metadata server? : Sas-di

1045


What is the purpose of _character_ and _numeric_?

1007


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

2505