macros

[prasanth8179]

Importing %MACRO IMPORT(FILE,DNAME); PROC IMPORT DATAFILE="&FILE" OUT=&DNAME DBMS=EXCEL REPLACE; RUN; %MEND; %IMPORT(C:\DOCUMENTS AND SETTINGS\TSIPL0403\DESKTOP\KRISHNA\MACROS_EX\DATA1.XLS,STD_DATA);

in the above program DNAME refers for?

[Reeza · Accepted solution]

The output data set name. Post your code using the insert code button.

---

@prasanth8179 wrote:

Importing %MACRO IMPORT(FILE,DNAME); PROC IMPORT DATAFILE="&FILE" OUT=&DNAME DBMS=EXCEL REPLACE; RUN; %MEND; %IMPORT(C:\DOCUMENTS AND SETTINGS\TSIPL0403\DESKTOP\KRISHNA\MACROS_EX\DATA1.XLS,STD_DATA);

in the above program DNAME refers for?

---

[prasanth8179]

tq very much.....and DNAME will be as output dataset name or else std_data
as output name

[Reeza]

---

@prasanth8179 wrote:
and DNAME will be as output dataset name or else std_data
as output name

---

That's not correct, it will error out instead.