topic Re: proc and subsetting in SAS Programming

proc and subsetting

current_thing — Mon, 04 Dec 2023 21:30:31 GMT

I read on this forum that IF and WHERE statements can be used in Data step, but in proc steps only IF can be used. I've tried it and in proc means, for example, if can't be used but where can. Is this true for all proc steps? Thanks!

Re: proc and subsetting

yabwon — Mon, 04 Dec 2023 21:33:54 GMT

Show the code. And log.

Re: proc and subsetting

sbxkoenk — Mon, 04 Dec 2023 21:36:25 GMT

In PROC (PROCEDURE) steps, only WHERE can be used!

There are very few PROCs that allow for (data-step-like) programming statements (NLIN, NLMIXED, MCMC, MODEL, REPORT, ...). In these PROCs you can also use "IF", but in the big majority of PROCS no "IF" is allowed, only "WHERE".

Koen

Re: proc and subsetting

Reeza — Mon, 04 Dec 2023 21:49:44 GMT

WHERE is what is used in PROCs, IF is primarily data steps and some select procedures that allow for data manipulation.

Re: proc and subsetting

PaigeMiller — Mon, 04 Dec 2023 21:58:36 GMT

I read on this forum that IF and WHERE statements can be used in Data step

But the two statements, IF and WHERE, are not completely interchangeable, there are times when only IF will work and vice versa.

https://documentation.sas.com/doc/en/pgmmvacdc/9.4/lestmtsref/p1cxl8ifdt8u0gn12wqbji8o5fq1.htm#p08fp02gyb04apn1fmq0a6cu3ynd

but in proc steps only IF can be used

As others have pointed out, most PROCs only allow WHERE and do not allow IF (there are a few exceptions).

Re: proc and subsetting

ballardw — Fri, 08 Dec 2023 17:42:43 GMT

@current_thing wrote:

I read on this forum that IF and WHERE statements can be used in Data step, but in proc steps only IF can be used. I've tried it and in proc means, for example, if can't be used but where can. Is this true for all proc steps? Thanks!

Post a link to the post that says "but in proc steps only IF can be used."

I will hope that you are not confusing the macro language %if with the data step if as they serve two quite different roles. There is no macro language "%where" provided by SAS (I won't say that someone hasn't written a macro function with that name) so is a possible source of confusion for those that haven't become familiar enough with SAS.

Re: proc and subsetting

current_thing — Fri, 08 Dec 2023 16:51:43 GMT

Yikes, I misread it. I went back to this forum and it actually said the reverse of what I put in the post 🙄