It's hard for me to get a full sense of what you are doing. You mentione
modifying a (slave) table, you mention macros that may be doing the
modifying, and it sounds like you may have information to drive the macros
in a control (master) dataset.
If that sounds close, I'd suggest you look at call execute.
It allows you to read in a control dataset that have data like:
And then call a macro %limitcheck once for each record in the control
dataset, so that you get
Hope that might help,
On Mon, 24 May 2004 23:28:00 -0700, Kevin Dezfulian <ggroups@FASTMAIL.FM>
>I am not new to programming, but new to SAS and find it rather
>Tasks that I would do easily in C, I can't get my head around in SAS.
>Perhaps I am taking the wrong approach. I hope someone here can help
>. . .
>I have a data table with 100-1000 variables and 1000+ observations.
>I wish to do some post processing on this table. In particular, scale
>all observations for certain variables, apply a new label, and delete
>observations that fall outside of the spec limits for certain
>I have ways to do all these things by hand. That is, to hard code
>data step manipulations for each variable. I have even improved
>things with macros. However, I wish to go one step further:
>I have created a second "master" table with a column containing all
>the variables in the "slave" data table. Additional columns include
>label name, spec limits, and a divisor for each variable.
>How do I manipulate the variables/observations in the slave table
>using lookups to the master table?
>Thanks in advance for your advice,