data sample_data;
length var1 8 var2 $6  var3 $10 var4 $10 var5 $15;
input var1 var2 $ var3 $ var4 $ var5 $;
datalines;
1 12345 value1 var1 something
1 12345 value2 var2 something
1 12345 value3 var3 something
1 12345 value4 var4 something
1 12345 value5 var5 something
1 12346 value1 var1 something
1 12346 value2 var2 something
1 12346 value3 var3 something
1 12346 value4 var4 something
1 12347 value1 var1 something
1 12347 value2 var2 something
1 12347 value3 var3 something
1 12347 value4 var4 something
1 12348 value1 var1 something
1 12348 value2 var2 something
1 12348 value3 var3 something
1 12348 value4 var4 something
1 12348 value5 var5 something
1 12349 value3 var3 something
1 12349 value5 var5 something
2 54321 value1 var1 something
2 54321 value2 var2 something
2 54321 value3 var3 something
2 54321 value4 var4 something
2 54322 value1 var1 something
2 54322 value2 var2 something
2 54322 value3 var3 something
2 54322 value4 var4 something
2 54323 value1 var1 something
2 54323 value2 var2 something
2 54323 value3 var3 something
2 54323 value4 var4 something
2 54324 value1 var1 something
2 54324 value2 var2 something
2 54324 value3 var3 something
2 54325 value3 var3 something
2 54325 value4 var4 something
2 54325 value5 var5 something
2 54326 value1 var1 something
2 54326 value4 var4 something
;
run;

proc format; 
value var
1='format1'
2='format2';
run;

data sample_data;
set sample_data;
dummy=1;
run;

proc report data=sample_data out=testi spanrows;
col ('Title1' var1) ('Title2' var2 ) (var3,var4),(var5) dummy;
define var1 /'' order=internal group format=var.;
define var2 /'' group;
define var3 /'' across nozero missing order=internal;
define var4 / '' across nozero;
define var5/'' missing;
define dummy/noprint;
run;

/*
Already tried methods:
http://www.sascommunity.org/wiki/Repeating_Group_variable_values_in_PROC_REPORT
and
http://www.sascommunity.org/wiki/How_to_Display_values_for_every_row_of_an_Order_or_Group_Report-Item_in_Proc_Report_without_using_an_Alias
and the output dataset method (which won't work for general use because of the varying across variabels):
https://communities.sas.com/t5/SASware-Ballot-Ideas/Add-Repeat-Option-on-Proc-Report-Group-Variables/idi-p/219992
*/