topic what this statement means in SAS Programming

what this statement means

juliajulia — Thu, 12 Nov 2020 17:17:07 GMT

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;

Re: what this statement means

MarkDawson — Thu, 12 Nov 2020 17:19:31 GMT

"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

Re: what this statement means

Kurt_Bremser — Thu, 12 Nov 2020 17:22:59 GMT

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

Re: what this statement means

FreelanceReinh — Thu, 12 Nov 2020 17:44:48 GMT

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.

Re: what this statement means

juliajulia — Thu, 12 Nov 2020 17:46:08 GMT

thanks both of you!