Hi everyone,    I am struggling with merging two datasets by date. I have the following datasets:    Dataset DEMO: PT_ID Visit_Date    Dataset Diss: PT_ID Diagnosis_date ICD-Code      DATA DEMOA; MERGE DEMO (in=a) Diss (in=b); BY PT_ID; if a and b; run;   The resulting dataset looks like this:   PT_ID Visit_Date     Diagnosis_date   ICD-Code 1        31OCT2016    30OCT2016        599 1        31OCT2016    31OCT2016        599 2        29NOV2012   29NOV2012        466 3        07SEP2014    24JUN2013        486     I have two problems here:  1) The date in both files are not matched SOMETIMES, Is there any way that I can round the date if the (Diagnosis date) one or two days after the (ER Visit)??    2) How can I merge the two files without repeating the observations more than once if the patient has matched date?    Thanks,        ... View more

Hi Everyone,    I am working on a medical records data and I'm getting three separate files (Demographic file, Medication file, Diagnosis file). In each file, there is a specific date for a specific procedure. For instance, in the demographic file has a date for the time the patient visits the Emergency room, and in the diagnosis file there are dates for each diagnosis, and finally, the medication file has dates for each medication.    I want to merge all the three file in ONE dataset based on the date in the demographic file. So, I want to see if there is MATCHED date between the three files and merge them based on that. Is it possible? I have a full format date like this (28MAY2016).    Thanks,  ... View more

Hi,    I'm trying to run a proc SURVEYlogistic for a complex data, but the output looks weird. anyone has an idea what do those numbers mean? Especially the one highlighted with red.    The SURVEYLOGISTIC Procedure Model Information Data Set WORK.N15   Response Variable Antibiotic   Number of Response Levels 2   Stratum Variable VARSTR VARIANCE ESTIMATION STRATUM - 2015 Number of Strata 165   Cluster Variable VARPSU VARIANCE ESTIMATION PSU - 2015 Number of Clusters 349   Weight Variable PERWT FINAL PERSON WEIGHT, 2015 Model Binary Logit   Optimization Technique Fisher's Scoring   Variance Adjustment Degrees of Freedom (DF)     Variance Estimation Method Taylor Series Missing Levels Included (MISSING) Variance Adjustment Degrees of Freedom (DF)   Number of Observations Read 23363 Number of Observations Used 23028 Sum of Weights Read 2.5812E8 Sum of Weights Used 2.5812E8   Response Profile Ordered Value Antibiotic Total Frequency Total Weight 1 No 21546 239733598 2 Yes 1482 18390178     Model Fit Statistics Criterion Intercept Only Intercept and Covariates AIC 132597682 131164140 SC 132597690 131164156 -2 Log L 132597680 131164136   Testing Global Null Hypothesis: BETA=0 Test Chi-Square DF Pr > ChiSq Likelihood Ratio 1433543.99 1 <.0001 Score 757520.937 1 <.0001 Wald 71303.0062 1 <.0001   Analysis of Maximum Likelihood Estimates Parameter DF Estimate Standard Error Wald Chi-Square Pr > ChiSq Intercept 1 -30.8434 0.0911 114655.453 <.0001 PPI 1 14.1581 0.0530 71303.0062 <.0001   Odds Ratio Estimates Effect Point Estimate 95% Wald Confidence Limits PPI >999.999 >999.999 >999.999     Association of Predicted Probabilities and Observed Responses Percent Concordant 4.0 Somers' D 0.040 Percent Discordant 0.0 Gamma 1.000 Percent Tied 96.0 Tau-a 0.005 Pairs 31931172 c 0.520 ... View more

Hi everyone,    I'm working on a crossover study and I would like to calculate the power to detect the significant difference between the three periods.Is there any micro or codes that I can do that?    The Crossover study has 3 periods and 6 sequences.  Thanks  ... View more