Hello everyone, I was fortunate enough to get some help yesterday here and again thanks to the two members. My dataset has a number of faulty registrations that I need to address and I hope you guys can help out. I’m trying to calculate the total number of days each per_id stays at a given inst_id. I have tried to illustrate the four main issues. Issue 1 : A stay for the same person is registered at an institution B during a stay at institution A (row 1 and 2). Row 2 should be removed entirely. Issue 2. A stay at an institution B starts during a stay at inst A and ends after moveout date for inst A. The movein date at inst B should be rectified to moveout date at inst A. Issue 3: sort of the reverse to issue 2. The two separate stays at inst c should be put together to one long stay. Issue 4: this is a special case where the person moves in and out on the same date. I would like to keep these, unless they are during the middle of a different stay (like issue 1) It’s quite a mouthful but the end goal is a tidy data set with one row per person per institution per period. Any help is greatly appreciated. Inst_id Per_id bbMovein Moveout A A. 01JAN2022 10JAN2022 B. A. 03JAN2022 07JAN2022 A. B. 04JAN2022 08JAN2022 B. B. 07JAN2022. 11JAN2022 C. C. 05JAN2022. 08JAN2022 C. C. 08JAN2022. 09JAN200 E. D. 02JAN2022 02JAN2022 ... View more

Dear sas community,   im fairly new at sas and have a problem i hope you Can help me solve. My dataset looks like this id.   Moveindate moveoutdate a      Jan. 1.2021.          Jan.4.2021 b.      Jan.2.2021.         Jan.3.2021   i Want to create dummy columns for each day of the Month that take the value 1 if the date is within the range of moveindate and moveoutdate. So for example it would look like this id.   Moveindate moveoutdate jan1 jan2 jan3 jan4 a      Jan. 1.2021.          Jan.4.2021 1.    1.        1.      1 b.      Jan.2.2021.         Jan.3.2021 0.   1.        1.       0   i Can do this the brute Way by using datastep like Below, but its tedious and error prone since i eventually plan on doing it for every month of the year. I hope you Guys Can help. Thanks in advance data want; set have; jan1=0; if moveindate<=`01jan2021` and moveoutdate=>´01jan2021` then jan01=1; run;   ... View more