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: 
Denali
‎10-16-2024
  • 123 Posts
  • 18 Likes Given
  • 0 Solutions
  • 1 Likes Received

Re: Proc LifeTest X Axis Starting Point

by Quartz | Level 8 in SAS Programming
‎04-02-2020 12:26 PM
‎04-02-2020 12:26 PM
I am attachinig my graph on the post.    I am looking at the page of "Modifying the Axis": https://go.documentation.sas.com/?docsetId=statug&docsetTarget=statug_kaplan_sect016.htm&docsetVersion=14.3&locale=en   %ProvideSurvivalMacros %let yOptions = label="Survival" linearopts=(viewmin=0 viewmax=1; %let xOptions = label="Survival Year" linearopts=(viewmin=5 viewmax=20 tickvaluelist=(5 10 15 20)); %CompileSurvivalTemplates proc lifetest data=two plots=survival(cb=hw test); time Survive_year*death(0); strata AKI; run;   But this is only for changing the ticks, not the X axis starting point. I still don't know how to do it.......  ... View more

Re: Proc LifeTest X Axis Starting Point

by Quartz | Level 8 in SAS Programming
‎04-01-2020 11:57 PM
‎04-01-2020 11:57 PM
For option 1, I substracted 5 for time (year) variable:   data two_a; set two; KM_year = survive_year - 5; run;   How do I format it back to the real number? All the numbers are with many decimal now. Please see below output: KM_year 8.6110 11.1041 10.3452 7.3644 4.7753 11.8055 0.9507 4.5096 1.5123 11.4164 7.2548 11.2082 8.9123 3.6082 11.0055 6.6795 6.5233 2.9863 0.6438 2.7890 7.2740 1.2795 Thank you!   ... View more

Re: Proc LifeTest X Axis Starting Point

by Quartz | Level 8 in SAS Programming
‎04-01-2020 11:38 PM
‎04-01-2020 11:38 PM
Because nobody died at year 0-5 and they started dying from year 5-15. So I am hoping not to show year 0-5 in the graph. ... View more

Re: Proc LifeTest X Axis Starting Point

by Quartz | Level 8 in SAS Programming
‎04-01-2020 11:37 PM
‎04-01-2020 11:37 PM
I need to change the x-axis to start at year 5 instead of starting at 0. ... View more

Proc LifeTest X Axis Starting Point

by Quartz | Level 8 in SAS Programming
‎04-01-2020 11:27 PM
‎04-01-2020 11:27 PM
Hi,   I would like to create a Kaplan-Mier Plot with x-axis starting at Year 5 instead of Year 0 because all my patients have survived at least 5 years. I do not want to present the flat line from Year 0 to Year 5. Below is my code and could anyone please tell me how to make the x-axis starting at 5 instead of 0?  Thank you!   ods graphics on / width = 6 in height = in border = off ; ods graphics on/ imagefmt = tiff imagename = "Figure_AKI_Survivors" reset = index; ods listing image_dpi = 300 style = axis_wall style=StatColor;   proc lifetest data=two plots=survival(test atrisk =5 to 15 by 2.5) /* ods select SurvivalPlot;*/ outsur=survival2; time Survive_year*death(0); label Survive_year='Time (Years)'; strata AKI; ods output SurvivalPlot = graph; run; ods graphics off; ... View more

Re: Remove deuplicates and keep last observation

by Quartz | Level 8 in SAS Programming
‎03-31-2020 09:05 AM
‎03-31-2020 09:05 AM
You guys are genius! Thank you so much! ... View more

Re: Remove deuplicates and keep last observation

by Quartz | Level 8 in SAS Programming
‎03-30-2020 11:30 PM
‎03-30-2020 11:30 PM
I just realized that the Creatinine date variable in Excel file carries an underlying time format:   CREATININE DATE 5/25/14 8:54 5/26/14 8:05 5/27/14 8:08 5/27/14 11:18 5/28/14 8:50 6/5/14 15:23 6/6/14 15:07 6/7/14 8:49 6/8/14 8:39 6/8/14 15:23 6/9/14 8:33 2/22/02 9:35 2/23/02 0:01 2/23/02 7:46 2/24/02 7:30 3/6/02 12:00 3/14/02 9:40 3/15/02 8:15 3/15/02 19:00 3/16/02 8:35 3/16/02 22:30   Thank you. ... View more

Re: Remove deuplicates and keep last observation

