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
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
Tell me about % include and % eval? : sas-macro
How will you generate test data with no input data?
In ARRAY processing, what does the DIM function do?
What’s the difference between var b1 – b3 and var b1 — b3?
Describe the function and untility of the most difficult SAS macro that you have written.
What are the default statistics for means procedure?
what are several options for creating reports in web report studio? : Sas-bi
Have you used macros? For what purpose you have used? : sas-macro
what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming
What is factor analysis?
For what purpose would you use the RETAIN statement?
what is sas metadata server? : Sas-di
What is the purpose of _character_ and _numeric_?
Are you involved in writing the inferential analysis plan? Tables specfications?