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)

How do you control the number of observations and/or variables read or written?

1200

---

What is program data vector (pdv)?

1201

---

is data integration and etl programming is same? : Sas-di

1015

---

What is the basic structure of the SAS base program?

1241

---

What are the special input delimiters used in SAS?

1112

---

What is a macro routine?

2653

---

I have a dataset concat having a variable a b & c. How to rename a b to e & f?

1245

---

What are the ways in which macro variables can be created in sas programming?

1038

---

What are the statements in proc sql?

1053

---

explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1011

---

what is hash files in sas and why we are using this one in sas?

2162

---

what is sas application server? : Sas-di

1009

---

What does P-value signify about the statistical data?

1314

---

Describe 5 ways to do a “table lookup” in SAS?

1100

---

what other sas products have you used and consider yourself proficient in using? : Sas programming

1063

---