BookmarkSubscribeRSS Feed
osho_2313
Calcite | Level 5

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

2 REPLIES 2
Ksharp
Super User

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
Super User Tom
Super User

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.

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 900 views
  • 0 likes
  • 3 in conversation