Suppose to have the following:
data DB;
input ID :$20. Discharge :date9.;
format Discharge date9.;
cards;
0001 19JUN2017
0001 07SEP2020
0002 17MAR2016
0003 05MAY2016
0003 08FEB2017
0004 22MAR2017
0004 03MAY2017
0004 28MAR2021
;
data DB1;
input ID :$20. Discharge :date9. Combined;
format Discharge date9.;
cards;
0001 19JUN2017 0001_19JUN2017_1
0001 07SEP2020 0001_07SEP2020_2
0002 17MAR2016 0002_17MAR2016_1
0003 05MAY2016 0003_05MAY2016_1
0003 08FEB2017 0003_08FEB2017_2
0004 22MAR2017 0004_22MAR2017_1
0004 03MAY2017 0004_03MAY2017_2
0004 28MAR2021 0004_28MAR2021_3
;
Is there a way to combine IDs and dates in a new variable and add an incremental number (after sorting by ID and Discharge) as suffix?
Desired output: DB1
Thank you in advance
... View more
A new update is available for Base SAS , version 9.4_M7 : Hot Fix: K1P011 - Published 02MAY2024 , Download link for K1P011 Component name: Base SAS Related SAS release: 9.4 Issues addressed in K1P011 SAS Note 70726 The SAS/CONNECT® spawner randomly abends S0C4 on z/OS at the maintenance level on SAS® 9.4M7 (TS1M7) This list of notes might be incomplete. For a complete list of issues addressed by this hot fix, visit the hot fix page for K1P011 Note: A comprehensive list of all SAS hot fixes is available from support.sas.com. You can use the SAS Hot Fix Analysis, Download, and Deployment (SASHFADD) tool to manage your SAS hot fixes.
... View more
with the following code, the chart displays a label " p-chart for yes_answer1" at the top, under the main chart title. I have two questions about that: How to remove that, i.e "p-chart for yes_answer1" ? How can I modify the chart so that the main title " P-chart of Patient Counseling by Quarter" appears at the top of the chart instead of "p-chart for yes_answer1" title "P-chart of Patient Counseling by Quarter"; proc shewhart data=tmp2; pchart yes_answer1*quarter/ markers subgroupn = total_count1 nohlabel ; LABEL yes_answer1 ="Proportion of pts counselled"; /*this would be for y axis and no issue with this*/ run; title;
... View more
I need to add a horizontal reference line at 90% to represent my target in the p-chart. When I put href=0.9 in my code I got the following warning "WARNING: Numeric href= values are incompatible with a character subgroup variable; HREF= lines are not displayed." The warning indicates that the href value is not compatible because the subgroup variable, quarter, is treated as a character data type. How to include the target line? Here is my code: proc shewhart data=tmp2; pchart yes_answer1*quarter/ markers subgroupn = total_count1 nohlabel Href=0.9; run;
... View more