Jason,

Can you provide some sample data, including at least two students and two or more assessments, and the file you would want to end up with from that sample?

Sounds like something you could do with proc transpose.

Art -------- On Sat, 24 Oct 2009 07:19:44 -0400, Jason Schoeneberger <jschoeneberger@CAROLINA.RR.COM> wrote:

>I have normalized assessment data, with items nested within students. I >would like to define an array based on the item numbers in the variable ITEM >in my data file. Current values are i1, i2...ik. Is there a way to create >an array reference based on the unique values in my ITEM field? Note, i'm >searching for a solution flexible enough that can handle the identification >of different arrays across different assessments. In other words, the first >assessment may have items i1 - i20, the second assessment may have items i1 >- i30. > >Thanks, > >J