topic PROC TRANSPOSE - RENAME (Warning in SAS EG 4.2, No warning in SAS 9.2) in SAS Procedures

PROC TRANSPOSE - RENAME (Warning in SAS EG 4.2, No warning in SAS 9.2)

osho_2313 — Tue, 04 Oct 2011 09:06:18 GMT

Anyone know this problem?

I'm using SAS EG 4.2 (4.22.0.9238). However, I'm try to use SAS 9.2 that have no this warning message.

%LET REFYR = 2011;

PROC TRANSPOSE DATA= MBENEFIT

OUT=MBEN&REFYR (RENAME=(_3=MD3_&REFYR _5=MD5_&REFYR _6=MD6_&REFYR

_7=MD7_&REFYR _8=MD8_&REFYR _0=ALL_&REFYR));

ID SEC ;

WARNING: The variable _3 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable _5 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable _6 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable _7 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable _8 in the DROP, KEEP, or RENAME list has never been referenced.

WARNING: The variable _0 in the DROP, KEEP, or RENAME list has never been referenced.

Thanks all

Ksharp — Tue, 04 Oct 2011 17:08:51 GMT

Maybe the system option of EG is different from SAS9.2. especially for keep and drop statment.

There is an option about keep and drop statement.

You can turn it off to suppress these print of Warnning.

Ksharp

Tom — Tue, 04 Oct 2011 19:40:07 GMT

Are you sure you are transposing the same dataset?

Is it possible that there is a format associate with the variable SEC that is only be found in one of the two SAS sessions?

Look at the names of the variables when you do this:

proc transpose data=sashelp.class out=x1;

id name ;

format name $5.;

run;

Look at the option DKROCOND.

%put %sysfunc(getoption(dkrocond));

You can set it to NOWARN and it will silently do nothing. You can set it to ERROR and it will cause and ERROR instead of just a WARNING.