topic Re: %put statement not giving string and count in SAS Programming

%put statement not giving string and count

Ahmej — Sun, 08 Sep 2019 17:08:14 GMT

I am writing the below statement:
%put ***&act*** ***&n***
I am supposed to recieve string and count in log but no result is showing also log is clear.

Re: %put statement not giving string and count

novinosrin — Sun, 08 Sep 2019 17:09:36 GMT

Hello @Ahmej Welcome to SAS communities. Can you please post your code that creates those macro variables and the log. Thank you

Re: %put statement not giving string and count

Astounding — Sun, 08 Sep 2019 19:50:07 GMT

This statement is incomplete. If you would like it to execute, add a semicolon at the end of it:

%put ***&act*** ***&n***;

Re: %put statement not giving string and count

Ahmej — Mon, 09 Sep 2019 03:25:13 GMT

Still its not working

Re: %put statement not giving string and count

Ahmej — Mon, 09 Sep 2019 03:29:24 GMT

Proc sql;

Select distinct actlevel into:act seprated by "@" from sasuser.admit;

Select count(distinct actlevel) into:n from sasuser.admit;

%put ***&act**** ***&n*** ;

Re: %put statement not giving string and count

andreas_lds — Mon, 09 Sep 2019 08:36:16 GMT

And now please post the complete log, using the window displayed when clicking on the {i} button - that way the format is maintained and the log stays readable.

Re: %put statement not giving string and count

ballardw — Mon, 09 Sep 2019 15:15:24 GMT

SASUSER.ADMIN is unlikely to exist. You may need to share the actual content of that data set as well.

Or use a set that should be available to most such as SASHELP.CLASS;

Proc sql;

Select distinct sex into:act separated by "@" from sashelp.class;
quit;
%let n=&sqlobs;

%put ***&act.*** ***&n.***;

SAS creates an automatic variable named SQLOBS that contains the number of results returned from the most recent Proc SQL query. So no actual need to do the extra Select count.

Re: %put statement not giving string and count

Ahmej — Mon, 09 Sep 2019 15:32:45 GMT

Thank you so much its working now.

I got my result👍👍