Hello, I'm running into a strange issue. I'm trying to assign values to the variable YEARBUILT based on the value of CNS_P_LBL like so: data OUTPUT;
length YEARBUILT $100;
format YEARBUILT $100.;
informat YEARBUILT $100.;
length CNS_P_LBL $16;
if CNS_P_LBL = "1971-1990" then YEARBUILT = "01/01/1971";
if CNS_P_LBL = "1991-2000" then YEARBUILT = "01/01/1990";
if CNS_P_LBL = "2001-2005" then YEARBUILT = "01/01/2003";
if CNS_P_LBL = "2006-2010" then YEARBUILT = "01/01/2008";
if CNS_P_LBL = "2011-2015" then YEARBUILT = "01/01/2013";
if CNS_P_LBL = "2016-2020" then YEARBUILT = "01/01/2018";
if CNS_P_LBL = "1970 or before" then YEARBUILT = "12/31/9999";
set INPUT; However, this results in shifted YEARBUILT values by one row. It is shown in the picture below. What am I doing wrong? Thank you in advance. Best regards.
... View more