Hello, I've been trying to rename all the variables that start with a state, and end with something like !!Housholds!!Estimate and I keep getting the Error 20-200 saying:
"Alphabetic prefixes for enumerated variables (Alabama-Estimate) are different.
Old and new variable name specifications for RENAME must be of the same type. Statement is ignored.
And Error 22-322 says:
Syntax error, expecting one of the following: -, :, =.
The symbol is not recognized and will be ignored.
I want to change all the variables to a shorted postal abbreviation of the corresponding state. For example I want the variable Alabama!!Housholds!!Estimate to be just AL.
Also, none of my data copied from the first data set to the second dataset, but I created that second dataset. The second dataset just has all of the original variables, but with no observations. Can I get help getting all my data to be copied over to the new dataset?
![sas question 1.png sas question 1.png](/t5/image/serverpage/image-id/77874i309FB5DFB4E90AEC/image-size/large?v=v2&px=999)
![sas question 2.png sas question 2.png](/t5/image/serverpage/image-id/77875i0FEB1D4CEDAE2096/image-size/large?v=v2&px=999)
This one is the output of the first dataset RegPro.IncoSt
![sas question 3.png sas question 3.png](/t5/image/serverpage/image-id/77876iFE87B98B3E62CDB1/image-size/large?v=v2&px=999)
This one is the output of the second dataset RegPro.IncoSt1
![sas question 4.png sas question 4.png](/t5/image/serverpage/image-id/77877i2E4E047D396460AD/image-size/large?v=v2&px=999)