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)

explain the concepts and capabilities of business object? : Sas-bi

543

---

Explain what is data step?

731

---

What does PROC print, and PROC contents do?

730

---

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

1329

---

Describe crosslist option in tables statement?

715

---

---

What are the new features included in the new version of SAS Programming Language?

741

---

How to create an external dataset with sas code?

590

---

What is the use of stop statement?

646

---

what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming

694

---

How do you specify the number of iterations and specific condition within a single do loop?

626

---

How to test the debugging in sas?

610

---

what is the purpose of _error_? : Sas programming

612

---

How many data types are there in SAS?

636

---

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

632

---

What is the purpose of _character_ and _numeric_?

590

---