%put statement not giving string and count

[Ahmej]

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.

[novinosrin]

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

[Astounding]

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

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

[Ahmej]

Still its not working

[Ahmej]

Proc sql;

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

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

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

[andreas_lds]

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.

[ballardw · Accepted solution]

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.

[Ahmej]

Thank you so much its working now.

I got my result👍👍