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,137

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

Posted in reply to pharmacygirl
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: 19,810

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

Posted in reply to pharmacygirl

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: 19,810

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

Posted in reply to pharmacygirl

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,923

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

Posted in reply to pharmacygirl

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

PG
Occasional Contributor
Posts: 6

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: 19,810

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

Posted in reply to Larrihoover

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

 

Occasional Contributor
Posts: 6

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: 19,810

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

Posted in reply to Larrihoover

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

Occasional Contributor
Posts: 6

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: 19,810

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

Posted in reply to Larrihoover

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: 19,810

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
  • 746 views
  • 1 like
  • 5 in conversation