Creating a stored value from a table

bignate1030 · Posted 06-27-2019 11:55 AM

I have a table that looks like:

Event Table

---------------------------------

Event_A Table_A

Event_B Table_B

the 'table' column refers to another table that I need to load so I would like to save the first value under table (Table_A) into a macro variable for further use. (The values under 'Table' are dependent on filtered values from earlier in my program, thus they always change so I can't just hard code the value)

ScottBass · Posted 06-27-2019 11:39 PM

call symputx

Please post your question as a self-contained data step in the form of "have" (source) and "want" (desired results).
I won't contribute to your post if I can't cut-and-paste your syntactically correct code into SAS.

andreas_lds · Posted 06-28-2019 01:50 AM

What do you mean by "further use" if you process the tables using macros, you could use call execute to execute such a macro and pass the value of "Table" as parameter.

Creating a stored value from a table

Re: Creating a stored value from a table

Re: Creating a stored value from a table

Creating a stored value from a table

Re: Creating a stored value from a table

Re: Creating a stored value from a table

Registration is open

SAS Training: Just a Click Away