topic Re: Macro error while performing logistic regression of each independent variable against Target var in SAS Data Science

Macro error while performing logistic regression of each independent variable against Target variabl

mohsinm — Thu, 04 Jan 2024 15:13:47 GMT

Hi all,

I have a list of multiple independent variables. I want to run a logistic regression model of each independent variable against an dependent variable and the same process should be repeated for each independent variable against the same target variable and the output statistics should be saved in a dataset.

I am using SAS Viya 3.5 version.

However, while running the code mentioned in the last, it is showing the following error.

ERROR: The %DO statement is not valid in open code.

ERROR: The %end statement is not valid in open code.

Is there any other way through which I can get the similar output?

Thanks.

%let dependent_variable = Cholesterol_Status;

%let independent_variables = AgeAtStart Smoking_Status;

%let variable_list = %scan(&independent_variables, 1);

%let i = 1;

%do %while (%length(%scan(&independent_variables, &i)) > 0);

%let current_variable = %scan(&independent_variables, &i);

proc logistic data=mycaslib.mydata;

model &dependent_variable = &current_variable;

score data=mycaslib.mydata out=out_rstore;

run;

%let i = %eval(&i + 1);

%end;

Re: Macro error while performing logistic regression of each independent variable against Target var

Quentin — Thu, 04 Jan 2024 15:19:20 GMT

As the error says, they %DO statement cannot be used in open code, which means outside of a macro definition.

Typically code like you showed would be inside a macro definition, which starts with a %MACRO statement and ends with a %MEND statement. Do you see those statements in the code you used as an example to write this code?

Re: Macro error while performing logistic regression of each independent variable against Target var

PaigeMiller — Thu, 04 Jan 2024 15:37:36 GMT

Macros not needed here, please see this article and in particular the section entitled "The BY way for many models". The article also asserts that this is more efficient than doing this via a macro. (And the programming is already done for you)

Re: Macro error while performing logistic regression of each independent variable against Target var

mohsinm — Fri, 19 Jan 2024 11:52:06 GMT

@PaigeMiller but it is given for linear regression and not for logistic regression. In the comment also complete solution is not given. Thanks.

Re: Macro error while performing logistic regression of each independent variable against Target var

PaigeMiller — Fri, 19 Jan 2024 13:05:44 GMT

@mohsinm wrote:

@PaigeMiller but it is given for linear regression and not for logistic regression.

@mohsinm Yes, you have to replace the PROC REG code with the desired PROC LOGISTIC code.

In the comment also complete solution is not given.

I don't know why you say it is not complete. It looks complete to me. What is missing?