Messy Data -Column name consisting of two distinct units

[Sonyboy]

Dear all,

I have a program which outputs a column name " Dummy 1" -> there is a space between dummy and 1....this makes the processing of the data really difficult. (please also see the screen shot)

the program is 

proc varmax data=pData;

     model p1 p2 / p=1 print=(estimates)

           ecm=(rank=1 ectrend normalize=p1) lagmax=0;

     ods output      AlphaInECM=AlphaInECM ;

     run;

what is an easy way to convert the column name from "Dummy 1 " to Dummy1 or something usable

thanks in advance

Sony

[PGStats · Accepted solution]

I have never seen a variable produced by a procedure that got such a name. Are you sure that you are looking at the variable name and not it's label?

Otherwise, 

data want;

set have;

rename 'Dummy 1'n=Dummy1;

run;

will do the name change.