Solved
Valued Guide
Posts: 863

# sas macro

I am a little out of practice, I'd like to macro the following code so it will go through each unique 'pcpid' seperatley (from 1 %to end?) and put the pcpid on the graph as a label.  I'm thinking a simple macro loop with symputx to macro the variable through the loop but I don't know how to do it.  Any help will be appreciated:

title "PCPID = &pcpid";

proc gplot data=test;

symbol i=join v=circle h=2;

plot distance*month;

run;

Accepted Solutions
Solution
‎09-26-2013 08:48 AM
Super User
Posts: 8,069

## Re: sas macro

Why not just use a BY statement?

options nobyline;

title "PCPID = #byval(pcpid)";

proc gplot data=test;

by pcpid ;

symbol i=join v=circle h=2;

plot distance*month;

run;

All Replies
Valued Guide
Posts: 863

## Re: sas macro

or is this a situation for a symputx and symgetn?

Solution
‎09-26-2013 08:48 AM
Super User
Posts: 8,069

## Re: sas macro

Why not just use a BY statement?

options nobyline;

title "PCPID = #byval(pcpid)";

proc gplot data=test;

by pcpid ;

symbol i=join v=circle h=2;

plot distance*month;

run;

Valued Guide
Posts: 863

## Re: sas macro

Awesome suggestion.  I'll have to read up on this option as it is new to me.  This did exactly what I wanted.

Thanks!

Super User
Posts: 8,069

## Re: sas macro

There are a number of writeups for how to do something like that. You might start with this one.

http://www.sascommunity.org/wiki/List_Processing_Basics_Creating_and_Using_Lists_of_Macro_Variables

Personally for really simple problems I normally create a single macro variable with a space delimited list of values using PROC SQL and remember the number of values by saving the value of the automatic macro variable SQLOBS.

proc sql noprint;

select name into :names separated by ' '

from sashelp.class;

%let n=&sqlobs;

quit;

%do i=1 %to &n ;

%let name=%scan(&names,&i,%str( ));

.... &name ....

%end;

🔒 This topic is solved and locked.