topic Re: SAS how to reference a numeric variable when name is mix of letters and numbers in SAS Programming

SAS how to reference a numeric variable when name is mix of letters and numbers

jeremy4 — Thu, 27 Jun 2019 15:52:15 GMT

Hi,

Can someone please help me to reference a numeric variable when the variable name is mix of letters and numbers? Thanks!

Variable name: TEST10

Type: Numeric

Group: Numeric

Current code:

proc print data=test;

var TEST10;

sum TEST10;

run;

Re: SAS how to reference a numeric variable when name is mix of letters and numbers

Tom — Thu, 27 Jun 2019 15:54:58 GMT

What is the question?

Re: SAS how to reference a numeric variable when name is mix of letters and numbers

jeremy4 — Thu, 27 Jun 2019 16:14:53 GMT

Hi Tom,

I have checked that there is a TEST10 variable in the 'test' dataset (the Name is TEST10 and there is no label to the variable) but there is an error when I run the code - 'ERROR: Variable TEST10 not found' so is there a way to correctly reference the numeric variable, despite the name being a mixture of characters and numbers?

Re: SAS how to reference a numeric variable when name is mix of letters and numbers

Reeza — Thu, 27 Jun 2019 16:10:21 GMT

Your reference is correct, you're likely having a different error or the variable label is test10, not the variable name.

Run a proc contents on the data set and check the variable name and label. If you're still having trouble, show us your code, log and the results from proc contents.