DATA Step, Macro, Functions and more

Proc Transpose help - "Name of Former Variable" column not recognized

Reply
Regular Learner
Posts: 1

Proc Transpose help - "Name of Former Variable" column not recognized

Hi,

 

I'm trying to run a t-test and I can't get SAS to recognize a generated transposed variable. I also don't know why it generated two of the same columns. When I attempt to rename or drop it, it gives the same error message as well:

 

ERROR: Variable LABEL_OF_FORMER_VARIABLE not found.

 

Is there a way to create the same column or copy it again so that SAS will be able to analyze it? I would REALLY appreciate any help on this because I've been stuck on this problem for days! Smiley Sad Attached a screenshot. 


1.PNG
Trusted Advisor
Posts: 1,131

Re: Proc Transpose help - "Name of Former Variable" column not recognized

not sure if you could use in the var statement of proc ttest the character variable (LABEL_OF_FORMER_VARIABLE), we are supposed to use the numeric variable.
Thanks,
Jag
Super User
Posts: 17,868

Re: Proc Transpose help - "Name of Former Variable" column not recognized

You're seeing the variable LABEL not the variable NAME.

 

I would guess the variable name is actually _LABEL_ but verify it either by switching to the variable name (in View Menu) or using PROC CONTENTS.

Super User
Posts: 17,868

Re: Proc Transpose help - "Name of Former Variable" column not recognized

This is in addition to @Jagadishkatam correct statement that the VAR requires a numeric variable. The variable to be analyzed goes in the VAR statement, the categorical variable goes as the CLASS variable.

Respected Advisor
Posts: 4,654

Re: Proc Transpose help - "Name of Former Variable" column not recognized

"NAME OF FORMER VARIABLE" and "LABEL OF FORMER VARIABLE" are variable labels, not names. The corresponding variable names are _NAME_ and _LABEL_.

PG
New Contributor
Posts: 4

Re: Proc Transpose help - "Name of Former Variable" column not recognized

I think to clarify:

 

proc transpose data=old_data out = new_data (rename=(_NAME_= Field) drop = _LABEL_);
id transposed_field;
label Field = 'Field';
run;

 

Note: Works but does give a warning that Field is not found on the old_data set.

Super User
Posts: 17,868

Re: Proc Transpose help - "Name of Former Variable" column not recognized

The label statement applies to the input data set not the output. 

 

New Contributor
Posts: 4

Re: Proc Transpose help - "Name of Former Variable" column not recognized

My output data set has Name: Field, Label: Field. If I remove the label line of code the field has Name: Field Label: NAME OF FORMER VARIABLE.
Super User
Posts: 17,868

Re: Proc Transpose help - "Name of Former Variable" column not recognized

Do you still get the warning if your remove the LABEL statement?

New Contributor
Posts: 4

Re: Proc Transpose help - "Name of Former Variable" column not recognized

No, is there a way around that inside the transpose procedure? The warning isn't effecting me now but I am worried if I start using this dynamically.
Super User
Posts: 17,868

Re: Proc Transpose help - "Name of Former Variable" column not recognized

Try using the old variable name in the LABEL statement, instead of the new variable name. Order of operations issue, I think.

 

 

Super User
Posts: 17,868

Re: Proc Transpose help - "Name of Former Variable" column not recognized

FYI - you should start your own question and not use a question that's a few months old and may not fully relate to your issue.

Ask a Question
Discussion stats
  • 11 replies
  • 322 views
  • 1 like
  • 5 in conversation