topic Re: Macro language question in SAS Programming

Macro language question

mitrakos — Tue, 06 Aug 2024 15:18:20 GMT

Hi Everyone,

I have a logistic regression program that I am using that contains a where clause. The where clause is used to to filter between a variable that has seven levels, they are 1, 3, 4, 7, 10, 13, and 14. I'd like to create a macro to go through this variable and run the logistic regression for each level, but I'm unsure as to how to go about it. Below is the logistic regression code with the where clause set to 1:

proc logistic data=have;
class v1(ref="3" param=ref) v2(ref="1" param=ref) v3(ref="3"
param=ref) v4(ref="White" param=ref) v5(ref="0" param=ref)
v6(ref="1" param=ref);
model dv(event="1")=v1 v2 v3 v4 v5 v6
where project = 1;
run;

I've tried doing %let project = (1, 3, 4, 7, 10, 13, 14) and having where project = &project but that gave me an error.

Any resources to help or guide me along would be amazing, thank you so much!

Re: Macro language question

PaigeMiller — Tue, 06 Aug 2024 15:30:57 GMT

No macros needed. Replace the WHERE statement with a BY statement.

by project;

In data set HAVE, remove any project numbers except 1, 3, 4, 7, 10, 13, 14

Re: Macro language question

Tom — Tue, 06 Aug 2024 15:33:45 GMT

Make sure the dataset is sorted by PROJECT and then use:

by project;
where project in (1 3 4 7 10 13 14);

Re: Macro language question

mitrakos — Tue, 06 Aug 2024 17:01:04 GMT

Oh my god!! I was over thinking it, thank you so much!