You can use a BY statement in PROC UCM to get the analysis by group.  You can use the ODS OUTPUT statement to save the parameter estimates in a data set.  Then you can combine the parameter estimates with the original data set.   data work; input group $ price; datalines; A 0.5 A 0.4 A 0.8 A 0.1 B 0.3 B 0.2 B 0.5 ; run; proc print data=work; run; ods trace on; ods select ParameterEstimates; ods output ParameterEstimates=myEstimates; proc ucm data=work; model price; by group; irregular plot=smooth; level checkbreak plot=smooth; estimate plot=residual; forecast plot=forecasts lead=10 alpha=0.5; run; proc print data=myEstimates; run; proc transpose data=myEstimates(keep=group component estimate) out=transposedEstimates; by group; id component; run; proc print data=transposedEstimates; run; proc sql; create table myResults as select a.*, b.irregular as IrregularComponent, b.level as LevelComponent from work as a, transposedEstimates as b where a.group=b.group; quit; proc print data=myResults; run; ... View more

options mprint; data source1; set sashelp.class; run; data source2; input name; datalines; ; run; data source3; set sashelp.cars; run; %macro abc(input); proc sql noprint; select count(*) into :obs_count from &input; quit; %if &obs_count gt 0 %then %do; data want; set &input.; run; %end; %mend abc; %abc(source1); %abc(source2); %abc(source3); ... View more

proc print data=sashelp.class; run; data class; set sashelp.class; if 16 le age le 22 then age=.; run; proc print data=class; run; ... View more

You can use outputwidth=100% to make the highlighting extend across the entire line.  So that line of code becomes this:   ods rtf text="^S={outputwidth=100% &titlestyle}TEST TITLE 2: BLABLABLA"; https://communities.sas.com/t5/ODS-and-Base-Reporting/ODS-Text-table-width/td-p/129071 also shows the syntax if you want to add it to your style template.   ... View more

data fruit_info; length fruit $ 10; input observation fruit_id fruit $ color $ shape $; datalines; 1 1 Banana Yellow Odd 2 2 Apple Red Circle_1 3 2 Apple Green Circle_2 4 3 Orange Orange Circle 5 4 Watermelon Green Oval 6 5 Berry Blue Odd_1 7 5 Berry Red Odd_2 8 5 Berry Purple Odd_3 9 6 Peach Peach Circle ; run; proc print data=fruit_info noobs; title 'Input data set'; run; proc sort data=fruit_info; by fruit_id; run; data fruit_info_retained; length color_joined shape_joined $ 50; retain color_joined shape_joined; set fruit_info; by fruit_id; if first.fruit_id then do; color_joined = color; shape_joined = shape; end; else do; color_joined = catx(', ', color_joined, color); shape_joined = catx(', ', shape_joined, shape); end; run; proc sort data=fruit_info_retained; by observation; run; proc print data=fruit_info_retained noobs; title 'Output data set'; var observation fruit_id fruit color shape color_joined shape_joined; run; ... View more