topic Re: Removing old title statement in SAS Programming

Removing old title statement

Kaeslock223_ — Sun, 29 Aug 2021 17:25:09 GMT

I have been trying to remove this old title statement from my results but it continues to appear and it removes my ability of seeing the sas variable names, too. I've tried the standard removal (title;) and variations of it (title1; title2; title3;...), but it remains. Please help!

Re: Removing old title statement

Tom — Sun, 29 Aug 2021 18:30:40 GMT

TITLEn will replace the Nth title line and remove any titles after that. So either of these statements should clear the titles.

TITLE1;
TITLE;

Note that TITLE statements issued in the middle of a step will take effect when that step produces output. So make sure to terminate your PROC steps with the appropriate statement for that PROC (RUN or QUIT).

title;
proc freq ....;
tables ....;
run;

title 'Some other title'
proc some_other_proc ....

How are you submitting your code? If you using some tool that submits the code for you, like Enterprise Guide or SAS Studio then make sure it is not also submitting a TITLE statement.

Re: Removing old title statement

PaigeMiller — Sun, 29 Aug 2021 18:33:39 GMT

This is not a title issue at all. This appears to be a custom template on the output of a particular PROC. Title statements would not remove variable names from the output.

However, I cannot tell you the exact method of removing the custom template.

Re: Removing old title statement

Tom — Sun, 29 Aug 2021 19:19:56 GMT

If the text in that printout are the labels on your variables you could try just running without the labels

Either remove the labels with a label statement.

label var1=' ' var2=' ';

Or try setting the NOLABEL option.

options nolabel;

Re: Removing old title statement

Kaeslock223_ — Sun, 29 Aug 2021 19:58:49 GMT

I found the answer on an old sas post based on your suggestion of a custom template.
This code fixed it:
proc template; delete base.freq.crosstabfreqs; run;

This is where it came from: http://support.sas.com/resources/papers/freq92.pdf

Re: Removing old title statement

jaliu — Sun, 29 Aug 2021 21:49:17 GMT

sorry if this is not the appropriate place for my question. i saw a mcq question that asked something about 'deleting' a libname statement and although i figured out what they meant (undoing the libref), the wording confuses me because if we simply delete the statement and run the code again, won't the libref still be available for use? Is there specific terminology that i'm missing when we use words like 'remove', 'delete' etc?

Re: Removing old title statement

ballardw — Mon, 30 Aug 2021 17:18:50 GMT

@jaliu wrote:

sorry if this is not the appropriate place for my question. i saw a mcq question that asked something about 'deleting' a libname statement and although i figured out what they meant (undoing the libref), the wording confuses me because if we simply delete the statement and run the code again, won't the libref still be available for use? Is there specific terminology that i'm missing when we use words like 'remove', 'delete' etc?

Please do not post unrelated questions in someone else's question thread.

Strongly suspect your paraphrase has changed wording/meaning from your source.

Syntax documentation. Bookmark it if you haven't already. https://documentation.sas.com/?cdcId=pgmsascdc&cdcVersion=9.4_3.4&docsetId=pgmsashome&docsetTarget=home.htm&locale=en Use it.

https://documentation.sas.com/doc/en/pgmsascdc/9.4_3.4/lestmtsglobal/n1nk65k2vsfmxfn1wu17fntzszbp.htm

has the base LIBNAME statement documentation. Other specific targets for the LIBNAME have additional options.

Look at Clear.