by Quartz | Level 8 in SAS Programming
‎03-30-2020 09:05 PM
‎03-30-2020 09:05 PM
Hi,   The clinicians extracted the data from medical records and they wanted us to keep the last creatinine value if there are multiple measurements on the same date. Maybe I should create a "count" variable per patient per date?    ID CREATININE DATE CREATININE VALUE 00011695 2002-01-28 0.8 00011695 2002-01-29 1.1 00011695 2002-01-29 1.5 00011695 2002-01-29 1.7 00011695 2002-01-30 2.3 00011695 2002-01-30 2.5 00011695 2002-01-31 2.5 00011695 2002-02-01 3.5 00011695 2002-02-01 2.9 00011695 2002-02-02 2.1 00011695 2002-02-03 1.4 00011695 2002-02-04 1.3 00011695 2002-02-05 1.4 00011695 2002-02-06 1.2 00011695 2002-02-08 1.2 00011695 2002-02-09 1.2 00011695 2002-02-09 1.2 00011695 2002-02-10 1 00011695 2002-02-11 1.2 00011695 2002-02-12 1.2 00011695 2002-02-13 1.1 00011695 2002-02-14 1.2 00011695 2002-02-15 1.2 00011695 2002-02-18 1.2   Thank you! ... View more

Remove deuplicates and keep last observation

by Quartz | Level 8 in SAS Programming
‎03-30-2020 04:25 PM
‎03-30-2020 04:25 PM
Hi,   I have a dataset with patients who were measured creatinine levels during a period of time. Somehow there were some patients were mistakenly measured more than once per day (e.g. see bolded ones below). I just would like to to keep the last measurement and remove the first measurement (duplicates).   Below is my code, but it did not remove the duplicates. Could anyone please help me? proc sort data= test out=test1 nodupkey ; by ID descending CREATININE_DATE; run; 00004820 2014-05-25 00004820 2014-05-26 00004820 2014-05-27 00004820 2014-05-27 00004820 2014-05-28 00004820 2014-06-05 00004820 2014-06-06 00004820 2014-06-07 00004820 2014-06-08 00004820 2014-06-08 00004820 2014-06-09 00004887 2002-02-22 00004887 2002-02-23 00004887 2002-02-23 00004887 2002-02-24 00004887 2002-03-06 00004887 2002-03-14 00004887 2002-03-15 00004887 2002-03-15 00004887 2002-03-16 00004887 2002-03-16 00004887 2002-03-17 00004887 2002-03-25 00004887 2002-04-06 00004887 2002-04-06 00004887 2002-04-07 00004887 2002-04-08 00004887 2002-04-09 00004887 2002-04-10 00004887 2002-04-11 00004887 2002-04-12 00004887 2002-04-13 00004887 2002-04-14 00004887 2002-04-15 00004887 2002-04-16 00004887 2002-04-16 00004887 2002-04-17 00004887 2002-04-18 00004887 2002-04-19 00004887 2002-04-20 00004887 2002-04-21 00004887 2002-04-22 00004887 2002-04-23 00004887 2002-04-24 00004887 2002-04-25 00004887 2002-04-26 00004887 2002-04-27 00004887 2002-04-28 00004887 2002-04-29 00004887 2002-04-30 00004887 2002-05-01 00004887 2002-05-02 00004887 2002-05-03 00004887 2002-05-03 00004887 2002-05-04 00004887 2002-05-04 00004887 2002-05-05 00004887 2002-05-05 00004887 2002-05-05 00004887 2002-05-06 00004887 2002-05-06 00004887 2002-05-06 00004887 2002-05-07 00004887 2002-05-08 00004887 2002-05-08 00004887 2002-05-09 00004887 2002-05-10 00004887 2002-05-10 00004887 2002-05-11 00004887 2002-05-12 00004887 2002-05-13 00004887 2002-05-14 00004887 2002-05-15 00004887 2002-05-16 00004887 2002-05-17 00004887 2002-05-18 00004887 2002-05-19 00004887 2002-05-20 00004887 2002-05-20 00004887 2002-05-21 00004887 2002-05-22 00004887 2002-05-23 00004887 2002-05-24 00004887 2002-05-25 00004887 2002-05-26 00004887 2002-05-27 00004887 2002-05-28 00004887 2002-05-29 00004887 2002-05-30 00004887 2002-05-31 00004887 2002-06-01 00004887 2002-06-02 00004887 2002-06-03 00004887 2002-06-04 00004887 2002-06-05 00004887 2002-06-06 00004887 2002-06-07 00004887 2002-06-08 00004887 2002-06-09 00004887 2002-06-10 00004887 2002-06-11 00004887 2002-06-25 00004887 2002-06-26 00004887 2002-06-26 00004887 2002-06-26 00004887 2002-06-27 00004887 2002-06-28 00004887 2002-06-28 00004887 2002-06-29 00004887 2002-06-29 00004887 2002-06-30 00004887 2002-06-30 00004887 2002-07-01 00004887 2002-07-02 00004887 2002-07-02 00004887 2002-07-02 00004887 2002-07-02 00004887 2002-07-03 00004887 2002-07-03 00004887 2002-07-03 00004887 2002-07-04 00004887 2002-07-05 00004887 2002-07-06 00004887 2002-07-06 00004887 2002-07-07 00004887 2002-07-07 00004887 2002-07-08 00004887 2002-07-08 00004887 2002-07-08 00004887 2002-07-09 00004887 2002-07-10 00004887 2002-07-10 00004887 2002-07-10 00004887 2002-07-11 00004887 2002-07-12 00004887 2002-07-12 00004887 2002-07-12 00004887 2002-07-13 00004887 2002-07-13 00004887 2002-07-14 00004887 2002-07-14 00004887 2002-07-15 00004887 2002-07-16 00004887 2002-07-16 00004887 2002-07-17 00004887 2002-07-17 00004887 2002-07-17 00004887 2002-07-18 00004887 2002-07-18 00004887 2002-07-19 00004887 2002-07-20 00004887 2002-07-21 00004887 2002-07-21 00004887 2002-07-21 00004887 2002-07-22 00004887 2002-07-22 00004887 2002-07-23 00004887 2002-07-23 00004887 2002-07-23 00004887 2002-07-24 00006949 2004-06-23 00006949 2004-06-24 00006949 2004-06-25 00006949 2004-06-29 00006949 2004-07-01 00006949 2004-07-02 00006949 2004-07-12 00006949 2004-07-13 00006949 2004-07-14 00006949 2004-07-15 00006949 2004-07-26 00006949 2004-07-28 00006949 2004-08-19 00006949 2004-09-13 00006949 2004-10-04 00006949 2004-10-25 00006949 2004-11-15 00006949 2004-12-16 ... View more

