About Gregorytus07

Gregorytus07 · ‎03-13-2024

@ballardw Yes, each study_id has only one row of data. For example: study ID 1 had glucose value resolved on 2/28/17 at 7 pm, while its AGAP and Bcarb resolved on 2/27/17 at 7 pm. Therefore, the overall resolution time would be 2/28/17 at 7 pm. Because the overall resolution time is determined by the earliest point when glucose and any two other values have resolved.

Gregorytus07 · ‎03-13-2024

@ballardw Thanks for your feedback. The dataset only contains the first recorded value and the corresponding date and time when each of the lab tests met the criteria for resolution. This is a screenshot of the sample dataset for additional context. Thanks for your help.

Gregorytus07 · ‎03-12-2024

Hi everyone, I have a dataset containing four datetime variables (RGL_time, RPH_time, RAGAP_time, and RBCARB_time), each indicating when corresponding values (glucose, pH, AGAP, and Bcarb) were resolved. The overall resolution time is determined by the earliest point when glucose and any two other values have been resolved. For instance, if glucose was resolved at 10 am, pH at 2 pm, AGAP at 4 pm, and BCARB at 6 pm on the same day, the overall resolution time would be 4 pm. This is because 4 pm is the earliest time when glucose and any two additional values have been resolved. However, if pH resolved at 2 pm, AGAP at 4 pm, BCARB at 6 pm, and glucose at 8 pm on the same day, the overall resolution time would be 8 pm. This is because glucose must always be included in the values that have resolved. I have attached a sample dataset for additional insight into the dataset. Thanks for your help.

Gregorytus07 · ‎03-01-2024

@Reeza Thanks for sharing this. I will try it out.

Gregorytus07 · ‎03-01-2024

@PaigeMiller Thanks for your feedback. This is a sample data DATA YOUR_DATASET; INPUT STUDYID GLUCOSE$; DATALINES; 1 100 1 120 1 See Text 2 85 2 95 3 See Text 3 110 4 See Text 4 80 4 90 ; RUN; The desired output should be similar to this; Study_id Glucose 1 100 2 85 3 110 4 80

Gregorytus07 · ‎03-01-2024

Hi everyone, I have a dataset that contains multiple result rows for each study ID. I need help in writing a SAS code that selects the first result for each study ID. If the first result is 'See Text', then select the next result value for that study ID. Thanks for your help.

Gregorytus07 · ‎01-25-2024

@MelissaM I appreciate your feedback. Your observation regarding the relevance of the assumptions in the article to our context is valid. While the article does propose a method to account for an unmeasured continuous variable, the procedure appears intricate and necessitates specifying more conditions than we are able to handle.

Gregorytus07 · ‎01-23-2024

