Hello, I have a data set with about 4000 observations and about 100 distinct types in the variable type column. I need to print each type of data to one excel file with different worksheets and the worksheet name is the type name. For example, I have data dset missover; input id type$ rev1 rev2 notes$; cards; 1 a 20 10 yet 2 b 10 15 yes 3 c 15 12 no 4 b 10 10 . 5 a 10 . yet 6 d 10 2 ok 7 e 5 5 but 8 g 20 30 one 9 k 5 6 three 10 g 8 9 one ; run; So the distinct types are: a, b, c, d, e, g, k in this example I expect to print one excel or csv file with worksheet name: a id type rev1 rev2 notes 1 a 20 10 yet 5 a 10 . yet worksheet name: b id type rev1 rev2 notes 2 b 10 15 yes 4 b 10 10 worksheet name: c id type rev1 rev2 notes 3 c 15 12 no ....... and so on...... I expect to use the distinct type names as an array when I print each worksheet, since the types will be changed each time and there are more than 100 types when I do the report. Any suggestions, solutions, or hints will be very appreciated.
... View more
