I imported a stata dataset into SAS successfully. However, for my date variable (r24_date), several of the observations had typos such that 16oct2015 is actually coded as16oct0215. I can see this when looking at the stata dataset in stata. Something goes wrong here when I import the stata dataset into SAS and "16oct0215" becomes **********.        For example, printing out a single observation (after sorting the dataset by r24_date ascending):    Other than this one date typo, the remainder of the dates are correct and are in the format MMDDYY10. For example:    I've tried to replace the ******** using a simple datastep, but SAS does not like the **********s.    data want;  set have; if r24_date = "**********" then r24_date = "16oct2015"d; run;   I have tried changing the data in stata and in excel then importing to SAS, but I am still having errors related to date formats.  Any thoughts? Thanks.      ... View more

Hi everyone,    I have two datasets. Dataset 1 is a discharge dataset. Each obsercation has a unique id (var name "ID") and10 diagnosis variables (var names dx_1, dx_2, dx_3, etc). The diagnosis variable values are ICD9 codes such as 707.00, 707.01, etc.   Dataset 2 contains a list of ICD9 codes and group-level variables. So, for each ICD9 code (unique, 1 observation each), I have 6 1/0 variables that indicate if the code is part of a larger group (var names group_1, group_2). I.e., ICD9 code 707.00 will get a "1" for group_1.    I want to be able to go through dataset 1, and look at each dx_n variable. If the value is, for example, 707.00, I want to assign that discharge a "1" for the variable group_1.    Essentially, I want to create these new indicator variables in dataset 1, but I am defining them based on group definitions from dataset 2. Should I do this in a datastep? Is there a SAS procedure that would make this easier?    Thanks!  ... View more