topic calculate with a minimum from the variablelist in SAS Programming

calculate with a minimum from the variablelist

deleted_user — Wed, 25 Feb 2009 14:51:08 GMT

Hi all,

I have a variable x. Now I want to select some of the observations. I want to start with 10units above the minimum and end at minimum plus 30units.
but it doesnt work when I use
where x between min(x+10) and min(x+30);
The min Function take only singlenumbers limitetd by comma.

Have anybody an idea to solve this problem?

Thanks

Re: calculate with a minimum from the variablelist

sbb — Wed, 25 Feb 2009 23:29:41 GMT

You are correct - the WHERE statement (as the same with the IF stmt) will only interrogate the current observation. You need to use PROC SUMMARY/MEANS to generate a file containing the MIN and MAX as new variables, and then one option is to MERGE the resulting file back into your SAS file - then you have the MIN and MAX value range (again, as unique SAS variables created in the MEANS/SUMMARY step) to use in your WHERE statement.

Scott Barry
SBBWorks, Inc.

Re: calculate with a minimum from the variablelist

FredrikE — Thu, 26 Feb 2009 09:07:16 GMT

It might not be the beautiest of solutions, but works with smaller datasets:

Proc sql;
select *
from sashelp.class
where age between
(select min(age) + 2 from sashelp.class)
and
(select max(age) - 2 from sashelp.class)
;
quit;

//Fredrik