Help using Base SAS procedures

RENAME statement help!

Reply
Occasional Contributor
Posts: 5

RENAME statement help!

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, colorcol, and certificationcert. 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

Super User
Posts: 10,483

Re: RENAME statement help!

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.

Super Contributor
Super Contributor
Posts: 328

Re: RENAME statement help!

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 ?

Occasional Contributor
Posts: 5

Re: RENAME statement help!

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.

Super User
Posts: 10,483

Re: RENAME statement help!

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.

Occasional Contributor
Posts: 5

Re: RENAME statement help!

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

ERROR 79-322: Expecting a =.

Super User
Posts: 10,483

Re: RENAME statement help!

Show us the proc contents output.

And the code that generated the error.

Super User
Posts: 3,102

Re: RENAME statement help!

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

Ask a Question
Discussion stats
  • 7 replies
  • 657 views
  • 9 likes
  • 4 in conversation