SAS-L archives -- May 2009, week 1 (#30)

Date:	Fri, 1 May 2009 09:34:33 -0700
Reply-To:	sasbegy <pattukuttani@GMAIL.COM>
Sender:	"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:	sasbegy <pattukuttani@GMAIL.COM>
Organization:	http://groups.google.com
Subject:	Looping through Months
Comments:	To: sas-l@uga.edu
Content-Type:	text/plain; charset=ISO-8859-1

Hi,

I have a data set like

Month Stud_Name Class 200901 xxx 2 200812 xxx 1 200901 yyy 2 200812 yyy 1 200810 rrr 1

I need help to get the month into an array and initialize to zero starting from the latest month to 12 months past data.

Then assign the values to the months where the value is available.

200901 200812 200811 200810 XXX 2 1 0 0 YYY 2 1 0 0 RRR 0 0 0 1

Is it do able ?