Hi mkeintz,
Thank you so much for your response. I understand that I should have originally attached the working dataset. I thought the file would be too long to attach. However, I am still getting the error message, and I am new to SAS so I don't totally understand what I going on. I got the following error now.
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column). 4 at 65:6 4 at 65:61
I have attached the SAS data file and also copied the dataline (if the file doesn't work).
data test;
infile datalines delimiter=',';
input id dateoftest :mmddyy8. diagnosis weight;
datalines;
1, 4/8/2009, 0, 98,
1, 11/3/2009, 0, 99,
1, 12/4/2009, 0, ,
1, 1/8/2010, 1, 89,
1, 3/24/2010, 0, 76,
1, 4/4/2011, 0, 75,
1, 7/14/2011, 0, 70,
2, 4/23/2016, 0, 122,
2, 5/20/2016, 0, 124,
2, 7/10/2016, 0, ,
2, 9/25/2017, 0, 120,
3, 2/9/2009, 0, 119,
3, 2/10/2009, 0, ,
3, 4/16/2009, 1, 120,
3, 5/23/2009, 0, 105,
3, 6/17/2010, 0, 98,
3, 5/12/2011, 0, 94,
4, 3/23/2018, 0, ,
4, 2/10/2018, 0, ,
4, 4/18/2018, 0, ,
4, 4/15/2018, 1, ,
4, 7/3/2019, 0, ,
5, 12/4/2014, 0, 130,
5, 1/3/2015, 0, 120,
5, 2/12/2015, 0, 95,
5, 4/23/2015, 1, 96,
5, 5/5/2015, 0, 87,
5, 8/9/2016, 0, 88,
6, 12/4/2013, 0, 98,
6, 1/3/2013, 0, 80,
6, 2/12/2013, 0, 79,
6, 4/23/2013, 1, 78,
6, 5/5/2013, 0, 75,
6, 8/9/2014, 0, 74,
7, 12/4/2018, 0, 81,
7, 1/3/2018, 0, 80,
7, 2/12/2018, 0, 79,
7, 4/23/2018, 1, 78,
7, 5/5/2018, 0, 75,
7, 8/9/2018, 0, 74,
8, 4/8/2012, 0, 140,
8, 11/3/2012, 0, 99,
8, 12/4/2012, 0, ,
8, 1/8/2013, 1, 89,
8, 3/24/2013, 0, 76,
8, 4/4/2013, 0, 75,
8, 7/14/2013, 0, 70,
;
run;
I really appreciate your help. Thanks. Sandyzman1
... View more
