I have simple frequency data that I'd like to disaggregate in order to have a better look at the distribution. I have been messing around with this to no avail! Proc expand is for temporal data, but is is simple frequencies.   My data consists of the number of words used to describe symptoms in one field (Field A) in a report. The variable 'number of reports' is the total number of reports that had a specific word count in Field A. For example, the first line of the table can be described as the following: 941 reports had 1 word in Field A.    Thoughts/suggestions?    Example data: Word Count Number of Reports 1 3 2 7 3 5 4 6 5 10 6 8 7 7 8 2 9 3 10 1   What I want it to look like: Word Count Arbitrary Report ID 1 A 1 B 1 C 2 D 2 E 2 F 2 G 2 H 2 I 2 J   Thank you!  ... View more