Date:         Fri, 10 Feb 2012 14:44:39 -0500
Reply-To:     Casey Dietz <cldietz@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Casey Dietz <cldietz@GMAIL.COM>
Subject:      Re: Tracking Account "Flow" Month over Month
Comments: To: Mike Zdeb <mzdeb@ALBANY.EDU>

Thanks for the reply Mike!
I'm not sure if I can transpose the data or not, my dataset is really wide
and really deep. Each month contains roughly 2MM records, and there are
about 70 variables.
I tried to create a view so that I could sort it, and use lag() but was
unable to get that working. So, I then made up the sample dataset that I
posted the question to.
Do you think it's possible to do without transposing?
Thanks,
Casey