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