SAS Programming

DATA Step, Macro, Functions and more
BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Kaeslock223_
Fluorite | Level 6

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! crappy compu.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
Kaeslock223_
Fluorite | Level 6
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

View solution in original post

6 REPLIES 6
Tom
Super User Tom
Super User

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.

PaigeMiller
Diamond | Level 26

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.

--
Paige Miller
Kaeslock223_
Fluorite | Level 6
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
Tom
Super User Tom
Super User

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;
jaliu
Quartz | Level 8

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?

ballardw
Super User

@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=h...    Use it.

 

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

 

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

 

Look at Clear.

 

 

sas-innovate-white.png

Our biggest data and AI event of the year.

Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.

Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 6 replies
  • 9871 views
  • 2 likes
  • 5 in conversation