topic Re: Importing by using macro in SAS Procedures

Importing by using macro

deleted_user — Fri, 06 Mar 2009 10:21:39 GMT

i have aimport code how can i keep it in macro and reuse it the code is here now i want to change the outfile and datafile only by using macro.

PROC IMPORT OUT= WORK.ASd
DATAFILE= "C:\Documents and Settings\Ma
r\dq_sample.xls"
DBMS=EXCEL5 REPLACE;
GETNAMES=YES;
RUN;

Re: Importing by using macro

sbb — Fri, 06 Mar 2009 10:34:06 GMT

Macros are executed, optionally with macro variable substition on the command line. Then, the macro variable reference is made using a &varname, as shown below:

%MACRO MYMACRO(MYVAR);
%PUT MYVAR IS SUBSTITUTED AS: &MYVAR;
%MEND MYMACRO;
%MYMACRO(some_value);

Refer to the SAS Macro Language documentation at the SAS support website http://support.sas.com/ and the DOC web page:

http://support.sas.com/documentation/onlinedoc/91pdf/index.html

http://support.sas.com/onlinedoc/913/getDoc/en/mcrolref.hlp/a002293969.htm

Scott Barry
SBBWorks, Inc.

Re: Importing by using macro

deleted_user — Mon, 09 Mar 2009 08:42:38 GMT

%macro import(output=,path=);
PROC IMPORT OUT= &output
DATAFILE= "&path"
DBMS=DLM REPLACE;
DELIMITER='7C'x;
GETNAMES=YES;
DATAROW=2;
RUN;
%mend;

%import(output=ss,path=C:\SAM\DQ\Data\SQL Data\CITY_PIN3.txt);