topic How to change the variable name in New SAS User

How to change the variable name

yogita_patel — Fri, 10 Jun 2022 15:45:51 GMT

Hi ,

There is a variable DAI with values WEEK 2, WEEK 4, WEEK 8, WEEK 12, ..

If I transpose DAI variable then I get WEEK 2, WEEK 4,.. as variable

how can I change variable name from WEEK 2 to WEEK_2 ,...

As space is not accepted in variable name

But If i do before transpose like if DAI="WEEK 2" then dai_ "WEEK_2;

But it gives error when i transpose dai_ variable

ERROR: The ID value "WEEK_2" occurs twice in the same BY group

can someone please give me solution?

Re: How to change the variable name

PaigeMiller — Fri, 10 Jun 2022 16:03:18 GMT

Please, when you are talking about data, show us a portion of the actual SAS data set, as SAS data step code (instructions). That would be very helpful. Do not attach Excel files, or provide the data in other formats.

Also, when you get errors in the log, SHOW US the log (all of it, every single line, every single character, for the PROC or DATA step that has the error)

Re: How to change the variable name

Reeza — Fri, 10 Jun 2022 15:54:33 GMT

Add this before your code:

option validvarname=v7;

Re: How to change the variable name

Tom — Fri, 10 Jun 2022 15:56:34 GMT

Without an example it is hard to tell what you are actually doing.

You seem to be asking two different questions.

To force PROC TRANSPOSE to generate valid variable names make sure you have set the option VALIDVARNAME=v7. You might have accidentally had it set to VALIDVARNAME=any before.

If you have the same ID value in multiple times you need to decide how you want that transposed.

Perhaps you just need to add an extra BY variable so that you now longer have duplicate ID values for the same target observation.

Or perhaps you want eliminate the duplicate observation before calling PROC TRANSPOSE.