Hello,
i have a sas code writen by somebody. i don't understand what the select 100 mean in this statement. can somebody tell me what this means. thank you.
/**core medical services**/
proc sql;
create table t&year as
select providerstateid as stateid, b.* from
x&year a
left join
y&year b
on a.prid=b.prid
;
create table c as
select distinct st format=ST.,
count(distinct id) as total_clients from x&year group by st
union
select 100 as st, count(distinct id) as total_clients from x&year
order by stateid;
quit;
The 100 seems to be a number greater as anything found in st, so this adds a summary row to the dataset.
Hello @juliajulia,
Just to add to the preceding replies: Take a look at the definition of the numeric format ST.. One would expect that it assigns a label (such as 'Overall total') to the value 100 so that the summary row added by means of the UNION operator can be recognized as such.
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.