topic Re: Call symput in SAS Programming

Call symput

Babloo — Sat, 13 Oct 2018 15:36:55 GMT

Could you please help me understand what will be the value of the macro variable 'brn' from the following code?

   data _null_ ;                                  
    call symput('brn'," and p2kbrn in ('1','2','3','4','5','6','8')") ;
   run ;

Re: Call symput

Kurt_Bremser — Sat, 13 Oct 2018 15:45:52 GMT

@Babloo wrote:

Could you please help me understand what will be the value of the macro variable 'brn' from the following code?

   data _null_ ;                                  
    call symput('brn'," and p2kbrn in ('1','2','3','4','5','6','8')") ;
   run ;

That is glaringly obvious, if you're not too lazy to take a few minutes to read the documentation.

Re: Call symput

data_null__ — Sat, 13 Oct 2018 15:50:58 GMT

You just need a %PUT

117  data _null_ ;
118     call symput('brn'," and p2kbrn in ('1','2','3','4','5','6','8')") ;
119     run;

NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds


120  %put NOTE: &=brn;
NOTE: BRN= and p2kbrn in ('1','2','3','4','5','6','8')

Re: Call symput

Tom — Sat, 13 Oct 2018 16:25:44 GMT

@Babloo wrote:

Could you please help me understand what will be the value of the macro variable 'brn' from the following code?

   data _null_ ;                                  
    call symput('brn'," and p2kbrn in ('1','2','3','4','5','6','8')") ;
   run ;

The value of the second argument to CALL SYMPUT. So the characters inside the double quotes.

Re: Call symput

ballardw — Mon, 15 Oct 2018 15:40:29 GMT

@Babloo wrote:

Could you please help me understand what will be the value of the macro variable 'brn' from the following code?

   data _null_ ;                                  
    call symput('brn'," and p2kbrn in ('1','2','3','4','5','6','8')") ;
   run ;

Large economy sized hint: NO data set for variables => no other variables available.

Warning: &brn is likely to cause issues if passed as a macro parameter elsewhere.