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
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?