topic Re: RENAME statement help! in SAS Procedures

RENAME statement help!

FLETCHSAS — Wed, 29 Oct 2014 21:43:20 GMT

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

Re: RENAME statement help!

ballardw — Wed, 29 Oct 2014 21:52:27 GMT

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.

Re: RENAME statement help!

woo — Wed, 29 Oct 2014 21:56:34 GMT

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 ?

Re: RENAME statement help!

FLETCHSAS — Wed, 29 Oct 2014 22:00:14 GMT

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.

Re: RENAME statement help!

ballardw — Wed, 29 Oct 2014 22:03:49 GMT

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.

Re: RENAME statement help!

FLETCHSAS — Wed, 29 Oct 2014 22:21:32 GMT

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

ERROR 79-322: Expecting a =.

Re: RENAME statement help!

ballardw — Wed, 29 Oct 2014 23:16:35 GMT

Show us the proc contents output.

And the code that generated the error.

Re: RENAME statement help!

SASKiwi — Wed, 29 Oct 2014 23:54:30 GMT

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