topic Re: Warning after proc reg in Statistical Procedures

Warning after proc reg

Dianasoria — Mon, 12 Dec 2022 14:05:04 GMT

Hello!

I am running a linear regression model in SAS 9.4 for UNIX using the following code:

data n2_mc_cog_a;
set n2_mc_cog;
if mr93oc5f ne .;
run;

%macro explore (dep=, indep=) ;
proc reg data=n2_mc_cog_a;
**base model-MAIN;
model &dep=&indep age93 agecog raced1 /clb ;

%mend explore ;

%explore (dep= outcome1, indep= mr93c4d2 mr93c4d3 mr93c4d4) ;
%explore (dep=outcome2, indep= mr93c4d2 mr93c4d3 mr93c4d4) ;
%explore (dep=outcome3, indep= mr93c4d2 mr93c4d3 mr93c4d4) ;

I keep getting the following warning

13864⚠️ The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.

Can anyone help me get rid of the warning?

Thank you!

Re: Warning after proc reg

data_null__ — Mon, 12 Dec 2022 14:54:09 GMT

Does data set "n2_mc_cog" have a variable _TYPE_ or _NAME_. You could rename or drop.

@Dianasoria wrote:

Hello!

I am running a linear regression model in SAS 9.4 for UNIX using the following code:

data n2_mc_cog_a;
set n2_mc_cog;
if mr93oc5f ne .;
run;

%macro explore (dep=, indep=) ;
proc reg data=n2_mc_cog_a;
**base model-MAIN;
model &dep=&indep age93 agecog raced1 /clb ;

%mend explore ;

%explore (dep= outcome1, indep= mr93c4d2 mr93c4d3 mr93c4d4) ;
%explore (dep=outcome2, indep= mr93c4d2 mr93c4d3 mr93c4d4) ;
%explore (dep=outcome3, indep= mr93c4d2 mr93c4d3 mr93c4d4) ;

I keep getting the following warning

13864⚠️ The variable _NAME_ or _TYPE_ exists in a data set that is not TYPE=CORR, COV, SSCP, etc.

Can anyone help me get rid of the warning?

Thank you!

Re: Warning after proc reg

Rick_SAS — Mon, 12 Dec 2022 14:55:41 GMT

Apparently, your input data set contains a variable that has a special name that SAS uses for special purposes. You can use PROC CONTENTS to figure out which variable names you have:

proc contents data=n2_mc_cog_a short varnum;
run;

Since the variable is not important in the regression, you can DROP it from the analysis, like so:

data n2_mc_cog_a;
set n2_mc_cog;
if mr93oc5f ne .;
drop _NAME_ _TYPE_;  /* probably only need one of these variable names */
run;

Re: Warning after proc reg

Dianasoria — Mon, 12 Dec 2022 20:36:28 GMT

Thank you! I identified the variable causing the problem and dropped it

Re: Warning after proc reg

Dianasoria — Mon, 12 Dec 2022 20:38:37 GMT

Thank you, Rick.

This step helped me to identify the variable causing the problem. I dropped the variable and I no longer get the warning.

proc contents data=n2_mc_cog_a short varnum;
run;