what this statement means

[juliajulia]

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;

[MarkDawson · Accepted solution]

"Select 100 as st,..." creates a numeric column called "st" with a value of 100 - in a data step it would be st = 100 ; Basically it's just creating a a constant value

[Kurt_Bremser]

The 100 seems to be a number greater as anything found in st, so this adds a summary row to the dataset.

[juliajulia]

thanks both of you!

[FreelanceReinh]

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.