topic Re: grouping id and replacing 77 under trmt1 to Rx in SAS Programming

grouping id and replacing 77 under trmt1 to Rx

Dhana18 — Wed, 12 Feb 2020 16:14:09 GMT

Hi,

I am writing this to get your great magical help please help.

I merged these two data sets. EventID and Event_Num are the same ID.

I have the info and I need to group the ids and find and replace 77(unknown) under TRMT1 to

(Ceftriaxone 250 mg IM RVG or Ceftriaxone 250 mg IM LVG or Ceftriaxone Rocephin_250_ MG_IM as "04")

or Azithromycin(Zithromax) 2GM PO as "21" or Gentamycin 240 MG IM BILAT VG as "28"

AND replace 0 under TRMT2 to

Azithromycin(Zithromax)1GM PO as "11" or Doxycycline 100 MG PO BID x 07 as "9" or Azithromycin(Zithromax) 2GM PO as "21" .

The data set(similar to what i am working) is attached. Please please help me.

ChrisNZ — Thu, 13 Feb 2020 22:24:08 GMT

1. Your question is hard to understand. Please reword and provide data examples as code.

2. Many people will/can not download MS Office files due to the risk they present.

Dhana18 — Thu, 13 Feb 2020 22:27:08 GMT

I am sorry for not being clear enough for you to understand. That is ok, I figured it out.