topic Re: Rename Variable with invalid characters in data step in SAS Enterprise Guide

Rename Variable with invalid characters in data step

RafaelZ — Tue, 21 Jul 2015 10:48:58 GMT

Hi.

i have a variable named "((Branch_Nbr||' - ')||Branch_Cus" in a dataset .

How can i change its name to "aaa" using the rename statement in datastep?

Thanks

Rafael

15 data Custs_Numerators_Income;

16 options obs=500;

17 set work.Custs_Numerators_Income

18 (

19 rename=( "((Branch_Nbr||' - ')||Branch_Cus" = aaa )

__________________________________

214

ERROR 214-322: Variable name "((Branch_Nbr||' - ')||Branch_Cus" is not valid.

ERROR 23-7: Invalid value for the RENAME option.

20 );

22 FORMAT Customer_Profit_Date DDMMYYS10.;

23 FORMAT Branch_Cust_End_Date DDMMYYS10.;

25 /* rename ((Branch_Nbr||' - ')||Branch_Cus=aaa; */

31 run;

NOTE: The SAS System stopped processing this step because of errors.

WARNING: The data set WORK.CUSTS_NUMERATORS_INCOME may be incomplete. When this step was stopped there were 0 observations and 2

variables.

WARNING: Data set WORK.CUSTS_NUMERATORS_INCOME was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

real time 0.00 seconds

cpu time 0.00 seconds

Re: Rename Variable with invalid characters in data step

RW9 — Tue, 21 Jul 2015 11:32:51 GMT

((Branch_Nbr||' - ')||Branch_Cus

Is not a valid variable name in SAS. Do you mean you have a variable which has a label like the above? If the variable is named that (and how?) then you might need:

options validvarname=any;

however more likely is that your talking about the label, in which case:

data want;

set have;

label variable "aaa";

run;

Re: Rename Variable with invalid characters in data step

Ksharp — Tue, 21 Jul 2015 11:52:50 GMT

If that is real variable name .Try to Add N at then end of it .

options validvarname=any;

data Custs_Numerators_Income;

options obs=500;

set work.Custs_Numerators_Income

(

rename=( "((Branch_Nbr||' - ')||Branch_Cus"N = aaa )

Re: Rename Variable with invalid characters in data step

RafaelZ — Tue, 21 Jul 2015 12:13:33 GMT

Hi xia

Thank you very much.

That solved it

Thanks again

Rafael