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)

Differences between where and if statement?

778

---

name several ways to achieve efficiency in your program? : Sas programming

755

---

how the sas basic syntax style described? : Sas-administrator

790

---

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

2521

---

what is star schema? : Sas-di

832

---

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

802

---

how to remove duplicates using proc sql?

854

---

Name any two sas spawners? : sas-grid-administration

767

---

how does sas handle missing values in functions? : Sas programming

815

---

Mention what are the data types does SAS contain?

902

---

what techniques and/or procs do you use for tables? : Sas programming

782

---

What is the function of output statement in a SAS Program?

797

---

What are the best sas programming practices for handling very large datasets? : sas-grid-administration

753

---

what is the difference between floor and ceil functions in sas? : Sas-administrator

917

---

what do the mod and int function do? What do the pad and dim functions do? : Sas programming

862

---