topic Re: where statement in proc model in SAS Programming

where statement in proc model

desireatem — Tue, 31 Dec 2013 00:10:48 GMT

I wish to ask if I can use a where statement in proc model like this:

Proc model data=A;

where t=1;

V=F(x);

solve x /out=solution;

run;

Re: where statement in proc model

Patrick — Tue, 31 Dec 2013 00:35:49 GMT

i haven't seen it this way in the documentation. You can always use below syntax instead:

data=a(where=(t=1))

Re: where statement in proc model

Tom — Tue, 31 Dec 2013 03:44:17 GMT

Did you try it?

I copied this example from the help pages and added a WHERE statement.

proc model data=sashelp.citimon;

where date < '01JAN1990'd ;

lhur = 1/(a * ip + b) + c;

fit lhur;

run;

Re: where statement in proc model

RichardinOz — Tue, 31 Dec 2013 03:45:55 GMT

It is worth a try using the WHERE statement. SAS supports WHERE in a number of procs so unless it is specifically excluded in the Proc MODEL doco it wil probably work.

Richard temporarily back in OZ