topic Re: Efficient way to Label based on variable value in Excel in SAS Procedures

Efficient way to Label based on variable value in Excel

bikash — Wed, 28 Jan 2015 20:39:27 GMT

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?

Re: Efficient way to Label based on variable value in Excel

ballardw — Wed, 28 Jan 2015 22:06:33 GMT

Are codes and the text in separate columns? I think the Excel approach is VLOOKUp.

Better would be to create a SAS format and then export the formatted value.

Proc format;

value DRG /* assumes DRG is numeric*/

134 ='Pulmonary embolism'

135 ='Major chest & respiratory trauma'

136 ='Respiratory malignancy'

137 ='Major respiratory infections & inflammations'

138 ='Bronchiolitis & RSV pneumonia'

/* continue with the rest Or learn the utility of a CNTLIN dataset*/

;

run;

And then associate the format with the variable when writing the DRG variable out and you don't need to do anything else like a look up in Excel.

Re: Efficient way to Label based on variable value in Excel

Ksharp — Thu, 29 Jan 2015 06:18:51 GMT

use proc import to import that excel file and use some match skills like : Hash Table ,SQL, Merge, proc format ......... to bring those labels back into SAS dataset.

Re: Efficient way to Label based on variable value in Excel

bikash — Fri, 30 Jan 2015 15:34:55 GMT

Thanks Ballardw.

Re: Efficient way to Label based on variable value in Excel

bikash — Fri, 30 Jan 2015 15:36:00 GMT

Thanks Xia. Those skills are too advanced for me right now. I will use format for this time.