About Chaupak

Chaupak · ‎10-04-2022

Hi, I have a variable with a series 1 and 0 in dataset, most of the time they are like "111011011" for 9 observations for example. Most importantly I want to change the first 0 to 1 and keep the second 0. There are more specific rules and I will display it via an example: data have; input ID time var; cards; 1 1 1 1 2 1 1 3 0 1 4 1 1 5 1 1 6 1 1 7 0 1 8 1 2 1 1 2 2 1 2 3 0 2 4 0 2 5 1 2 6 1 2 7 0 2 8 1 ; run; In this example, I have two IDs with different pattern of the variable "var" over time. I wanted to replace the first 0 by 1 only when this 0 is followed by 1 (e.g., var = 0 for ID 1 at time 3). I do not replace 0 for ID 2 at time 3 because it is also 0 for time 4. The 0 at time 7 for ID 2 will also not replaced by 1 although the pattern is like "101", because it is not the first 0 for this ID. The final dataset I want is: data want; input ID time var; cards; 1 1 1 1 2 1 1 3 1 1 4 1 1 5 1 1 6 1 1 7 0 1 8 1 2 1 1 2 2 1 2 3 0 2 4 0 2 5 1 2 6 1 2 7 0 2 8 1 ; run; Is there any way to accomplish that? Thanks!

Chaupak · ‎03-23-2022

Thank you so much!

Chaupak · ‎03-23-2022

Hi, I met a problem when calculating the difference of months between two dates. Here are the sample codes: data test; dt1 = "25Aug2011"d; dt2 = "23Feb2012"d; dt1_dt2 = intck("month",dt1,dt2,"c"); dt2_dt1 = intck("month",dt2,dt1,"c"); format dt1 dt2: yymmdd10.; run; Here I calculated the month difference between date1 2011-08-25 and date2 2012-02-23. When I put date1 before date2 (dt1_dt2) in the INTCK function, it returns 5, because the time interval is slightly <6 months. However, when I put date2 before date1 (dt2_dt1), it returns -6. Shouldn't it be -5, since I just changed the order of two dates? Anyone can help me with it? Thanks!

Chaupak · ‎03-02-2022

Hi, I am using PROC LIFETEST to generate the KM curve and its confidence band. I noticed that there is an option called CONFTYPE= (default is LOGLOG) which can let us choose the type of transformation to calculate the confidence band. I also tried CONFTYPE=LINEAR, and the confidence band is different. To me, the results from LINEAR makes more sense, but I am not sure if I can use it. My question is, is there any rule to choose the type of transformation? Is it related to the sample size?

Chaupak · ‎02-24-2022

I assume that the range of day is all from 6 to 16. You can try this: data have1; set have; by id phase; output; if first.phase and day > 6 then do; day = 6; val = .; output; end; if last.phase and day < 16 then do; day = 16; val = .; output; end; run; proc sort data=have1; by id phase day; run; data want; set have1; by id phase; nextrec = _n_+1; output; if last.phase = 0 then do; set have1(rename=(day=nextday)) point=nextrec; do day = day + 2 to nextday - 2 by 2; val = .; output; end; end; drop nextday; run;

Chaupak · ‎02-24-2022

I tried this way and it helps! I added the legend title using sganno manually, and adjusted the legend position using OUTERPAD= in KEYLEGEND. Thank you!

Chaupak · ‎02-24-2022

I tried using '09'x, but it still didn't work. This link says that the tab character will be converted as blanks when the codes are submitted, when using the enhance editor (if I didn't misunderstand). I think add a legend title manually using annotation may help, like what Jay recommended. Thank you!

Chaupak · ‎02-23-2022

Hi Reeza, thanks for your suggestion, but it seems like the space was trimmed when I tried.

Chaupak · ‎02-23-2022

