topic Re: Definiy key variables as macro variable by using proc format in SAS Enterprise Guide

Definiy key variables as macro variable by using proc format

Jomaa — Thu, 21 Sep 2017 18:38:42 GMT

Hi All,

If I have this format

proc format;

VALUE $DOM

'AE' = 'USUBJID AETERM AESTDTC'

'CE' = 'USUBJID CETERM CESTDTC'

'CM' = 'USUBJID CMTRT CMROUTE CMSTDTC'

'DD' = 'USUBJID'

'DM' = 'USUBJID'

;

run;

I have the macro variables which take the value AE, CE etc, how can I definy a new macro variable which will take 'USUBJID AETERM AESTDTC' for AE??

Thanks

Re: Definiy key variables as macro variable by using proc format

PaigeMiller — Thu, 21 Sep 2017 18:43:21 GMT

For example

data _null_;
    call symputx("newmacrovariable",put("&origmacrovariable",$dom.));
run;

As a side issue (but it may be relatively important), you don't normally apply formats to macro variables, and it may be there's an easier way to achieve whatever it is you are doing without macro variables, or without formats. I can say more because I'd need a lot more details about what you are doing.

Re: Definiy key variables as macro variable by using proc format

Astounding — Thu, 21 Sep 2017 18:44:33 GMT

%let newvar = %sysfunc(putc(&oldvar, $dom));

Re: Definiy key variables as macro variable by using proc format

Jomaa — Thu, 21 Sep 2017 18:50:36 GMT

Thanks so much..your code above gave me what I want. Actually I'm comparing old vs current transfer, I have the list of domains in a macro variable, I need to associate it with key variables.