Hi there, I have a variable "studytype" and further variables var1, var2, var3. Now I want to create an Excel file, that lists all data with var1-var3, grouped by studytype. Before a new studytype starts, I want to add a Headline mentioning the studytype. For example: studytype var1 var2 var3 A 1 abcd 1111 A 1 werewre 234234 B 1 jwlkerjwerkl 3423432 Should appear like: A 1 abcd 111 1 werewere 234324 B 1 jwlkerjwerkl 3423432 My code: Ods tagsets.ExcelXP path=&path. file='out.xml' style=seaside;
proc report data=mydata nowd;
column studytype var1 var2 var3;
define studytype/ order noprint;
break before studytype / skip;
compute before studytype;
line'';
endcomp;
run;
ods tagsets.ExcelXP close; It´s quite close to what I need, but how can I get the studytype (current value of studytype for this break) in the Headlines created by the "line" statement? Thanks a lot for your Input.
... View more