format

[wajs]

Hi, I am working on a dataset with microorganisms. For Proc format, my values are CMV_IgG_rev 1.'Present', 2.'Absent'. In Proc logistic, I put (ref='Absent') or (ref='2'), log turns out invalid reference value. Please guide me

[Astounding]

So far, you haven't posted even a scrap of a SAS statement that would run without error. Guidance: post the log.

[wajs]

Hi,

proc logistic data= pe. matched_21_plus_co_inf_updated;
strata group;
class CMV_IgG_rev (ref='2');
model PEstatus (event='1')= CMV_IgG_rev;
run;

Log:

288 proc logistic data= pe. matched_21_plus_co_inf_updated;
NOTE: Data file PE.MATCHED_21_PLUS_CO_INF_UPDATED.DATA is in a format that is native to another
host, or the file encoding does not match the session encoding. Cross Environment Data Access
will be used, which might require additional CPU resources and might reduce performance.
289 strata group;
290 class CMV_IgG_rev (ref='2');
291 model PEstatus (event='1')= CMV_IgG_rev;
292 run;

ERROR: Invalid reference value for CMV_IgG_rev.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 78 observations read from the data set PE.MATCHED_21_PLUS_CO_INF_UPDATED.
NOTE: PROCEDURE LOGISTIC used (Total process time):
real time 0.08 seconds
cpu time 0.04 seconds

[Tom]

Why do you have quotes around a numeric value?

[Astounding]

When you run a PROC CONTENTS on your data set, what do you see for CMV_lgG_rev?

Character or numeric?

Format?

[wajs]

Hi, Thanks for the advice! Here is the output:

Variables in Creation Order# Variable Type Len Format Informat12345

group	Num	8	BEST12.	BEST12.
type	Char	7
ID	Char	4	$100.	$100.
PEstatus	Num	8	BEST12.	BEST12.
CMV_IgG_rev	Num	8	BEST12.	BEST12.

[Astounding]

OK, based on that here are two things to try. Admittedly these are educated guesses only!

First, add this statement as part of PROC LOGISTIC. It can never hurt and might help:

format CMV_lgG_rev;

Second, are you certain the quotes belong when using a numeric variable? Is it possible the syntax should be (as Tom mentioned):

class CMV_lgG_rev (ref=2);

[wajs]

Thanks for the guidance!

After removing quotes, here is the log, it was the same whether I used format statement or not:

NOTE: The SAS System stopped processing this step because of errors.
307 strata group;
308 class CMV_IgG_rev (ref=2);
-
22
200
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, FIRST, LAST.
ERROR 200-322: The symbol is not recognized and will be ignored.
309 model PEstatus (event='1')= CMV_IgG_rev;
310 run;

[Astounding]

Sorry to say, I'm unable to help further.  I don't have access to LOGISTIC any more for testing purposes.

There must be a few stat gurus lurking who can finish this one!