topic titles in SAS Procedures

titles

Tal — Sat, 13 Sep 2014 21:56:21 GMT

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

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;

Re: titles

PGStats — Sat, 13 Sep 2014 22:25:08 GMT

use UNION

title;

proc sql;

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

union all

select count(model) from mylib.cars;

quit;

Re: titles

Tal — Sun, 14 Sep 2014 00:25:13 GMT

works well for one line titles. Thanks PG Stats

Re: titles

PGStats — Sun, 14 Sep 2014 01:19:50 GMT

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;

Re: titles

Tal — Sun, 14 Sep 2014 15:01:53 GMT

thanks a lot