Hello, I am fairly new to the SAS environment and I am now stuck and having some issues using PROC FREQ to aggregate my data by response patterns. I have over 30,000 observations and about 10 variables I would like to aggregate. As an example... my individual response data looks like Table 1 and would like to aggregate the patterns of response to look like Table 2. Thanks for your help!   Table 1 Do you drink…..everyday ? 1 = Yes 2 = No ID Tea Coffee Juice  Wine Beer Water 1 1 2 1 2 1 2 2 2 1 2 1 2 1 3 2 1 2 1 2 1 4 1 2 1 2 1 2 5 1 1 1 1 1 1 6 1 1 1 1 1 1 7 2 2 2 2 2 1 8 2 2 2 2 2 1 9 2 2 2 2 2 1 10 1 1 1 1 1 1     Table 2    Patterns of response    Tea Coffee   Juice Wine   Beer Water  Count (total number of participants with that pattern of response to all the variables) 1 2 1 2 1 2 2 2 1 2 1 2 1 2 1 1 1 1 1 1 3 2 2 2 2 2 2 3 ... View more