topic Re: PROC SQL: Functions after WHERE not allowed. in SAS Procedures

PROC SQL: Functions after WHERE not allowed.

deleted_user — Tue, 27 Oct 2009 19:54:06 GMT

This code is incorrect:

proc sql;
create table new as
select * from old
where id in (select distinct id from old
where min(x) ge 5 and min(x) le 10);
quit;

I want ALL records for EACH individual(id) whose minimum value for x is in the interval [5,10].

How can I get those records?

Re: PROC SQL: Functions after WHERE not allowed.

abdullala — Tue, 27 Oct 2009 20:05:45 GMT

proc sql;
create table new as
select * from old
where calculated min(x) ge 5 and calculated min(x) le 10
group by id;
quit;

Re: PROC SQL: Functions after WHERE not allowed.

ChrisNZ — Wed, 28 Oct 2009 01:54:50 GMT

The code above does not work. Please check before posting.

I want ALL records for EACH gender whose maximum value for age is in the interval [16,17]:

select *
from sashelp.class
group by sex
having 16 le max(age) le 17
;