I am trying to save SAS report into xlsx file. For this purpose, I used "ods excel" function. My hoping results was generated by "proc freq" procedure which has each row and col percentage. At this point, the problems came out. In the result xlsx file, counting values and each row and col percentage values are in the same cells. This make difficulties on following data handling steps. Is there any option that can handle this issue??
*now
year | var1 | var2 |
---|---|---|
2010 | 3 3.0 15.0 |
97 97.0 85.0 |
want
year | var1 | var2 |
---|---|---|
2010 | 3 | 15 |
3.0 | 97.0 | |
15.0 | 85.0 |
You appear to be producing a cross tabulation in
Proc FREQ
.You can capture the ODS data that is used to created the output you don't like and manipulate it a way to create output that you do like.
The ODS OUTPUT, when transposed, creates a table that can be simply Proc PRINTED and will contain the repetitions you want.
Example:
Note:
If you capture the cross tabulation output (per Stu) you likely would have to create a pivot table in Excel, and even that would create merged cells you don't like. Pivot table in Excel does have built in filtering UI.