Generate 2 phases of randomization TX allocation lists stratified by g...

by Quartz | Level 8 in SAS Programming
‎10-25-2019 12:45 AM
‎10-25-2019 12:45 AM
Hi,   Can you please help me with generating the randomization lists based on the below study design?   Phase 1:  766 subjects randomized into 2 groups (high dose vs. low dose) (n= 383 per group)   Then we randomly select 268 subjects out of the 383 subjects in low dose group and randomly select 268 subjects out of the 383 subjects in high dose group   Phase 2: we randomize the 268 subjects into 2 groups (no intervention vs intervention) (n=134 per group) among low dose groups and randomize the 268 subjects into 2 groups (no intervention vs intervention) (n=134 per group) among high dose groups   The randomization permuted blocks in phase 1 and phase 2 will also need to be stratified by 4 study sites and gender so I will have 8 lists.   Thank you! ... View more

Re: String or Scan Function to solve height format

by Quartz | Level 8 in SAS Programming
‎10-24-2019 12:36 AM
‎10-24-2019 12:36 AM
Thank you so much! ... View more

String or Scan Function to solve height format

by Quartz | Level 8 in SAS Programming
‎10-23-2019 04:35 PM
‎10-23-2019 04:35 PM
Hi,   I imported a dataset from Excel and height variable contains the symbols for feet and inches. Currently SAS read it as Char. Could you please advise me how to clean up this format issue? Or how do use the string or scan function? height 5' 2.795" 5' 1.614" 4' .5" 5' 2.402" 3' 7.78" 3' 3.764" 5' 7" 5' 2.52" 5' 4.5" 5' 4" 5' 6.378" 5' 3" 5' 7.323" 4' .622" 5' 8" 5' 10.25" 5' 5.118" 5' 6.732" 3' 11.441" 4' 9" 4' 11.449" 3' 10" 4' 9.323" 4' 11.5" 4' 5.15" 3' 5.929" 4' 1.409" 5' 3.5" Thank you. ... View more

Rename all 550 variables

by Quartz | Level 8 in New SAS User
‎10-01-2019 04:33 PM
‎10-01-2019 04:33 PM
Hi,   I have a dataset contains 551 variables (ID, var1, var2, var3.....var550). I would like to rename all the var1-var550 with a "_chg" at the end (var1_chg, var2_chg,......var550_chg). What's the best way to rename all 550 variables?   Thank you! ... View more

Re: How do I change the format and designate length for two conditions...

by Quartz | Level 8 in SAS Programming
‎02-22-2019 03:51 PM
‎02-22-2019 03:51 PM
Thank you Patrick.    Now I've got another dataset, and the ID column is character, not numeric. We still want the #1-100 to be length 5 and >=2000 to be length 4, just like below. I do I code it?    ID 00001 00002 00003   00099 00100 2000 2001 2002   2019 2020   Thank you! ... View more

Re: How to calculate difference in days between two dates (given in SA...

by Quartz | Level 8 in SAS Programming
‎02-19-2019 04:01 PM
‎02-19-2019 04:01 PM
Both are numeric. Recall 1 has MMDDYY10. format. Recall has MMYYS7. format. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎10-16-2024 06:29 PM
Likes given to
Likes from
View All
Quick links