Messy Data -Column name consisting of two distinct units

Sonyboy — Sun, 05 Jun 2016 16:45:04 GMT

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

Re: Messy Data -Column name consisting of two distinct units

PGStats — Sun, 05 Jun 2016 18:20:49 GMT

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.

topic Messy Data -Column name consisting of two distinct units in SAS Data Management

Messy Data -Column name consisting of two distinct units

Re: Messy Data -Column name consisting of two distinct units