cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
RafiRahi
‎12-03-2020
  • 8 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received
About
Phase III diabetes, respiratory and oncology trials. Post-marketing data analysis for various bio-technology firms.

Re: PROC SGPLOT - How to keep the order of events in stack bar as they...

by Fluorite | Level 6 in Graphics Programming
‎08-29-2020 01:08 PM
‎08-29-2020 01:08 PM
Dear Rick, I cannot thank you enough for this solution, it straightway did the job for me! Considering the time line pressure I was in, you just made my day. Thank you so much! ... View more

Re: PROC SGPLOT - How to keep the order of events in stack bar as they...

by Fluorite | Level 6 in Graphics Programming
‎08-29-2020 01:05 PM
‎08-29-2020 01:05 PM
Thank you very much draycut for looking into my question. I am very happy to tell you that the problem is solved now after applying Rick's suggestion. My data structure was exactly the same as Rick provided (obviously different variable names). ... View more

PROC SGPLOT - How to keep the order of events in stack bar as they are...

by Fluorite | Level 6 in Graphics Programming
‎08-29-2020 12:22 AM
‎08-29-2020 12:22 AM
Dear All,   I am reaching out to you to find guidance with the following plot. I want to produce a plot that should look like this -     The white box in the bar means the period when patient did not take any treatment. Interesting thing about each bar is that you will find the therapies in chronological order as the patient took in the past. For example – patient 1005 took Platinum containing therapies for about 180 days, then was off treatment, then took Docetaxel, then off treatment again, then briefly took Other chemotherapy followed by another break, then ICI therapy and then another gap.   I have used the following SGPLOT and the generated plot is given below.   PROC SGPLOT DATA=final;   VBAR subjid / RESPONSE=theradur GROUP=theracat  GROUPORDER=data;   XAXIS DISCRETEORDER=DATA LABEL = "Subject";;   YAXIS VALUES = (0 TO 2000 BY 100) LABEL= "Treatment duration, Weeks"; RUN;   Problem is in my plot is not maintaining the sequence of therapies taken in different period and its putting duplicate categories into one category. For example – all the gap period for a patient are put together under gap box, rather than displaying them separately in the bar as they happened in different time period.   Can anyone please advise me how I can get the desired output, especially if the patient has multiple off treatment periods (gaps) between active treatment periods, how I can display these off treatment periods as the order as they happened in the bar. Similarly if the patent took multiple ICI therapies in different period, I would like to display these different ICI therapies as different box in the bar and their order should be as they happened in the past.   Many thanks for looking into this and I look forward to your kind guidance.  ... View more

Re: Wild character question

by Fluorite | Level 6 in SAS Procedures
‎06-25-2014 11:21 AM
‎06-25-2014 11:21 AM
Duh! Now I am not sure how to resolve it! ... View more

Re: Wild character question

by Fluorite | Level 6 in SAS Procedures
‎06-25-2014 10:54 AM
‎06-25-2014 10:54 AM
Could you please try this - WHERE PUT( APP_ID, 8.) CONTAINS  '61738495' ; ... View more

Re: Wild character question

by Fluorite | Level 6 in SAS Procedures
‎06-25-2014 10:01 AM
‎06-25-2014 10:01 AM
The variable APP_ID - is it character variable? If it is then the below code is working in my 9.2 version of base SAS to find any number which has the value '61738495' in the string - WHERE APP_ID CONTAINS '61738495' ; If it the above code does not work then please let me know if the variable APP_ID is numeric. Thanks. Rafi ... View more

Re: Data set manipulations

by Fluorite | Level 6 in ODS and Base Reporting
‎05-16-2014 05:37 AM
‎05-16-2014 05:37 AM
Hi rossu12, I have put some code below which should answer your query. If anything is not clear let me know. All the best. Rafi * Example dataset based on the information you gave; DATA original;   DO base= 1 TO 10;     OUTPUT;   END; RUN; * Create new variable 'new' based on variable 'base', _N_ is the automatic macro variable which hold the value of observation number that is being processed from   input dataset (original), It can be used to count observation number as well; DATA newds;   SET original;   new = (base*(_N_+1)) *  (base*(_N_)); RUN; ... View more

Re: How to Match Observations from one Variable to another Variable?

by Fluorite | Level 6 in SAS Procedures
‎05-15-2014 11:34 AM
‎05-15-2014 11:34 AM
Hi brettmullga, Please find below the solution using datastep and sql. I have created a dataset based on the information you gave and tried to get the result in the final dataset. If you have more months column then the coding would need to be updated. Please let me know if you have any questions. All the best. Thanks. Rafi DATA original; INPUT Participant Month1 Month2 Month3 Month4; CARDS; 1 8 1 . 9 2 . . 3 15 3 4 5 . 12 4 1 . . 10 ; RUN; * Count total for each month; PROC SQL;   CREATE TABLE m_tot AS   SELECT *, COUNT (*) as total, COUNT(month1) AS m1_tot, COUNT(month2) AS m2_tot, COUNT(month3) AS m3_tot, COUNT(month4) AS m4_tot   FROM original   ORDER BY participant; QUIT; * Using datasetp - 1) flag patient movement in each month and 2) flag patient who has value in previous month(s); DATA flag;   SET m_tot;   IF month1 NE . AND month2 NE . THEN m1tom2f = 1;   IF month2 NE . AND month3 NE . THEN m2tom3f = 1;   IF month3 NE . AND month4 NE . THEN m3tom4f = 1;      IF month2 NE . AND month1 NE . THEN m2tom1f = 1;   IF month3 NE . AND N(month1,month2)  GE 1 THEN m3tom1f = 1;   IF month4 NE . AND N(month1,month2,month3) GE 1 THEN m4tom1f = 1; RUN; * Using proc sql - count necessary values; PROC SQL;   CREATE TABLE finalx AS   SELECT *, COUNT(m1tom2f) AS m1tom2, COUNT(m2tom3f) AS m2tom3, COUNT(m3tom4f) AS m3tom4, COUNT(m2tom1f) AS m2tom1, COUNT(m3tom1f) AS m3tom1, COUNT(m4tom1f) AS m4tom1   FROM flag   ORDER BY participant; QUIT; * Final dataset where all the necessary information for outputs will be found; DATA final;   SET finalx (DROP=participant month1 month2 month3 month4  m1tom2f m2tom3f m3tom4f m2tom1f m3tom1f m4tom1f) END=eof ;   IF eof;   LABEL total = 'Toatl participant'         m1_tot = 'Total participant in Month 1'         m2_tot = 'Total participant in Month 2'         m3_tot = 'Total participant in Month 3'         m4_tot = 'Total participant in Month 4'         m1tom2 = 'Participated in Month 1 and Month 2'         m2tom3 = 'Participated in Month 2 and Month 3'         m3tom4 = 'Participated in Month 3 and Month 4'         m2tom1 = 'Participated in Month 2 and in earlier month(s)'         m3tom1 = 'Participated in Month 3 and in earlier month(s)'         m4tom1 = 'Participated in Month 4 and in earlier month(s)'         ; RUN; ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎12-03-2020 08:08 AM
Group Hubs for RafiRahi
View All
Likes given to
View All
Quick links