Help using Base SAS procedures

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

Reply
N/A
Posts: 1

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

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

Super User
Posts: 9,681

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

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

Super User
Super User
Posts: 6,500

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

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.

Ask a Question
Discussion stats
  • 2 replies
  • 260 views
  • 0 likes
  • 3 in conversation