topic format in SAS Data Management

format

wajs — Sun, 10 Mar 2019 02:25:53 GMT

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

Re: format

Astounding — Sun, 10 Mar 2019 03:39:45 GMT

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

Re: format

wajs — Sun, 10 Mar 2019 03:59:31 GMT

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

Re: format

Astounding — Sun, 10 Mar 2019 06:52:25 GMT

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

Character or numeric?

Format?

Re: format

wajs — Sun, 10 Mar 2019 18:35:31 GMT

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.

Re: format

Tom — Sun, 10 Mar 2019 18:41:20 GMT

Why do you have quotes around a numeric value?

Re: format

Astounding — Sun, 10 Mar 2019 19:28:22 GMT

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);

Re: format

wajs — Mon, 11 Mar 2019 07:15:06 GMT

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;

Re: format

Astounding — Mon, 11 Mar 2019 14:38:05 GMT

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!