topic Re: macros in SAS Programming

macros

prasanth8179 — Tue, 22 Aug 2017 15:59:58 GMT

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?

Re: macros

Reeza — Tue, 22 Aug 2017 16:06:48 GMT

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?

Re: macros

prasanth8179 — Tue, 22 Aug 2017 16:13:01 GMT

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

Re: macros

Reeza — Tue, 22 Aug 2017 16:36:32 GMT

@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.