macros

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

macros

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?


Accepted Solutions
Solution
‎08-22-2017 12:10 PM
Super User
Posts: 20,219

Re: macros

[ Edited ]
Posted in reply to prasanth8179

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?


 

View solution in original post


All Replies
Solution
‎08-22-2017 12:10 PM
Super User
Posts: 20,219

Re: macros

[ Edited ]
Posted in reply to prasanth8179

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?


 

New Contributor
Posts: 2

Re: macros

tq very much.....and DNAME will be as output dataset name or else std_data
as output name
Super User
Posts: 20,219

Re: macros

Posted in reply to prasanth8179

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.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 105 views
  • 0 likes
  • 2 in conversation