@ballardw Thanks for your feedback. The variable is not measured in our dataset at all. However, I read about methods of using sensitivity analysis for unmeasured confounding by Lui et al (https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3800481/). Also, I learned from literature that the method proposed by VanderWeele (https://journals.lww.com/epidem/fulltext/2016/05000/sensitivity_analysis_without_assumptions.11.aspx) using the E-value is widely recommended. Just trying to figure out how to actually do the analysis in SAS. Thanks for your help.

Gregorytus07 · ‎01-22-2024

Hi there, I am trying to conduct a sensitivity analysis to assess the impact of an unmeasured confounder on the relationship between exposure (E) and outcome (Y). To estimate this effect, I utilized the proc genmod procedure in SAS, adjusting for covariates such as age, sex, and comorbidities. However, a recognized confounder, namely fluid volume (a continuous variable), has not been measured. I am seeking assistance with SAS code specifically tailored for performing the sensitivity analysis. The fluid volume can vary from 0 to 2000, with an average of 500. The outcome variable is binary - 0 or 1. I appreciate any assistance in this matter.

Gregorytus07 · ‎10-10-2023

Thanks, Koen! I found it. https://documentation.sas.com/doc/en/statcdc/14.2/statug/statug_mianalyze_examples11.htm

Gregorytus07 · ‎10-10-2023

Thanks, Koen! This is really helpful. Do you know how I can assess the earlier example referenced in the first statement "The example titled "Combining Correlation Coefficients" in the PROC MIANALYZE documentation illustrates how to combine sample coefficients for the correlation between two variables computed from a set of imputed data sets by using Fisher's z transformation." I think the referenced exampled would be an additional guide considering that I am trying to compute the correlation coefficient between two variables.

Gregorytus07 · ‎10-10-2023

Hi everyone, I used the PROC MI statement to perform multiple imputation for a dataset with missing data. The second step is to use PROC CORR to conduct the correlation analysis and generate an output dataset to be used with PROC MIANALYZE. I was able to generate the correlation analysis by the imputation number but couldn't get a pooled result using the PROC MIANALYZE. This is the code I used below: PROC CORR DATA=PREP_MI_TTT COV OUTP=PREP_H1; VAR STIGMA_P NORMS_T; BY _IMPUTATION_; RUN; PROC MIANALYZE DATA=PREP_H1 EDF=30; MODELEFFECTS STIGMA_P NORMS_T; RUN;

Gregorytus07 · ‎07-17-2022

@Tom Thanks a lot, it worked!

Gregorytus07 · ‎07-17-2022

@Tom Thanks for your help! The variables are ICD-10-CM codes. Some IDs have above 100 unique ICD-10 codes. I sorted the dataset as advised and ran the code. However, I got this in the log output I am not sure of how to fix this. Thanks in advance. Best regards, Festus.

Gregorytus07 · ‎07-16-2022

Hi everyone, I am trying to proc transpose two variables at the same time using the SAS code below: proc sql noprint; select max(obs) into :obs from(select count(*) as obs from ccv_dc1 group by study_id); quit; proc summary data=ccv_dc1 nway; class study_id; output out=ccv_dc2(drop=_:) idgroup(out[&obs] (VERT_DXCCSR_label_DC VERT_cate_prefix_label_DC)=); run; However, there is an error message in the log that states: The parameter value 116 is not within the required range of 1 and 100. I read online that the max number of observations for each ID cannot exceed 100 when using my code above. I need help with a code that can accommodate more than 100 observations for each ID. Best regards, Festus.

Online Status	Offline
Date Last Visited	‎03-15-2024 03:56 PM

Re: Datetime Variable Creation

Re: Datetime Variable Creation

Datetime Variable Creation

Re: Variable Selection

Re: Variable Selection

Variable Selection

Re: Sensitivity Analysis for Unmeasured Confounder

Re: Sensitivity Analysis for Unmeasured Confounder

Sensitivity Analysis for Unmeasured Confounder

Re: How do I perform correlation analysis with multiple imputed datase...

Re: Variable Selection

Re: ERROR MESSAGE: PROC TRANSPOSE TWO VARIABLES AT THE SAME TIME

Re: ERROR MESSAGE: PROC TRANSPOSE TWO VARIABLES AT THE SAME TIME

Re: Datetime Variable Creation

Re: Datetime Variable Creation

Datetime Variable Creation

Re: Variable Selection

Re: Variable Selection

Variable Selection

Re: Sensitivity Analysis for Unmeasured Confounder

Re: Sensitivity Analysis for Unmeasured Confounder

Sensitivity Analysis for Unmeasured Confounder

Re: How do I perform correlation analysis with multiple imputed datase...

Re: How do I perform correlation analysis with multiple imputed datase...

How do I perform correlation analysis with multiple imputed dataset?

Re: ERROR MESSAGE: PROC TRANSPOSE TWO VARIABLES AT THE SAME TIME

Re: ERROR MESSAGE: PROC TRANSPOSE TWO VARIABLES AT THE SAME TIME

ERROR MESSAGE: PROC TRANSPOSE TWO VARIABLES AT THE SAME TIME