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 run-group processing?

1240

---

what are informats in sas? : Sas-administrator

1146

---

If you use a symput in a data step, when and where can you use the macro variable? : sas-macro

1135

---

WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2839

---

for whom is sas data integration studio designed? : Sas-di

1059

---

what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2227

---

Explain bmdp procedure?

1082

---

What are the difference between ceil and floor functions in sas?

1399

---

How to sort in descending order?

1298

---

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?

2509

---

What is the basic syntax style in SAS?

1226

---

What are the limitations for memory allocation for SAS variables

1545

---

Explain why double trailing @@ is used in input statement?

1114

---

State the difference between INFORMAT and FORMAT ?

1150

---

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

2273

---