I have a txt file to read in like so (headers are added by me):  ID                  Last      First        Guardians                               Address 1968451595,"Smith","Dianne","Smith, Patty or Smith, David","90 Flyth Rd",   Here is my infile statement: infile "G:\Departments\Research\test scores\GT\&yr.\GIFT.txt" dlm = '",' MISSOVER lrecl=32767 firstobs=2 ;   The problem I'm encountering is the guardian field > "Smith, Patty or Smith, David". Many of observations have commas that are meant to simply separate their last and first name but are not meant to be delimiters. This is causing my SAS data set to read invalid data for these observations. ... View more

My data set consists of grade progressions of students over 13 school years (04-05 to 16-17). Every student identified has been retained at least once during his/her enrollment in our system. My task is to identify which school year the retention occured. The header row represents the school year, e.g. grade17 is the 16-17 school year, grade16 is the 1516 school year, etc. The values represent the grade the student was in. A zero stands for kindergarten; a missing value means the student was not enrolled in that particular year.   Student 1 should be flagged as being retained in grade 12 after the 14-15 school year and the 15-16 school year. Student 2 should be flagged as being retained in grade 10 after 13-14 school year. Student 3 should be flagged as being retained in grade 0 (kindergarten) after the 05-06 school year.     ID grade17 grade16 grade15 grade14 grade13 grade12 grade11 grade10 grade09 grade08 grade07 grade06 grade05 1 12 12 12 11 10 9 9 7 6 5 4 3 2 2 12 11 10 10 9 . . . . . . . . 3 10 9 8 7 6 5 4 3 2 1 0 0 . ... View more