Hi All, I have SAS dataset that I'm converting into a .xml file using proc report n ODS. There are 7 variables in that dataset and sorted in the order I need. The group variable is var1 which has different values and each unique value has either 1,2 or more rows with different values of other variables (var5,var6,var7). var2,3, and 4 will have same values for each group. Problem: I need to display the variables Var1-4 only once for each group. var1 var2 var3 var4 var5 var6 var7 a1 1 ht 4 444 ttgf q1 a1 1 ht 4 453 f3rge w1 a2 4 ht 22 dfewrt a1 a3 545 cs 12 ffre d1 a3 545 cs 12 425 fef d1 a3 545 cs 12 234 f34 f1 This is what I require: var1 var2 var3 var4 var5 var6 var7 a1 1 ht 4 444 ttgf q1 453 f3rge w1 a2 4 ht 22 dfewrt a1 a3 545 cs 12 ffre d1 425 fef d1 234 f34 f1 Which type of variable should be used in proc report for Var1-4?? Display? group? order? Thanks Pihu
... View more