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;
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
i haven't seen it this way in the documentation. You can always use below syntax instead:
data=a(where=(t=1))
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;
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.