We are using SAS Enterprise Guide.  This is the error message we are getting:   ERROR: A lock is not available for DATA.AZPICU1CON_20211122.DATA. NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set DATA.AZPICU1CON_20211122 was only partially opened and will not be saved.   We can't figure out how to resolve this error.  This is the code that we are running when the error occurs:   data &consented; set &out; if consent=0 then delete; else if consent=. then delete; surveydate=datepart(initial_survey_timestamp); format surveydate date9.; drop initial_survey_timestamp; *calculating age; if childdob^=. then childagec=round(%age(surveydate,childdob)/12, .01); label childagec="Child age calculated(years)"; if childagec=. then childagec_4cat=.; else if childagec<1 then childagec_4cat=1; else if childagec>=1 and childagec<5.9 then childagec_4cat=2; else if childagec>=5.9 and childagec<13 then childagec_4cat=3; else if childagec>=13 then childagec_4cat=4; format childagec_4cat childage.; label childagec_4cat="Child age calculated_4cat"; if childagec=. then childagec_3cat=.; else if childagec<1 then childagec_3cat=1; else if childagec>=1 and childagec<5.9 then childagec_3cat=2; else if childagec>=5.9 then childagec_3cat=3; format childagec_3cat childage_3cat.; label childagec_3cat="Child age calculated_3cat";   run;   Any help would be much appreciated. Thanks! ... View more

Hello.  I have data like this (see below), but it has over 4,000 patientID, encounterID, and date/time combinations.  I want to be able to write code to condense the data down to 1 row per patientID, encounterID, date/time combination.     patientID encounterID Date/time variable1 variable2 variable3 variable4 variable5 1 333 7/11/2016 19:01       6   1 333 7/12/2016 19:01           1 333 7/13/2016 19:01 13         1 333 7/14/2016 19:01     15     1 333 7/15/2016 19:01           1 333 7/16/2016 19:01           1 333 7/17/2016 19:01         8 1 333 7/18/2016 19:01   24       1 333 7/19/2016 19:01           1 333 7/20/2016 19:01             So in the example above I would end up with 1 row like this (see below), but I want to use simple code to handle all of the 4,000+ combinations of patientID, encounterID, and date/time.   patientID encounterID Date/time variable1 variable2 variable3 variable4 variable5 1 333 7/11/2016 19:01 13 24 15 6 8   Thanks! ... View more