Thoughts of a Crime Show Junkie: Inadmissible Evidence
Recent Library Articles
Recently in the SAS Community Library: SAS' @RhondaWilliams reveals how SAS Law Enforcement Intelligence helps law enforcement agencies expedite detailed data entry using the Evidence Creation feature.
Hi guys,
suppose to have the following:
data DB1;
input ID Index_date Code Admission Discharge Status Date;
format Admission Discharge date9.;
cards;
0001 1 49121 11JAN2018 07FEB2018 Died .
0001 1 4660 11JAN2018 07FEB2018 Died .
0001 0 4821 23MAY2021 21JUN2021 Died .
0002 1 4660 01OCT2017 10OCT2017 Died .
0003 1 4659 30MAY2017 7JUN2017 Died .
0003 0 4659 01JAN2018 10JAN2018 Died .
0004 1 V0182 11NOV2021 17NOV2021 Died .
0004 1 V0182 11NOV2021 17NOV2021 Died .
0004 1 4829 11NOV2021 17NOV2021 Died .
;
data DB2;
input ID Index_date Code Admission Discharge Status Date;
format Admission Discharge date9.;
cards;
0001 1 49121 11JAN2018 07FEB2018 Died 22JUN2021
0001 1 4660 11JAN2018 07FEB2018 Died 22JUN2021
0001 0 4821 23MAY2021 21JUN2021 . .
0002 1 4660 01OCT2017 10OCT2017 Died 11OCT2017
0003 1 4659 30MAY2017 07JUN2017 Died 11JAN2018
0003 0 4659 01JAN2018 10JAN2018 . .
0004 1 V0182 11NOV2021 17NOV2021 Died 18NOV2021
0004 1 V0182 11NOV2021 17NOV2021 Died 18NOV2021
0004 1 4829 11NOV2021 17NOV2021 Died 18NOV2021
;
The desired output id DB2.
I would like to assign the death date as the day after the last recorded discharge date for each ID. It could happen that there is only one Admission-Discharge date for a patient like for ID = 002. Doesn't matter. It could also happen that the Admission-Discharge date is repeated equally (es: ID: 004). This happens because of different recorded codes. Doesn't matter. The death date should be the first day after the last (and repeated) discharge date. Patients are sorted by ID and Admission date. Note that there is also an Index_date (if it can help) that indicate the first admission for that patient, if it can help.
Finally the format of the table DB2 should be changed with respect to DB1. The death date and the word "Died" should be added to the row where Index_date = 1.
Can anyone help me please?
Thank you in advance
... View more
I have a data set contains DMRN, last visit date, the presence of UI, and recorded date of UI.
DMRN
last_visit
UI
recorded_time
31
26AUG2021
0
06APR2018
31
26AUG2021
0
16JAN2020
31
26AUG2021
1
4MAY2021
33
24MAY2022
0
02MAR2020
33
24MAY2022
0
24MAY2022
35
01DEC2014
0
25MAR2013
I would like to create new_date for each DMRN based on these conditions: if UI = 1 then new_date = recorded_time else if UI = 0 then new_date = last_visit The outcome would be like as follow:
DMRN
last_visit
UI
recorded_time
new_date
31
26AUG2021
0
06APR2018
4MAY2021
31
26AUG2021
0
16JAN2020
4MAY2021
31
26AUG2021
1
4MAY2021
4MAY2021
33
24MAY2022
0
02MAR2020
24MAY2022
33
24MAY2022
0
24MAY2022
24MAY2022
35
01DEC2014
0
25MAR2013
01DEC2014
Could you please help me with the code? Thank you very much
... View more
Hi, I have a dataset where the year goes from [2000,2015] where I have these countries: Spain, France, Denmark and European Union and let's say two colomns; company='A' and 'B' and value='dollar' Q1: if Spain for company A have average vaule 0.288 Denmark also France also for aaaalll of the 15 years. BUT! We have EU (recall, France, Spain, Denmark are all in European Union (EU)) and for one (1) year EU have the avarage for the same company A, have tha average vaule at 1,000 Q2: For company B;, France, Spain, Denmark and European Union (EU)) have data from [2000,2015] and have ~the same avarage all the four, how to solve that issue besT?
... View more
Would u like to help me to categorize market values into three groups labeled as small, mid, and big? FIRMS ARE ASSIGNED TO A SIZE QUARTILE GROUP BASED ON THEIR PREVIOUS MONTH’S MARKET VALUE OF EQUITY THE 0~<25% ARE GROUP BY SMALL SIZE, THE 25%~<50% ARE GROUP BY MEDIUM SIZE, THE 50%~100% ARE GROUP BY BIG SIZE. PROC SORT DATA BY DATE PERMNO MARKET VALUE(SMALL TO BIG), AND GIVE EACH DATE PERMNO MARKET VALUE. DATA SORTED;
SET SORTED;
BY DATE PERMNO;
IF LAST.PERMNO THEN DO;
CALL STREAMINIT(123);
RANK = RANKTIE(LAST_MONTH_MV, 'DESCENDING');
PCTILE = RANK / (LAST.PERMNO + 1);
IF PCTILE < 0.25 THEN SIZE_GROUP = 'SMALL';
ELSE IF PCTILE < 0.50 THEN SIZE_GROUP = 'MEDIUM';
ELSE SIZE_GROUP = 'BIG';
END;
RUN; ERROR 68-185: The function RANKTIE is unknown, or cannot be accessed.
... View more