RENAME statement help!

[FLETCHSAS]

Hello all,

     I have been trying to rename the numeric variable 'Price S' to just 'price' but for some reason this variable, along with 'Price US', produce error messages when I run the program. I have been able to change carat ➟car, color➟col, and certification➟cert. Below is the code I am running. If anyone can help it would be greatly appreciated, Thank you.

PROC IMPORT datafile="/home/michaelfletcher/FletcherSAS/WORK/DATA/Diamonds.xls"

     OUT=WORK.Diamonds

     DBMS=xls

     REPLACE;

RUN;

DATA diam;

     SET Diamonds;

RUN;

DATA diam (rename=(carat=car color=col certification=cert Price_S=price));

     SET diamonds;

RUN;

PROC CONTENTS data=diam;

RUN;

--Michael Fletcher

[ballardw]

Please supply the error messages. They are often very helpful in diagnosing problems.

Also if there are any warnings in the log or notes related to encoding.

[woo]

looks nothing wrong with DATA STEPS in your code. below code works fine so do yours too...check variable name for your input dataset in rename step

data a;

   carat=123;

   color=345;

   certification=56789;

   price_s=465789;

   run;

data b (rename=(carat=car color=col certification=cert Price_s=price));

set a;

run;

what is your error message ?

[FLETCHSAS]

No ERROR messages. The proc contents still shows the same variable name and I get this warning message:

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

[ballardw]

This means that the way you typed Price_S doesn't quite match what the name of the variable actually is. Copy it from the proc contents output and paste that into the code. I suspect there may be two or more _ in the actual name together and it just looks like one.

[FLETCHSAS]

When I copy & paste ''Price S" it returns this error message:

ERROR 79-322: Expecting a =.

[ballardw]

Show us the proc contents output.

And the code that generated the error.

[SASKiwi]

"Price S" is not a valid SAS variable name so you may need to do the rename like this: (rename = ('Price S'n = Price))