code to count Counting frequency

[Dhana18]

Good morning,

i have a data like this 

ANTIBIOTIC
ANTIBIOTIC	Frequency
AZITHROMYCIN	1
CEFTRIAXONE/AZITHROMYCIN	3
DOXYCYCLINE	3
FLUCONAZOLE	1
METRONIDAZOLE	1
UNKNOWN	1

I coded like this:

DATA AprilNin.MERGE_April2019_E;
SET AprilNin.MERGE_April2019_D;
IF ANTIBIOTIC = "CEFTRIAXONE" then ANTIBIOT_NAME = "04";
ELSE IF UPCASE(ANTIBIOTIC) =: "AZ" OR UPCASE(ANTIBIOTIC) =: "ZI" then ANTIBIOT_NAME = "11";
ELSE IF UPCASE(ANTIBIOTIC) =: "CEFTRIAXONE/AZITHROMYCIN" then ANTIBIOT_NAME = "11";
ELSE IF UPCASE(ANTIBIOTIC) =: "DO" then ANTIBIOT_NAME = "09";
ELSE IF ANTIBIOTIC = "0" THEN ANTIBIOT_NAME = "00";
ELSE IF ANTIBIOTIC="" THEN ANTIBIOT_NAME="00";
ELSE ANTIBIOT_NAME="77";
RUN;
/*CHECKING TO SEE IF THE CODE ABOVE WORKED*/
PROC FREQ DATA=AprilNin.MERGE_April2019_E;
TABLE ANTIBIOT_NAME/NOROW NOCOL NOPERCENT;
RUN;

 and the result shows:

ANTIBIOT_NAME	Frequency
9	3
11	4
77	3

  Why am i not getting Ceftriaxone (04) in the result table? 

[Jagadishkatam]

The CEFTRIAXONE is getting counted under the ANTIBIOT_NAME = "11" due to the if condition UPCASE(ANTIBIOTIC) =: "CEFTRIAXONE/AZITHROMYCIN" . Inorder to get the ANTIBIOT_NAME = "04", you need to have the ANTIBIOTIC = "CEFTRIAXONE" only. But seems like the data does not have it. Please check.

[Dhana18]

Yes, the dat does not have ceftriaxone separately. Is there a way to code to get both Ceftriaxone and Azithromycin info? Or I should separate then before I import to SAS?

[Jagadishkatam]

Could you please try the below code if it is the one you are expecting

data have;
input ANTIBIOTIC &:$100.;
cards;
AZITHROMYCIN	
CEFTRIAXONE/AZITHROMYCIN	
DOXYCYCLINE	
FLUCONAZOLE	
METRONIDAZOLE	
UNKNOWN	
;

data want(rename=(newvar=ANTIBIOTIC));
set have;
do i = 1 to countw(ANTIBIOTIC,'/');
newvar=scan(ANTIBIOTIC,i,'/');
output;
end;
drop ANTIBIOTIC;
run;

data want2;
set want;
IF ANTIBIOTIC = "CEFTRIAXONE" then ANTIBIOT_NAME = "04";
ELSE IF UPCASE(ANTIBIOTIC) =: "AZ" OR UPCASE(ANTIBIOTIC) =: "ZI" then ANTIBIOT_NAME = "11";
ELSE IF UPCASE(ANTIBIOTIC) =: "CEFTRIAXONE/AZITHROMYCIN" then ANTIBIOT_NAME = "11";
ELSE IF UPCASE(ANTIBIOTIC) =: "DO" then ANTIBIOT_NAME = "09";
ELSE IF ANTIBIOTIC = "0" THEN ANTIBIOT_NAME = "00";
ELSE IF ANTIBIOTIC="" THEN ANTIBIOT_NAME="00";
ELSE ANTIBIOT_NAME="77";
run;

PROC FREQ DATA=want2;
TABLE ANTIBIOT_NAME/NOROW NOCOL NOPERCENT;
RUN;