About dac_js

dac_js · ‎12-11-2022

I was looking for a way to get the legend as a scale instead of separate data points. I should have clarified that. Thank you for the help!

dac_js · ‎12-04-2022

Thank you very much for your help! Is it possible to get the legend in a format like the attached map?

dac_js · ‎12-04-2022

I am using PROC GMAP for the first time. I need help with changing the way the legends (the 3 levels in the example) are shown in the map. For example when I am creating a sample US state map in the following way SAS is using three separate levels of colors. Changing the LEVELS = option I can get more levels but the same issue exists. Is there any way to show the density_2020 by different state as a range of 0 to 10,000. (The map should not change only I am trying to show the legends in a different way) proc gmap data=sashelp.us_data map=mapssas.us; id state; choro density_2010 / levels=3 legend=legend1; run; quit;

dac_js · ‎07-09-2022

I have data in following format: data have; input TIME BIOMARKER; datalines; 1 85.5 2 80.4 5 67.3 8 34.2 ; run; I am trying to predict a time point at which the biomarker level will be below 1. Is there any way to directly conduct a survival analysis with data in this format? I was considering to create individual level observations from this first before conducting survival analysis. The decimal points I have is making this difficult.

dac_js · ‎06-25-2022

I have data in following format: data have; input id var1 var2; datalines; 1 0 0 1 1 0 1 1 0 1 0 0 2 1 1 2 1 0 2 0 0 2 1 1 2 1 0 ; run; Trying to create cumulative value for different variables (var1 and var2 here) based on IDs. I am expecting something like this: Obs id var1 var2 1 1 0 0 2 1 1 0 3 1 2 0 4 1 2 0 5 2 1 1 6 2 2 1 7 2 2 1 8 2 3 2 9 2 4 2

dac_js · ‎06-17-2022

Thank you!

dac_js · ‎06-16-2022

This is the table I am trying to create: Obs id service_start_dt service_end_dt drug duration start_date end_date 1 1 09/23/2013 09/23/2016 0 436 09/23/2013 12/02/2014 2 1 09/23/2013 09/23/2016 1 2 12/03/2014 12/04/2014 3 1 09/23/2013 09/23/2016 0 166 12/05/2014 05/19/2015 4 1 09/23/2013 09/23/2016 1 2 05/20/2015 05/21/2015 5 1 09/23/2013 09/23/2016 0 487 05/22/2015 09/23/2016 6 2 01/20/2012 09/23/2016 0 106 01/20/2012 05/04/2012 7 2 01/20/2012 09/23/2016 1 31 05/05/2012 06/04/2012 8 2 01/20/2012 09/23/2016 0 55 06/05/2012 07/29/2012 9 2 01/20/2012 09/23/2016 1 31 07/30/2012 08/29/2012 10 2 01/20/2012 09/23/2016 0 1487 08/30/2012 09/23/2016

dac_js · ‎06-16-2022

Thank you for the help! I have one more question. With the same data if I want to create one more row for all individuals showing the time between last day patient have drug (drug_end_dt) to the last day patient was observed (service_end_dt), should I follow the same steps? It would be very helpful if you can show where in the code I need to make this change? The same data with one more variable is below: data have; input id service_start_dt :mmddyy10. service_end_dt :mmddyy10. drug_start_dt :mmddyy10. drug_end_dt :mmddyy10. drug; format service_start_dt service_end_dt mmddyy10. drug_start_dt mmddyy10. drug_end_dt mmddyy10. ; cards; 1 09/23/2013 09/23/2016 12/03/2014 12/04/2014 1 1 09/23/2013 09/23/2016 05/20/2015 05/21/2015 1 2 01/20/2012 09/23/2016 05/05/2012 06/04/2012 1 2 01/20/2012 09/23/2016 07/30/2012 08/29/2012 1 ; run; And I am trying to create a table like below. [Here patient receive service between the service_start_dt and service_end_dt . Within this period there are times when patient can or cannot take the drug. between drug_start_dt and drug_end_dt is thh time when patients are taking the drugs] Obs id service_start_dt service_end_dt drug duration drug_start_dt drug_end_dt 1 1 09/23/2013 09/23/2016 0 436 09/23/2013 12/02/2014 2 1 09/23/2013 09/23/2016 1 2 12/03/2014 12/04/2014 3 1 09/23/2013 09/23/2016 0 166 12/05/2014 05/19/2015 4 1 09/23/2013 09/23/2016 1 2 05/20/2015 05/21/2015 5 2 01/20/2012 09/23/2016 0 106 01/20/2012 05/04/2012 6 2 01/20/2012 09/23/2016 1 31 05/05/2012 06/04/2012 7 2 01/20/2012 09/23/2016 0 55 06/05/2012 07/29/2012 8 2 01/20/2012 09/23/2016 1 31 07/30/2012 08/29/2012

