titles

[Tal]

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;

[PGStats · Accepted solution]

use UNION

title;

proc sql;

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

union all

select count(model) from mylib.cars;

quit;

[Tal]

works well for one line titles. Thanks PG Stats

[PGStats]

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

[Tal]

thanks a lot