topic Re: global or local output variable? in SAS Programming

global or local output variable?

_LB — Tue, 04 Aug 2009 15:48:13 GMT

Hello all;

I have a macro that runs just fine. It is just that I want to call a piece of it somewhere else outside the macro without adding an additional data step. Code below followed by question:

%macro split (data=, var=, var1=, var2=);
proc sort data=&data(keep=&var &var1 &var2) out=values nodupkey;
by &var;
run;
data _null_;
set values end=last;
call symputx('M'||left(_n_),&var);
if last then call symput('count',_n_);
run;
%put _local_;
.....rest of macro

%mend split;
%split(data=HISTORY.ACUTEEXP, var=VISIT, Var1=start ,var2=end);

My question concerns the line:
if last then call symput('count',_n_);

I should be be able to call the "count" after the macro runs into anoter part of program?
If I try to call it, it remains unresolved.

Any solutions, greatly appreciated.

~Lawrence

Re: global or local output variable?

Peter_C — Tue, 04 Aug 2009 16:04:14 GMT

force the value into the global environment by replacing symput() with symputx(), like:

if last then call symputX('count',_n_, 'g' );

Re: global or local output variable?

_LB — Tue, 04 Aug 2009 16:10:39 GMT

Peter;
Worked like a charm!
Much Thanks!

Lawrence

Re: global or local output variable?

sbb — Tue, 04 Aug 2009 17:03:35 GMT

Also, here's a very useful and pertinent SAS support website http://support.sas.com/ DOC supplement tech note reference, found using the site's SEARCH facility:

Special Cases of Scope with the CALL SYMPUT Routine - SAS v9 DOC:
http://support.sas.com/documentation/cdl/en/mcrolref/61885/HTML/default/tw3514-symput.htm

Examples of Macro Variable Scopes - SAS v8 but still applies today:
http://v8doc.sas.com/sashtml/macro/z1072111.htm