topic When to use %if %then/%else and if then /else in SAS in SAS Programming

When to use %if %then/%else and if then /else in SAS

himself — Sat, 20 Mar 2021 19:16:20 GMT

Hi, kindly help me find a reference book, article of when to use %if %then/%else and if then /else in SAS. I think I have been confusing the two.

Any link to the article or book will be highly appreciated.

Re: When to use %if %then/%else and if then /else in SAS

Tom — Sat, 20 Mar 2021 20:47:16 GMT

In general:

You use IF statements in data steps to test the values of variables in your datasets to see what statements in your data step you want to execute in this iteration of the data step.

You use %IF statements in macro code (or now in open code also) to test macro variable values to determine what SAS code you want to generate.

Re: When to use %if %then/%else and if then /else in SAS

himself — Sat, 20 Mar 2021 20:50:09 GMT

Hi, thanks so so much for this, could be having a reference, material please. Thanks