Hi masters!   I wonder how I can reformat my datafile.   My current format is like: Year        Student1     Student2     2015          1                     0              2016          0                     1         2017          1                     1         My wanted format is like: Student       Year      Var          Student1     2015      1  Student1     2016      0 Student1     2017      1 Student2     2015      0 Student2     2016      1 Student2     2017      1   Thank you for your help Masters!   ... View more

Hi, I want to replace values with the beginning values.   For example..   Data example; input id year cc; 101 2000 0.2 101 2001 0.3 101 2002 0.4 101 2003 0.3 102 1990 0.5 102 1991 0.3 102 1992 0.6 102 1993 0.4 103 2004 0.3 103 2005 0.4 103 2006 0.6 ; run;   After replace the values of cc with the beginning period value of cc by id, I want to have the new data set looking like... Data want; input id year cc; 101 2000 0.2 101 2001 0.2 101 2002 0.2 101 2003 0.2 102 1990 0.5 102 1991 0.5 102 1992 0.5 102 1993 0.5 103 2004 0.3 103 2005 0.3 103 2006 0.3 ; run;   Thank you! ... View more

Hi,   I want to restrict my sample to have quasi-balanced pre-and post- observations..   For example,   Data original; input supplier customer year post; datalines; 1001 8001 2000 1 1001 8001 2001 1 1002 8006 1995 0 1002 8006 1996 0 1002 8006 1997 1 1002 8006 1998 1 1002 8006 1999 1 1003 8008 2005 0 1003 8008 2006 0 1003 8009 2006 0 1003 8009 2007 1 ; run;   I want to keep observations having both pre-and post- period. That is, I want to exclude observations having only (Post = 0s) or (Post = 1s).   So, I want to have like this datasets.. after coding;   Data hope; input supplier customer year post; datalines;   1002 8006 1995 0 1002 8006 1996 0 1002 8006 1997 1 1002 8006 1998 1 1002 8006 1999 1   1003 8009 2006 0 1003 8009 2007 1 ; run;   Thank you!   ... View more

Hi,   I want to isolate the first pre-and post observations.    For example,   data example; input id year event; datalines; a 1990 0 a 1991 0 a 1992 0 a 1993 1 a 1994 0  a 1995 0 a 1996 1 a 1997 0 b 1993 0 b 1994 0 b 1995 1 b 1996 0 b 1997 1 b 1998 0 b 1999 0 ; run;   I want to get this dataset. like..   data hope; input id year event; datalines; a 1990 0 a 1991 0 a 1992 0 a 1993 1 a 1994 0  a 1995 0   b 1993 0 b 1994 0 b 1995 1 b 1996 0   ; run;   please help! ... View more

Hi,   I need to identify observations having multiple options (Name -> Name2). Here is my data like...   Data test; input ID NAME $ NAME2 $ Year; datalines; 1 Highland HighlandBell 2008 1 Highland HighlandBell 2009 1 Highland HighlandBell 2010 1 Highland HighlandCorp 2008 1 Highland HighlandCorp 2009 1 Highland HighlandCorp 2010 1 Highland HighlandMalt 2008 1 Highland HighlandMalt 2009 1 Highland HighlandMalt 2010 2 HillBrosINC HillBrosINC 2011 2 HillBrosINC HillBrosINC 2012 3 HitachiLTD HitachLTD 2008 ; run;   So, I want to create one additional column to the dataset. Like..   Data test; input ID NAME $ NAME2 $ Year Want; datalines; 1 Highland HighlandBell 2008 1 1 Highland HighlandBell 2009 1 1 Highland HighlandBell 2010 1 1 Highland HighlandCorp 2008 1 1 Highland HighlandCorp 2009 1 1 Highland HighlandCorp 2010 1 1 Highland HighlandMalt 2008 1 1 Highland HighlandMalt 2009 1 1 Highland HighlandMalt 2010 1 2 HillBrosINC HillBrosINC 2011 0 2 HillBrosINC HillBrosINC 2012 0 3 HitachiLTD HitachLTD 2008 0 ; run;   Thank you! ... View more