topic Re: ODS output tables with variable names as numbers in SAS OnDemand in ODS and Base Reporting

ODS output tables with variable names as numbers in SAS OnDemand

markgewhite — Fri, 28 May 2021 08:37:08 GMT

When using ODS Output I discovered that in SAS OnDemand some tables have variable names as numbers.

Previously in SAS Studio University Edition, those same variables would have had an underscore prefix. eg _1 _2

How am I to refer to these fields in a subsequent statement without getting an error?

Here is a simplified version of what I'm doing. I fit a GLM model and send the LSMeans Difference output to a table. I then try to refer to it but fail.

/* run the model and generate the ODS Output data */
proc glm data=TEST;
	class FactorA FactorB FactorC;
	model Outcome = FactorA FactorB FactorC;
	lsmeans FactorA FactorB FactorC / adjust=tukey pdiff=all alpha=0.05 cl;
	ods output diff = GLM_DIFF;
run;

/* previously offline this would work */
proc means data = GLM_DIFF;
	var _1 _2 _3;
run;

/* but fields are now 1 2 3 */
/* and this fails */
proc means data = GLM_DIFF; 
        var 1 2 3;
run;

I can't figure out what the correct syntax should be. Can someone help?

Thanks

Re: ODS output tables with variable names as numbers in SAS OnDemand

sbxkoenk — Fri, 28 May 2021 15:27:50 GMT

Hello,

I think this can be solved by a SAS Name Literal.

Enclose variable name or data set name in quotes immediately followed by little n.

Like in:

data sedanTypes; 
   set cars; 
   by 'Sedan Types'n; 								
   if 'first.Sedan Types'n then type=1;   
run;

See documentation for

Using Name Literals and Avoiding Errors When Using Name Literals.

Koen

Re: ODS output tables with variable names as numbers in SAS OnDemand

sbxkoenk — Fri, 28 May 2021 15:27:23 GMT

It could also be that you are looking at the labels, being 1,2 & 3.

The variable names may still contain an underscore as a prefix.

Koen

Re: ODS output tables with variable names as numbers in SAS OnDemand

Tom — Fri, 28 May 2021 15:52:01 GMT

Check the setting of the VALIDVARNAME option.

If you have VALIDVARNAME=V7 then you cannot create a variable with a name like 1.

If you have VALIDVARNAME=ANY then you can. If you have created datasets with names like that then you need to use name literal to reference the variables.

proc means data = GLM_DIFF; 
  var '1'n '2'n '3'n;
run;

Re: ODS output tables with variable names as numbers in SAS OnDemand

Reeza — Fri, 28 May 2021 15:53:03 GMT

If you add the following option to your code or autoexec it should help avoid those issues:

options validvarname=v7;

Then it'll generate them as _1, _2 etc.

Re: ODS output tables with variable names as numbers in SAS OnDemand

markgewhite — Fri, 28 May 2021 18:15:43 GMT

I'm afraid that didn't work for me. I tried

proc means data = GLM_DIFF;
	var 'GLM_DIFF'1;
run;

And other such variations.

Re: ODS output tables with variable names as numbers in SAS OnDemand

markgewhite — Fri, 28 May 2021 18:16:52 GMT

No. The variables are definitely named 1, 2, etc. Thanks, though.

Re: ODS output tables with variable names as numbers in SAS OnDemand

markgewhite — Fri, 28 May 2021 18:19:24 GMT

Thanks. I see where you're coming from, but I'm not creating the variable names. ODS is.

Re: ODS output tables with variable names as numbers in SAS OnDemand

markgewhite — Fri, 28 May 2021 18:20:02 GMT

Brilliant. This worked. Thanks. Tom was on the right track.