08-18-2019
raj00728
Fluorite | Level 6
Member since
02-23-2018
- 8 Posts
- 0 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by raj00728
Subject Views Posted 2883 07-30-2019 09:14 PM 2917 07-30-2019 04:32 PM 2945 07-30-2019 03:52 PM 2987 07-30-2019 02:58 PM 2994 07-30-2019 02:43 PM 3022 07-30-2019 01:30 PM 3889 02-23-2018 08:40 PM -
Activity Feed for raj00728
- Posted Re: Randomly assign a date (which also satisfies a condition) from another list of possible dates on SAS Programming. 07-30-2019 09:14 PM
- Posted Re: Randomly assign a date (which also satisfies a condition) from another list of possible dates on SAS Programming. 07-30-2019 04:32 PM
- Posted Re: Randomly assign a date (which also satisfies a condition) from another list of possible dates on SAS Programming. 07-30-2019 03:52 PM
- Posted Re: Randomly assign a date (which also satisfies a condition) from another list of possible dates on SAS Programming. 07-30-2019 02:58 PM
- Posted Re: Randomly assign a date (which also satisfies a condition) from another list of possible dates on SAS Programming. 07-30-2019 02:43 PM
- Posted Randomly assign a date (which also satisfies a condition) from another list of possible dates on SAS Programming. 07-30-2019 01:30 PM
- Posted Pooling results after multiple imputations on Statistical Procedures. 02-23-2018 08:40 PM
07-30-2019
09:14 PM
Thank you for the info and your help! Regards, -Raj
... View more
07-30-2019
04:32 PM
How could I add a "seed" number?
... View more
07-30-2019
03:52 PM
Thank you. This code is picking/assigning a date2 which meets the condition, however, I am still loosing observations. Now have 95 observations instead of 100. Revised Response: This is code is working fine. I have also figured out the reason why I was having lesser number of observations in my "want" data set. It was because there was no "date" from the "data set B" which could have satisfied the condition for a date value in data set A (date1). Thank you, PG!
... View more
07-30-2019
02:58 PM
Here is the screenshot of the data set I get after running the code. ID is ID from data set A DOD is date1 from data set A KC_Dx_Dt is date2 which should be randomly selected from data set B. For ex., for ID=3 or 4, the condition that date2 (KC_Dx_Dt) should be at least 30 day before date1 (DOD) is not meeting. Also, I had 100 observations in data set A, however, here in the want data set, I have 98 observations.
... View more
07-30-2019
02:43 PM
Hi PG, Thank you for a quick response. I ran your code for my data, but it is not working as per my need. The observations where there is "date1" in data set A, I would like to have the randomly selected date (from data set B) to be at least 30 days before the "date1." I am also loosing observations from data set A, which should not be the case if the random selection is with replacement.
... View more
07-30-2019
01:30 PM
Hi, I am trying to assign a randomly selected date to observations in data set A from another list of possible dates in data set B. However, for some observations in data set A, there is another date variable and I want the randomly selected date (with replacement) from data set B to be at least 30 days before the observed data in data set A. Below is how the two data sets (A & B) look and the want data set C: Data set A ID date1 1 . 2 02JAN2018 3 . 4 31JUL2000 5 . Data set B date2 30JUL2019 03MAR1999 09SEP2016 01JAN2017 Want Data set C ID date1 date2 1 . 01JAN2017 2 02JAN2018 03MAR1999 3 . 30JUL2019 4 31JUL2000 03MAR1999 5 . 01JAN2017 How could I do this? Greatly appreciate your help. Regards, -Raj
... View more
02-23-2018
08:40 PM
Hi, I am new to PROC MI. I have 500 unique patient data with 30 variables, of which 15 variables have missing values. Using multiple imputations procedure, I was able to impute 15 different variables (some binary, some ordinal and a few nominal); 30 imputations in total. So my final data set contains 15000 observations. Then I created a few summary variables from the "new imputed variables" to be used as covariates in the regression models. Now, I am unable to conduct univariate, bivariate and multivariate analyses using standard SAS procedures and then combining them using PROC MIANALYZE. I want to do something like the following using the multiple imputed data set (30 imputations): 1. I want to have standard table 1 to describe my sample. I want to report: n (%) for categorical variables and mean (SD) for continuous. 2. I want to have standard table 2 to describe my sample by my exposure (2 level) and conduct a Chi-square for categorical variables and t-test for continuous. 3. I want to have standard table 3 which compares adjusted LS Means and SE for my continuous OUTCOME variable across the exposure, adjusting for several covariates. Could someone please guide me? Thanks. -Raj
... View more