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)

what is business intelligence? : Sas-bi

1056

---

what is data integration? : Sas-di

1108

---

what is sas enterprise intelligence architecture? : Sas-bi

973

---

What are pdv and it functions?

1132

---

What is the difference between class statement and by statement in proc means?

1280

---

I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry

1745

---

i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm

2364

---

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1136

---

what is snowflake schema? : Sas-di

1211

---

why is a stop statement needed for the point=option on a set statement? : Sas programming

1075

---

What sas features do you use to check errors and data validation?

1208

---

Explain the purpose of substr functions in sas programming.

1053

---

What is the use of stop statement?

1070

---

Hi, If anyone has base SAS certification dumps, please share.

1856

---

Explain bmdp procedure?

1025

---