11-03-2011 01:35 PM
EG 4.1 imports a MS Access table which has invalid column names, as an example
2009 subs total
Total # Of Subs
I look at the generated code by sas and it creates _T_ value to process the observations, and creates the SAS Dataset.
The strange thing is that SAS outputs the dataset with non-standard variable names, which causes me the problem.
I would have thought SAS would have kept the _T_ or someting like that...
I want to re-name all the variables to someting like:
Rename 2009 subs total = Y2009_Subs_Total;
But SAS looks at the 2009 as a numeric not as a variable name...
Any ideas on how I can take a variable named 2009 subs total and rename it to Y2009_Subs_Total?
11-03-2011 01:40 PM
State the variable name as a name literal in your rename statement. see:
You would have to have the validvarname=any option set as well
11-03-2011 09:58 PM
For SAS/EG system option validvarname= is set 'any' by default.
You should set it back at the first of your code . validvarname=v7.