topic Re: SAS sql steps in SAS Programming

SAS sql steps

Abishekaa — Mon, 01 Aug 2022 13:59:09 GMT

I saw this code posted in reply to an old post. Could someone please explain the sql steps here?

1) The meaning of Difference/COL1 statement?

2) The inner join with i= and j= statements?

proc sql;
select
     aCL.*,
     Difference/COL1 as diffStdErr label="Difference Std Err"
from
     aCL inner join
     aDiffT on i = input(RowName,4.) and j = input(_LABEL_, 4.);
quit

FYI here is the post: Solved: How to get standard error of difference of ls-mean... - SAS Support Communities

Re: SAS sql steps

Tom — Mon, 01 Aug 2022 14:04:34 GMT

@Abishekaa wrote:

I saw this code posted in reply to an old post. Could someone please explain the sql steps here?

1) The meaning of Difference/COL1 statement?

2) The inner join with i= and j= statements?

1) That is a division operator. The result of dividing those two variables will become the new variable diffStdErr .

2) Those are equality tests. So (i = input(RowName,4.)) will be true when the result of converting the first 4 bytes of ROWNAME into a number is a value that matches the value of the variable named I.

Re: SAS sql steps

SuCheeTay — Mon, 01 Aug 2022 20:54:58 GMT

Difference/COL1 as diffStdErr label="Difference Std Err"

This is only a query and Difference/COL1 is a division expression and it's value will be displayed under the new column aliased as diffStdErr but the label= assigned a label so Difference Std Err will be in the column header of the query result.

on i = input(RowName,4.) and j = input(_LABEL_, 4.)

The aCL and aDiffT are inner joined on the criteria based on values of column i= converted values of RowName and values of column j= converted values of _LABEL_.