I have diagnosis variable in my dataset which is ICD Code. I want to format Diagnosis variable in  CCS Category which available in csv format (attached). Attached csv file has 3 columns: 1. ICD-Code ( Diagnosis in my data-set), 2. CCS Category (I want  Diagnosis formatted  in CCS Category), 3. CCS Category Description (I want CCS Category to be labeled with this information) Below is how csv file column looks like. 15,000 ICD Codes are grouped in clinically meaningful  200 (approx) categories and I am trying to format Diagnosis Variable in my data set in those Categories. How can I do it? Thanks. 'ICD-9-CM CODE' 'CCS CATEGORY' 'CCS CATEGORY DESCRIPTION' '3220 ' '76   ' 'Meningitis' '3221 ' '76   ' 'Meningitis' '3222 ' '76   ' 'Meningitis' '3229 ' '76   ' 'Meningitis' '0361 ' '77   ' 'Encephalitis' '0462 ' '77   ' 'Encephalitis' '0498 ' '77   ' 'Encephalitis' '0499 ' '77   ' 'Encephalitis' '0520 ' '77   ' 'Encephalitis' '0543 ' '77   ' 'Encephalitis' '0550 ' '77   ' 'Encephalitis' '05601' '77   ' 'Encephalitis' '05821' '77   ' 'Encephalitis' '05829' '77   ' 'Encephalitis' '0620 ' '77   ' 'Encephalitis' ... View more

I have variable named DRG (Diagnosis Related Group) in my SAS dataset. DRG can be any where between 001 to 989 for diagnosis which patient are treated. I have label of those DRG 001 to 989 in excel like this: 134 Pulmonary embolism                                                  135 Major chest & respiratory trauma                                    136 Respiratory malignancy                                              137 Major respiratory infections & inflammations                        138 Bronchiolitis & RSV pneumonia                                       139 Other pneumonia                                                     140 Chronic obstructive pulmonary disease                               141 Asthma                                                              142 Interstitial & alveolar lung diseases                               143 Other respiratory diagnoses except signs, symptoms & minor diagnoses 144 Respiratory signs, symptoms & minor diagnoses                       160 Major cardiothoracic repair of heart anomaly                        161 Cardiac defibrillator & heart assist implant                        162 Cardiac valve procedures w cardiac catheterization                  How can I label DRG directly from excel? I can copy and paste it in SAS and label it but is there any way to add label to DRG directly from excel? ... View more

I want to create a new variable( RaceEthnicity)  based on these two variables (Race and Ethnicity): Race Ethnicity American Indian or Alaska Native Asian/Native Hawaiian or Other Pacific Islander Bi-racial Black or African American Other Unknown White '1'='HISPANIC' '2'='NOT HISPANIC ' '9'='UNKNOWN '7'=UNKNOWN I I want new variable ( RaceEthnicity) to have 5 categories based on these conditions. If Ethnicity= '1' and Race =Any then RaceAndEthnicity = Hispanic- Any Race If Ethnicity= '2' and Race =White then RaceAndEthnicity = White NH If Ethnicity= '2' and Race =Black or African American then RaceAndEthnicity = Black NH If Ethnicity= '2' and Race = Asian/Native Hawaiian or Other Pacific Islander then RaceAndEthnicity = Asian Any other combination= Others/Unknown. What will be best way to do it (preferably in single step)? Any suggestion will be appreciated? ... View more