Help using Base SAS procedures

titles

Accepted Solution Solved
Reply
Super Contributor
Super Contributor
Posts: 444
Accepted Solution

titles

hi guys

is it possible running the query below and having  one title only

title 'hello';

proc sql;

select count(brand) from mylib.cars;

select count(model) from mylib.cars; quit;

something  like:

hello

34

35

i mean i can have this below instead and have only one title on the top but i'd prefer the query above with one title. Is it doable?

title 'hello';

proc sql;

select count(brand1) from mylib.cars; quit;

title;

proc sql;

select count(model) from mylib.cars;quit;


Accepted Solutions
Solution
‎09-13-2014 06:25 PM
Respected Advisor
Posts: 4,936

Re: titles

use UNION

title;

proc sql;

select count(brand) label="Hello" from mylib.cars

union all

select count(model) from mylib.cars;

quit;

PG

View solution in original post


All Replies
Solution
‎09-13-2014 06:25 PM
Respected Advisor
Posts: 4,936

Re: titles

use UNION

title;

proc sql;

select count(brand) label="Hello" from mylib.cars

union all

select count(model) from mylib.cars;

quit;

PG
Super Contributor
Super Contributor
Posts: 444

Re: titles

works well for one line titles. Thanks PG Stats

Respected Advisor
Posts: 4,936

Re: titles

You can get two lines too!

title;

proc sql;

select count(distinct make) label="/First line/Second line/" from sashelp.cars

union all

select count(distinct model) from sashelp.cars;

quit;

If the first character of a label is not alphanumeric, it is taken as a line separator.

but of course, for more flexibility, you can also do

title "First line";

title2 "Second line";

proc sql;

select count(distinct make) label="" from sashelp.cars

union all

select count(distinct model) from sashelp.cars;

quit;

PG

PG
Super Contributor
Super Contributor
Posts: 444

Re: titles

thanks a lot

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 215 views
  • 1 like
  • 2 in conversation