topic Re: Variable not found and cannot be renamed in SAS Programming

Variable not found and cannot be renamed

CathyVI — Mon, 13 Jun 2022 14:09:27 GMT

Hi,

I have a sas dataset that has some variables that was not presenting frequencies. The variables are named and label like this; U-METHADONE, U-OXY, U-FENTANYL.

How can I resolve this problem.

proc freq data = original_data;
tables U-METHADONE;
run;

*LOG;

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK;

69 proc freq data = original_data;

70 tables U-METHADONE;

ERROR: Variable U not found.

71 run;

I have attempted to rename the variables but no luck.

data new_data;
set original_data (rename=(U-METHADONE=Methadone));
keep Methadone ;
run;

*LOG;

69 data new_data;

70 set stcp.cleanedpracticum2(rename=(U-METHADONE=Methadone));

ERROR: U does not have a numeric suffix.

71 keep Methadone;

72 run;

Thanks

Re: Variable not found and cannot be renamed

PaigeMiller — Mon, 13 Jun 2022 14:14:39 GMT

Variable names cannot have a dash (hyphen) in the variable name.

You can override this with the following option:

options validvarname=any;

and then you can refer to variables in your code with dash in their name as, for example,

tables 'U-METHADONE'n;

Re: Variable not found and cannot be renamed

Tom — Mon, 13 Jun 2022 14:17:42 GMT

Hyphens are not allowed in valid variable names. It thinks you are trying to do some type of variable list, but the syntax is not right for that either as for a variable list using a single hyphen you need names with a numeric suffix.

If you have the validvarname option set to ANY (why?) then you need to use a Name Literal to reference a variable name that does not follow normal naming rules.

tables "U-METHADONE"n;

Otherwise if you have validvarname=v7 then you are probably trying to use the LABEL of the variable where you should be using the NAME of the variable.

Re: Variable not found and cannot be renamed

PaigeMiller — Mon, 13 Jun 2022 14:26:27 GMT

Show us the output of PROC CONTENTS on this data set for these variables.

Re: Variable not found and cannot be renamed

CathyVI — Mon, 13 Jun 2022 14:39:07 GMT

Thank you. The problem is solved. I still sent you a snippet of the proc content if you still need it.

Re: Variable not found and cannot be renamed

PaigeMiller — Mon, 13 Jun 2022 14:43:09 GMT

Thanks! But as long as the problem is solved, the PROC CONTENTS is no longer needed.