I have a dataset on properties, where each property has several years of observations. With that, each property is assigned as either independent or branded. Some properties, though, switched from independent to branded (or vice versa) in one of their years. Right now, I have a "branded" variable that is either 0 or 1. For example, property 1 could have data from 2002 to 2011 and be branded (branded=1) in all of the years. Property 2 could have data from 2005 to 2012 and be independent (branded=0) for all the years. Property 3, which is the one I would be interested in, could be branded (branded=1) from 2000 to 2009, then independent (branded=0) from 2010 and on. My end goal is to create 3 more summy variables: 1 that tells if the property switched, 1 that is tells is it switched from branded to independent, and another that tells if it switched from independent to branded. The variables I have to work with are: propertyID, address, and branded. What I've tried so far: First, I successfully made a new dataset, the one I'm using below, that is only of hotels that changed. I just need to see which year and which way they changed. proc sort data=changed_props;
by address year;
run;
/*This is where I'm running into an issue. I am only looking for hotels that changed from branded=0 to branded=1.
What I want is to tell when they changed either way. I thought about doing 2 of these blocks of code and merging them,
But I worry that I'll be getting the first year of data for each property rather than just the year it changed*/
data changed_props_temp;
set changed_props;
by address;
where branded>0;
if first.address;
year_changed = year;
change_year = 1;
keep address year_changed change_year branded;
run;
*Putting it back;
data changed_props;
merge changed_props changed_props_temp;
by address;
if year = year_changed then change_year=1;
else change_year=0;
run; In all, what I need is to tell when the branded variable switches from 0 to 1 or 1 to 0 from the past observation with the same address. Thanks for the help.
... View more