where statement in proc model

Accepted Solution Solved
Reply
Super Contributor
Posts: 297
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

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: 3,887

Re: where statement in proc model

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: 6,498

Re: where statement in proc model

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

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.

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

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