topic Re: sas reference to a numeric variable name in SAS Studio

sas reference to a numeric variable name

zlerman — Thu, 13 Sep 2018 17:05:57 GMT

I have imported an xlsx file in which columns have numerical names, e.g., 11003, 21003, 21103, and so on (more than 200 variables). The file imported correctly and I see the var names as 11003, 21003, 21103 in the output window and in the proc contents output. However, when I refer to my variables as 11003, 21003, 21103, etc., the SAS Studio does not recognize the variable names and produces an error message. I cannot run even a simple SAS program such as data a; set b; if 21103 eq 0; run; Variables with nonnumerical (character) names are recognized correctly, but if I try to print a mix of variables with nonnumerical and numerical names I get an error:

proc print data=coops.full2015; var ОКПО ОКВЭД 11103;

_____

200

ERROR 22-322: Syntax error, expecting one of the following: a name, ;, -, /, :, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

ERROR 200-322: The symbol is not recognized and will be ignored.

Enclosing the numerical var name in quotation marks does not help: the same error is produced.

Please tell me how to access the variables with numerical names in my file.

Putting the numerical var name in quotes does not help:

proc print data=coops.full2015; var ОКПО ОКВЭД "11103"; run;

_______

200

ERROR 22-322: Syntax error, expecting one of the following: a name, ;, -, /, :, _ALL_, _CHARACTER_, _CHAR_, _NUMERIC_.

ERROR 200-322: The symbol is not recognized and will be ignored.

Please help me to access the variables with numerical names in my file.

Thank you for your cooperation.

Re: sas reference to a numeric variable name

Vince_SAS — Thu, 13 Sep 2018 17:16:34 GMT

Try something like this:

options validvarname=any validmemname=extend;

proc print data=coops.full2015; 
  var ОКПО ОКВЭД '11103'n;
run;

Note the letter n used with the numeric column name.

SAS® 9.4 and SAS® Viya® 3.4 Programming Documentation / SAS Language Reference: Concepts
Rules for SAS Variable Names

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=lrcon&docsetTarget=p18cdcs4v5wd2dn1q0x296d3qek6.htm&locale=en#n0nfuxt1u6y9jin120gszztjh00o

Vince DelGobbo

SAS R&D

Re: sas reference to a numeric variable name

zlerman — Fri, 14 Sep 2018 04:29:25 GMT

This works. Many, many thanks.

What is the precise function of the suffix "n"?

Is this topic (var name options, numerical var names in SAS Studio) covered anywhere in the instructions manual or the online help?

Best,

Zlerman

Re: sas reference to a numeric variable name

Vince_SAS — Fri, 14 Sep 2018 11:58:09 GMT

The letter "n" is used to distinguish between a quoted string and a name literal value.

The link that I posted earlier explains this. This link is for the "SAS Name LIterals" section in the same Web page:

https://go.documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=lrcon&docsetTarget=p18cdcs4v5wd2dn1q0x296d3qek6.htm&locale=en#n0qc68k2iyhs5kn1t2bvt41myhn1

Vince DelGobbo

SAS R&D

Re: sas reference to a numeric variable name

zlerman — Fri, 14 Sep 2018 12:58:03 GMT

Thanks much. All is much clearer now, including the terminology ("name literals") and the system options that you have suggested.

Best.