topic Re: Edit of Table Title in SAS Programming

Edit of Table Title

Lonny — Fri, 30 Jun 2023 16:45:43 GMT

Good day,

I ran summary statistics on my data and my analysis variable is repeated (twice) in the table title. How do I correct this so the analysis variable is listed once?

Re: Edit of Table Title

JOL — Fri, 30 Jun 2023 16:56:57 GMT

Can you send a screen print of the results.

Re: Edit of Table Title

Lonny — Fri, 30 Jun 2023 18:50:40 GMT

Yes. Basically in the titale it will say Analysis Variable: SL Score SL Score

Re: Edit of Table Title

Tom — Sat, 01 Jul 2023 02:08:34 GMT

That is probably the LABEL that is attached to the variable.

Try this example:

proc means data=sashelp.class ;
  var age;
run;
proc means data=sashelp.class ;
  var age;
  label age='age';
run;

You can either use a LABEL statement to remove the label. Or add the NOLABELS option to the PROC MEANS statement.

As to why someone would make a variable named SL with a label of 'Score SL Score' makes no sense. Or worse why anyone would make a variable named 'SL Score'n with an embedded space in the middle of the variable name and then also attach a label to it that did not add any extra information.

Are you sure the printout was not something like "SL_SCORE SL Score" ? That makes more sense because then the variable name is probably SL_SCORE and the label is "SL Score".

Re: Edit of Table Title

Lonny — Tue, 04 Jul 2023 13:41:16 GMT

The solution worked.