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?
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?
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 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.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.