Hi Folks:   I'm trying to determine how many observations there are within each percentiles. The image below shows my current proc means output and the output that I want that includes the number of observations within each quantiles. Is there a way to accomplish Results Wanted?      PROC MEANS DATA=sashelp.stocks Q1 MEDIAN Q3 MAX MAXDEC=1; CLASS STOCK; VAR OPEN; RUN; Thank you for your time indeed!   Best wishes, Cruise ... View more

Hi folks:   I'm trying to select the row with the min(diff) and if rows ties on diff like it occurs for the ID=3 patient then select the first row. How to achieve it? my code below doesn't help when rows tied on the 'diff'.   Thanks in advance   data temp; input id diff; cards; 1 2 1 3 2 1 2 2 3 2 3 2 ; proc sql; select * from temp group by CTC_id having DIFF eq min(DIFF) ; quit; ... View more

Hi folks:   I'd like to know how many patients were contacted more than one time. In the mock data, there are two patients and the first patient has two different dates (1 and 2) compared to the second patient who has the same date_contact for both rows. The correct answer to this is 1. Only one patient had two different dates which is indicating that he/she was contacted for two times. However, my proc sql in the code shown outputs 2 which is wrong.   Can you please help me correct my code or suggest a better approach to solve this problem?   Thanks in advance.   data temp; input ctc_id date_contact; cards; 1 1 1 2 2 1 2 1 ; PROC SORT DATA=TEMP; BY CTC_ID; DATA TEMP1; SET TEMP; by CTC_ID; if first.CTC_ID then ID + 1; RUN; PROC SORT DATA=TEMP1; BY CTC_ID DATE_CONTACT; DATA TEMP2; SET TEMP1; by CTC_ID DATE_CONTACT; if first.DATE_CONTACT then ID1 + 1; RUN; DATA TEMP3; SET TEMP2; IF ID NE ID1; RUN; PROC SQL; SELECT COUNT(DISTINCT CTC_ID) FROM TEMP3; quit;   ... View more

Hi folks:   I'm trying to show the proportion of patients with missing stage by other covariates, for example, by age group in the image shown below. My output is changed from WANTED to WRONG which you can see in the image below that the numbers for Breast cancer are changed before vs after adding the ' CANCER_SITE ' category into the proc tabulate to produce the statistics for four different cancer sites.  How to add CANCER_SITE correctly in the proc tabulate code without changing the statistics that I'm showing in the WANTED part?   Please see my code snippet and mock data if needed.     PROC TABULATE DATA=BREAST_TABLE; class MISS1 AGEGRP SEX RACETH STAGE1 SURGERY MEDICAID type_of_reporting_source marital_status_at_dx CANCER_SITE/ASCENDING; table ALL (AGEGRP SEX RACETH marital_status_at_dx SURGERY STAGE1 MEDICAID type_of_reporting_source),CANCER_SITE=''*MISS1=''*ROWpctn ALL; RUN;DATA HAVE; INPUT GENDER MISS_STATUS; /*IF MOCK DATA NEEDED*/ DATA HAVE; INPUT AGEGRP MISS_STATUS CANCER_SITE; DATALINES; 1 1 1 1 1 1 1 1 1 1 0 1 1 0 1 1 0 1 1 0 1 1 0 1 0 1 1 0 1 1 0 1 1 0 0 1 0 0 1 0 0 1 0 0 1 1 1 2 1 1 2 1 1 2 1 1 2 1 1 2 1 0 2 1 0 2 1 0 2 0 1 2 0 1 2 0 1 2 0 1 2 0 1 2 0 0 2 0 0 2 ; I greatly appreciate your time! ... View more

Hi folks:   I have a couple of questions on the same plot if you don't mind.   1. How to assign colours to the paired bars by group variable (localized, regional and distant) but not within (blue vs red) as of now. It's confusing that two bars both belong to 'localized' takes two different colours: blue vs red. Instead, I'd like to, for example, assign green to both "localized" pair-bars but two varying in tone. Assign blue but two different blues for the 'regional' so forth so on.    2. How to widen the space between the pair-bars. I'd like to have more space between clusters while pair-bars stick together with no space between as it is now.     Thanks for your time indeed.   DATA PLOT1; INPUT METHOD AGEGRP STAGE1 SURV; DATALINES; 1 1 2 99 1 1 3 100 1 1 4 89 1 2 2 96 1 2 3 96 1 2 4 81 1 3 2 94 1 3 3 93 1 3 4 78 1 4 2 89 1 4 3 89 1 4 4 77 2 1 2 95 2 1 3 92 2 1 4 65 2 2 2 87 2 2 3 85 2 2 4 60 2 3 2 80 2 3 3 79 2 3 4 54 2 4 2 63 2 4 3 67 2 4 4 41 ; PROC FORMAT; VALUE STAGE 2='Localized' 3='Regional' 4='Distant' ; VALUE AGEGRP 1='00-44yr old' 2='45-59yr old' 3='60-74yr old' 4='75+yr old' ; RUN; ods graphics ON; ods graphics/width=6in height=4in; proc sgpanel data=plot1; panelby agegrp /novarname colheaderpos=bottom COLUMNS=4 onepanel; styleattrs DATACONTRASTCOLORS=(BLUE green red); vbar stage1 / response=surv stat=sum group=method nostatlabel groupdisplay=cluster; keylegend "Empirical" "Midpoint" / across=1 position=Top; format agegrp agegrp. stage1 stage.; run; ... View more

Hello folks:   Is there any way to force y-axis to show 1.00? See the plot below, that 1.00 is not included. The max values that I have to present on the y-axis are 1.55 or 1.54 and 0.93 or 0.94 for minimum values.   I tried myriad different combinations of (min to max by 0.0n) in my code below with no success. Attached is the underlying data=(have).   Thanks for your time. I greatly appreciate your help. ods graphics ON; OPTIONS NOTES; ods graphics/width=12in height=4.5in; proc sgpanel data=HAVE noautolegend; panelby agegrp/ novarname columns=4 rows=1; styleattrs DATACONTRASTCOLORS=(BLUE green red); series x=PCT_MISS y=HazardRatio_Mean/GROUP=STAGE lineattrs=(pattern=solid); series x=PCT_MISS y=ONE/group=stage lineattrs=(pattern=dash) lineattrs=(thickness=4); REFLINE 1 / LABEL = ('HR=1') lineattrs=(color=BLACK pattern=dash thickness=1.5) LABELPOS=MIN; colaxis min=1 max=100 grid values=(0 to 100 by 5) LABELATTRS=(Family=Arial Size=11); rowaxis grid values=(0.93 to 1.54 by 0.01) LABELATTRS=(Family=Arial Size=11); run; ... View more

Hi Folks:   In PROC PHREG below where METHOD is binary variable (1,0) does SAS take 1 over 0 or 0 over 1 to calculate the hazard ratio reported in the annotated output shown below?    PROC PHREG DATA=MYDATA; MODEL DURATION*DEATH(0)=METHOD; RUN; ... View more