Recently in the SAS Community Library: SAS' @BethEbersole reveals 4 steps to stop money laundering, solve law-enforcement cases, find missing children and more with SAS Visual Investigator.
Hi I am new to proc template . 1. I am displaying bar value at the top of bar using barlabel=true. How to display the value at the center of the bar instead of top? 2. Also, how to wrap x axis value. text variable have one value very long 3. what option in proc template i can use to display P value at the top. Thanks in advance
... View more
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 that indicate the first admission for that patient.
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
Hi everyone, I would like to make a table which displays a total of all non-missing values across multiple class row variables, for each level of the column variable. My idea was this code: PROC TABULATE data=have missing; class columnvar rowvar1-rowvar10; table rowvar1-rowvar10 all, columnvar; run; but unfortunately it doesn't work. Instead of displaying the total of all non-missing values across all the row variables in the ALL variable, it just provides a total of the last rowvariable 10. Many thanks in advance, Curt
... View more
Proc export giving additional quotes to the quoted char values.and if u use data step for that it is giving a space or . To numeric values which is not required . Needs to change nothing.now it is , , but want ,, no space no .for missing numeric value.
... View more
Hello Community, I'm at a crossroads and would appreciate your insights. I aspire to work as a biostatistician or data scientist in the pharmaceutical sector, where proficiency in SAS is often a prerequisite. While I haven't used SAS in my previous roles, it seems crucial for roles in the pharma industry. Considering this, do you think it's worth investing 1-2 years to learn SAS for my career goals, or do you foresee a shift towards R/Python in these industries in the near future? Your advice and perspectives are highly valued. Thanks in advance!
... View more