dac_js · ‎06-16-2022

Thank you for noticing the issue with my example data.

dac_js · ‎06-14-2022

I have data in the following format: data have; input id service_dt :mmddyy10. start_dt :mmddyy10. end_dt :mmddyy10. drug; format service_dt mmddyy10. start_dt mmddyy10. end_dt mmddyy10. ; cards; 1 09/23/2013 12/03/2014 12/04/2014 1 1 09/23/2013 05/20/2014 05/21/2014 1 2 01/20/2012 05/05/2011 06/04/2011 1 2 01/20/2012 07/30/2011 08/29/2011 1 ; run; Here start date and end date are the dates between which patients are taking drugs (drug = 1). Need to create observations when patients are not taking drugs (drug = 0). The date count should start from the service day. Is there any way to arrange the data in the following format: Observations ID Service date Start date End Date Drug Duration 1 1 9/23/2013 9/23/2013 12/3/2014 0 436 2 1 9/23/2013 12/3/2014 12/4/2014 1 1 3 1 9/23/2013 12/4/2014 5/20/2015 0 167 4 1 9/23/2013 5/20/2015 5/21/2015 1 1 5 2 1/20/2012 1/20/2012 5/5/2012 0 106 6 2 1/20/2012 5/5/2012 6/4/2012 1 30 7 2 1/20/2012 6/4/2012 7/30/2012 0 56 8 2 1/20/2012 7/30/2012 8/29/2012 1 30 Thanks in advance!

dac_js · ‎05-11-2022

I have the following data: data have; input ID Dose Days Event Age; datalines; 1 1 10 1 35 2 1 40 0 35 2 2 55 0 25 2 3 23 1 67 3 1 20 0 34 3 2 35 0 34 3 3 15 1 25 4 1 40 0 53 4 2 55 1 53 ; run; Here, dose variable changes with time. Days is the duration an individual stays alive (or die at the end of period) at a certain dose level. If the individual does not die, the dose is increased (1 to 2 or 2 to 3). Event variable shows when an event (death = 1) occurred. This can be at the end of any dosing period. Is there any way to run a cox model where dose is the exposure of interest and age is a covariate?

dac_js · ‎01-22-2022

Thank you! It creates exactly what I was looking for.

dac_js · ‎01-22-2022

Thank you!

dac_js · ‎01-21-2022

I have two different datasets and want to create a plot with two line graph. The X and Y axis in these two datasets are different. Is it possible to add two X and two Y axis simultaneously in one graph. I found its possible to add two Y axis in PROC SGPLOT. Is there any way to do the same for two X axis using SGPLOT or other SAS procedures? data have; input x1 y1; datalines; 1 45 2 53 3 66 4 77 5 58 6 48 ; data have2; input x2 y2; datalines; 1 15 2 16 3 27 4 30 5 35 6 45 7 40 8 37 9 44 10 45 11 56 12 45 13 95 ; proc sgplot data=have; series x=x1 y=y1; run; proc sgplot data=have2; series x=x2 y=y2; run;

dac_js · ‎01-18-2022

Thank you very much!

Online Status	Offline
Date Last Visited	‎12-10-2023 10:34 PM

PROC PHREG with IPTW weighted cohort: robust standard error

Re: Delete pair of observations for negative claims

Re: Delete pair of observations for negative claims

Re: Delete pair of observations for negative claims

Delete pair of observations for negative claims

Re: PROC PSMATCH for three or more groups

PROC PSMATCH for three or more groups

Re: Renaming multiple variable names

Re: Renaming multiple variable names

Re: Renaming multiple variable names

Re: Renaming multiple variable names

Re: Partial match merging

Re: Cumulative sum

Re: Cumulative sum

Re: How to create binary variables from multiple observations?

Re: Cross tabulation of variables using (multiple variables as row)

Re: PROC GMAP color change by level

Re: PROC GMAP color change by level

PROC GMAP color change by level

Survival analysis

Cumulative sum

Re: Creating observation for days without drugs

Re: Creating observation for days without drugs

Re: Creating observation for days without drugs

Re: Creating observation for days without drugs

Creating observation for days without drugs

Cox regression using time varying covariates

Re: PROC SGPLOT with two x axis

Re: PROC SGPLOT with two x axis

PROC SGPLOT with two x axis

Re: How to create binary variables from multiple observations?