topic Re: How to see value in macro variable in SAS Programming

How to see value in macro variable

thanikondharish — Wed, 12 Jun 2019 10:14:26 GMT

%let count=6;
Proc SQL Noprint;
Select distinct (age) into:A1-:A%left(&count) from sashelp.class;
Quit;
%put &A1 &&A&count;
How to see the value is assigned or not in last macro variable
&A1--------- it is showing some value
&&A&count------it is not

Re: How to see value in macro variable

Kurt_Bremser — Wed, 12 Jun 2019 10:39:52 GMT

It IS showing, see this log of your code:

24         %let count=6;
25         Proc SQL Noprint;
26         Select distinct (age) into:A1-:A%left(&count) from sashelp.class;
27         Quit;
NOTE: PROZEDUR SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

28         %put &A1 &&A&count;
11 16

Re: How to see value in macro variable

thanikondharish — Wed, 12 Jun 2019 11:27:17 GMT

Sorry previous something happened

Re: How to see value in macro variable

Tom — Wed, 12 Jun 2019 13:58:21 GMT

The INTO clause only creates the macro variables that it needs. So if the query result had less than 6 observations then less than 6 macro variables will be written.

Re: How to see value in macro variable

Tom — Wed, 12 Jun 2019 14:50:36 GMT

Why are you setting COUNT before you run the query? Why do you have the %LEFT() call? Does you value of COUNT have leading spaces? Why did you put leading spaces into the macro variable COUNT? Also why are you only calling %LEFT() in one of the two places you use count?

SAS can count for you. No need to count in advance or set an upper limit on the number of macro variables to create.

proc sql noprint;
  select distinct (age) into :A1- from sashelp.class;
%let count=&sqlobs;
quit;
%put &=count &A1 &&A&count;

Re: How to see value in macro variable

ballardw — Wed, 12 Jun 2019 14:51:59 GMT

@thanikondharish wrote:
Sorry previous something happened

Then show the entire log of what happens when you run your code.

I believe that we have asked for your do provide LOG results in the past. Again,