where statement in proc model

Accepted Solution Solved
Reply
Super Contributor
Posts: 303
Accepted Solution

where statement in proc model

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;


Accepted Solutions
Solution
‎12-30-2013 10:45 PM
Super Contributor
Posts: 644

Re: where statement in proc model

Posted in reply to desireatem

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

View solution in original post


All Replies
Respected Advisor
Posts: 4,173

Re: where statement in proc model

Posted in reply to desireatem

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

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

Super User
Super User
Posts: 7,050

Re: where statement in proc model

Posted in reply to desireatem

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;

Solution
‎12-30-2013 10:45 PM
Super Contributor
Posts: 644

Re: where statement in proc model

Posted in reply to desireatem

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

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 197 views
  • 6 likes
  • 4 in conversation