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;
use UNION
title;
proc sql;
select count(brand) label="Hello" from mylib.cars
union all
select count(model) from mylib.cars;
quit;
use UNION
title;
proc sql;
select count(brand) label="Hello" from mylib.cars
union all
select count(model) from mylib.cars;
quit;
works well for one line titles. Thanks PG Stats
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
thanks a lot
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.