Hi all, I am wondering if there's any way to make the legend title and labels left justified in PROC SGPLOT, because I have a long legend title. Here is the example of my current situation: I generated this legend using KEYLEGEND statement and put it on the upper left corner. As is shown above, I want to move "<= 5 mg/kg/day" and "> 5 mg/kg/day" to the left, which is to left justify with the legend title "xxxxxxx". Is there any way to do that?

Chaupak · ‎02-23-2022

Thanks!

Chaupak · ‎02-23-2022

Thanks so much Dan, that's a very detail answer! I fixed this problem using the annotation now.

Chaupak · ‎02-23-2022

Hi, I am trying to add an xaxistable under the x axis in proc sgplot. It worked well at first: Then I wanted to move the ticks on the x axis to the left to make point 0 at the left bottom corner (the origin) using the 'offsetmin = 0' option in xaxis statement. After doing this, the value (4179) for x=0 was truncated to 79: The value remained truncated even after I removed the label of the table: Is there any way to let the value for 0 display normally when I use offsetmin = 0 for x axis? Doesn't have to use xaxistable statement.

Chaupak · ‎01-27-2022

Thank you so much! It's perfect.

Chaupak · ‎01-27-2022

Hi, I was trying to draw a series plot by group and display the every group's name in the legend. One of the groups represents a range "<= xx mg". However, I want its label to be displayed as the sepcial character of less than or equal to sign instead of the combination of "<" and "=" in the plot. This is the sample data and code: DATA plot; INPUT year value group$; CARDS; 1 10 <=50 2 15 <=50 3 20 <=50 4 25 <=50 5 30 <=50 1 10 >50 2 30 >50 3 50 >50 4 70 >50 5 90 >50 ; proc sgplot data=plot; series x=year y=value / group=group; run; I've tried to replace with "(*ESC*){unicode '2264'x} 50" in the dataset, but it didn't work in PROC SGPLOT. Is there any way to display the right special character in the plot?

Chaupak · ‎12-01-2021

Thanks. I checked the official guide and I need to specify the value of female and black in the covariate dataset. In the stratified analysis, it seems like I do need an interaction term.

Online Status	Offline
Date Last Visited	‎11-17-2022 07:52 PM

Replace values in an observation in data manipulation

Re: Different results for the same two dates in INTCK function

Different results for the same two dates in INTCK function

CONFTYPE = LOGLOG or LINEAR in PROC LIFETEST?

Re: Add column that repeatedly numbers 6 through 12 by 2 for each phas...

Re: Left justified legend title and labels in PROC SGPLOT

Re: Left justified legend title and labels in PROC SGPLOT

Re: Left justified legend title and labels in PROC SGPLOT

Left justified legend title and labels in PROC SGPLOT

Re: Truncated Xaxistable value in PROC SGPLOT

Re: Calculation of estimates using contrast statement, and the estimat...

Re: How to remove log numbers?

Re: Multiple variables in a comparison operator

Re: Add column that repeatedly numbers 6 through 12 by 2 for each phas...

Re: Left justified legend title and labels in PROC SGPLOT

Re: Identify a specific date range among multiple observations of date

Replace values in an observation in data manipulation

Re: Different results for the same two dates in INTCK function

Different results for the same two dates in INTCK function

CONFTYPE = LOGLOG or LINEAR in PROC LIFETEST?

Re: Add column that repeatedly numbers 6 through 12 by 2 for each phas...

Re: Left justified legend title and labels in PROC SGPLOT

Re: Left justified legend title and labels in PROC SGPLOT

Re: Left justified legend title and labels in PROC SGPLOT

Left justified legend title and labels in PROC SGPLOT

Re: Truncated Xaxistable value in PROC SGPLOT

Re: Truncated Xaxistable value in PROC SGPLOT

Truncated Xaxistable value in PROC SGPLOT

Re: Less then or equal sign in PROC SGPLOT

Less then or equal sign in PROC SGPLOT

Re: Standardized survival curve in PROC PHREG