Someone suggest:
proc sql noprint;
select count(*) into :observations from library.dataset;
quit;
Would anybody tell me what to do next? Thanks.
This creates a macro variable holding the count. You could write it out:
%put &observations;
Or a DATA step could use it:
n_obs = &observations;
When the emoticon replacing your actual code, it's difficult to determine what the exact name of your macro variable is ... &observations, or &n_observations, or something similar.
What is your goal? What do you want to achieve?
get the total number of obs
This creates a macro variable holding the count. You could write it out:
%put &observations;
Or a DATA step could use it:
n_obs = &observations;
When the emoticon replacing your actual code, it's difficult to determine what the exact name of your macro variable is ... &observations, or &n_observations, or something similar.
Try SASHELP.VTABLE or the corresponding dictionary table.
proc sql noprint;
select nobs into :nobs_class TRIMMED
from sashelp.vtable
where libname='SASHELP' and memname='CLASS';
quit;
%put Number of obs = &nobs_class;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.