I need help computing a change variable using panel dataset

[Virginia Razo]

I have a panel data set and I need to compute the percent change in a continuous variable for a 4 year period.  How can I compute this in SPSS?  

My data looks like this

Hospital 1          2008        unemployment rate
Hospital 1          2009        unemployment rate
Hospital 1          2010        unemployment rate
hospital 1          2011        unemployment rate
hospital 2          2008        ""
hospital 2          2009         ""
etc.

Can anyone assist me with this type of calculation using a panel data set?

Thanks,
Ginny Razo

[David Marso]

See LAG function in the manual!
DO IF will be useful as well!
----------------
 

Virginia Razo wrote

I have a panel data set and I need to compute the percent change in a
continuous variable for a 4 year period.  How can I compute this in SPSS?

My data looks like this

Hospital 1          2008        unemployment rate
Hospital 1          2009        unemployment rate
Hospital 1          2010        unemployment rate
hospital 1          2011        unemployment rate
hospital 2          2008        ""
hospital 2          2009         ""
etc.

Can anyone assist me with this type of calculation using a panel data set?

Thanks,
Ginny Razo

[Melissa Ives]

Ore CasestoVars by hospital and then calculate directly across the new row.

-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of David Marso
Sent: Thursday, May 31, 2012 11:55 PM
To: [hidden email]
Subject: Re: [SPSSX-L] I need help computing a change variable using panel dataset

See LAG function in the manual!
DO IF will be useful as well!
----------------

Virginia Razo wrote

>
> I have a panel data set and I need to compute the percent change in a
> continuous variable for a 4 year period.  How can I compute this in SPSS?
>
> My data looks like this
>
> Hospital 1          2008        unemployment rate
> Hospital 1          2009        unemployment rate
> Hospital 1          2010        unemployment rate
> hospital 1          2011        unemployment rate
> hospital 2          2008        ""
> hospital 2          2009         ""
> etc.
>
> Can anyone assist me with this type of calculation using a panel data set?
>
> Thanks,
> Ginny Razo
>

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/I-need-help-computing-a-change-variable-using-panel-dataset-tp5713458p5713460.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

PRIVILEGED AND CONFIDENTIAL INFORMATION
This transmittal and any attachments may contain PRIVILEGED AND
CONFIDENTIAL information and is intended only for the use of the
addressee. If you are not the designated recipient, or an employee
or agent authorized to deliver such transmittals to the designated
recipient, you are hereby notified that any dissemination,
copying or publication of this transmittal is strictly prohibited. If
you have received this transmittal in error, please notify us
immediately by replying to the sender and delete this copy from your
system. You may also call us at [phone] for assistance.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD