topic Re: Where is working as a option but is not working as a statement. Why? in New SAS User

Where is working as a option but is not working as a statement. Why?

POOJA_J — Wed, 11 Oct 2023 12:29:03 GMT

I'm learning to code macros. Once macro is created I want to check that and so I used proc catalog. My question is why WHERE doesn't give required results as a Statement. But using it as an option gives results. I assumed WHERE should give results when used either as a Statement or Option. Plz explain the logic behind this.

Re: Where is working as a option but is not working as a statement. Why?

Tom — Wed, 11 Oct 2023 12:33:23 GMT

Because PROC CATALOG does not support the WHERE statement.

What purpose would the WHERE statement even do for PROC CATALOG? It does not read in any datasets so what could the WHERE clause be applied to?

Re: Where is working as a option but is not working as a statement. Why?

PaigeMiller — Wed, 11 Oct 2023 12:41:52 GMT

@POOJA_J wrote:

I'm learning to code macros. Once macro is created I want to check that and so I used proc catalog. My question is why WHERE doesn't give required results as a Statement. But using it as an option gives results. I assumed WHERE should give results when used either as a Statement or Option. Plz explain the logic behind this.

Your question really has nothing to do with the small macro you wrote. But ... since @Tom has already questioned your use of WHERE in PROC CATALOG, let me point out that in order to write macros that work, you need to first have SAS code without macros and without macro variables that works properly. If you can't write such code without macros and without macro variables, then you will never get macros to work.

Re: Where is working as a option but is not working as a statement. Why?

Kurt_Bremser — Wed, 11 Oct 2023 12:56:05 GMT

A WHERE statement in a procedure is applied to (a) dataset(s) being read by the procedure. Since you do not (and can not) read a dataset with PROC CATALOG, the statement cannot be supported.

Re: Where is working as a option but is not working as a statement. Why?

POOJA_J — Wed, 11 Oct 2023 13:01:56 GMT

Studying videos from the SAS, below is how they applied. So I came up with question of applying WHERE as a statement.