topic Re: rename field with () in SAS Programming

rename field with ()

wlierman — Wed, 09 Sep 2020 17:23:19 GMT

I am trying to rename a variable that is labeled (Do Not Modfy) Contact (modify is misspelled in the file). I try a simple rename in the Data Step:

Data Arias.System_contacts (rename = ((Do Not Modfy)Contact = Contact_number));
  Set ARIAS.System_Contacts_per_tracer;
run;

That results in the following error:

84   Data Arias.System_contacts (rename = ((Do Not Modfy)Contact = Contact_number));
                                           -
                                           214
                                           23
                                            --
                                            79
ERROR 214-322: Variable name ( is not valid.

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

ERROR 79-322: Expecting a =.

85     Set ARIAS.System_Contacts_per_tracer;
86   run;

NOTE: The SAS System stopped processing this step because of errors.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds

I've tried some alternatives such as placing the rename and label statements in the Data Step. But still get an error.

Thank you for your assistance in solving this problem.

wlierman

Re: rename field with ()

PaigeMiller — Wed, 09 Sep 2020 17:54:26 GMT

@wlierman wrote:

I am trying to rename a variable that is labeled (Do Not Modfy) Contact (modify is misspelled in the file). I try a simple rename in the Data Step:

Do you mean that the variable NAME is (Do Not Modfy) Contact? Not the variable LABEL is (Do Not Modfy) Contact?

Try this:

proc datasets library=arias nolist; 
modify system_contacts;
rename '(Do Not Modfy) Contact'n = contact_number;
run; quit;

Although your text has a space between Modfy) and Contact, but your code does not. So which is it? You need to pay attention to details like this.

Re: rename field with ()

ballardw — Wed, 09 Sep 2020 17:30:43 GMT

If your variable has characters that are other than a letter, digit or _ character then you have to use the name literal form with is the entire text of the variable enclosed in quotes with an n immediately following.

So if your variable name is

(Do Not Modfy)Contact

then you always have to reference it as "

'(Do Not Modfy)Contact'n

or write a data step to read the data such that you don't get such ugly names.

Re: rename field with ()

wlierman — Wed, 09 Sep 2020 19:51:25 GMT

I ran the code and while it may look like there is a space between the ) and Contact there isn't any extra space. So I ran this

Data Arias.System_contacts (rename = ( '(Do Not Modfy)Contact'n = Contact_number));
  Set ARIAS.System_Contacts_per_tracer;
run;

and got the following log result:

99   Data Arias.System_contacts (rename = ( '(Do Not Modfy)Contact'n = Contact_number));
                                            ------------------------
                                            214
                                            23
ERROR 214-322: Variable name '(Do Not Modfy)Contact'n is not valid.

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

100    Set ARIAS.System_Contacts_per_tracer;
101  run;

I tried one additional space between the closing ' and n but still no successful run.

Any there another approach?

Thanks.

wlierman

Re: rename field with ()

wlierman — Wed, 09 Sep 2020 19:55:59 GMT

Sorry, but I read right over your solution. Checking the View Columns the Label is the (Do Not Modfy)Contact but the variable name is _Do_Not_Modify Contact with modify actually spelled correctly.

So thank you for your help. Still learned something new on the name literal.

wlierman

Re: rename field with ()

wlierman — Wed, 09 Sep 2020 19:59:00 GMT

Yes. I read right over the solution by Paige. The label is the ugly expression. But the variable name is _Do_Not_Modify Contact which is still not all that straightforward but at least has modify spelled correctly.

This also ties to your answer too. Thank you.

wlierman