Hi, I'm trying to build the following output per ID: I found this code in another thread: proc report data=split5 nowd out=split6;
column ('CGID' cgid) Theme1, theme2, count;
define cgid / group '';
define theme1 / across '';
define theme2 / across '';
define count / '';
run; quit; but when I run this, I get all the subcolumn names in every head column (so Product experience gets 9 subcolumns, Value for money gets 9 subcolumns and the same goes for Content). Herewith some sample code: data WORK.SPLIT5;
infile datalines dsd truncover;
input CGID:$7. Theme1:$150. Theme2:$150.;
label CGID="CGID";
datalines;
2782189 Value for money Alignment with needs & expectations
2782189 Value for money Price transparancy
2782189 Product experience Speed
2782189 Product experience Search & filter options
2782189 Product experience Search results relevancy
2782189 Product experience Design
2782228 Content Quality of forms & tools (calculator, calendars)
2782228 Content Content quality
2782228 Value for money Price transparancy
2782231 Content Content quality
;;;; I'd like it to be as flexible as possible, as new 'Theme 2' options might come up every month... Does anyone know a fix for this? Thanks in advance, Evelien
... View more