topic Re: if-then in New SAS User

if-then

nturne — Mon, 18 Nov 2019 14:54:41 GMT

Hi Sas user,

I am trying to assign prescription variables as 1 in this code

data cdmeds;
set ndc2;
if NONPROPRIETARYNAME = 'Metronidazole' or 'infliximab' or 'natalizumab' then do;
metron=1;
inflix=1;
natal=1;
end;

proc print data=cdmeds;
var natal inflix metron;
run;

However, my log appears like this with all missing values (see attachment). What am I doing wrong?

Re: if-then

PeterClemmensen — Mon, 18 Nov 2019 14:58:05 GMT

I think this is the syntax you're looking for

data cdmeds;
    set ndc2;
    if NONPROPRIETARYNAME in ('Metronidazole', 'infliximab', 'natalizumab') then do;
        metron=1;
        inflix=1;
        natal=1;
    end;
run;

proc print data=cdmeds;
    var natal inflix metron;
run;

Re: if-then

nturne — Mon, 18 Nov 2019 15:04:04 GMT

Thank you for your suggestion, but it still did not work.

Re: if-then

PeterClemmensen — Mon, 18 Nov 2019 15:05:12 GMT

I can't see your data or your log. Only your code 🙂

Please post your log.

Re: if-then log

nturne — Mon, 18 Nov 2019 15:18:20 GMT

Re: if-then

nturne — Mon, 18 Nov 2019 15:19:09 GMT

see picture below!

Re: if-then

ed_sas_member — Mon, 18 Nov 2019 15:43:23 GMT

Hi @nturne

Maybe try this (it seems more logical according to the variables names but I am not sure as I can't see your raw data)


data cdmeds;
	set ndc2;

	if lowcase(NONPROPRIETARYNAME)='metronidazole' then metron=1;
	else if lowcase(NONPROPRIETARYNAME)='infliximab' then inflix=1;
	else if lowcase(NONPROPRIETARYNAME)='natalizumab' then natal=1;

run;

proc print data=cdmeds;
	var metron inflix natal;
run;

Best,

Re: if-then

Kurt_Bremser — Mon, 18 Nov 2019 15:21:16 GMT

@nturne wrote:

Thank you for your suggestion, but it still did not work.

Please don't feed us the proverbial "blonde secretary" quotes.

Post the LOG (using the {I} button), and post example data as a data step with datalines. DO NOT post pictures of data, we're not hired as your typists.

Re: if-then

PeterClemmensen — Mon, 18 Nov 2019 15:22:34 GMT

This is your result data, not your log. Please don't make us guess the structure of your data.

Re: if-then

nturne — Mon, 18 Nov 2019 15:41:58 GMT

NOTE: There were 193176 observations read from the data set WORK.CDMEDS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.47 seconds
cpu time 0.48 seconds

180 data cdmeds;
181 set ndc2;
182 if NONPROPRIETARYNAME in ('metronidazole', 'infliximab' , 'natalizumab') then do;
183 metron=1;
184 inflix=1;
185 natal=1;
186 end;
187 run;

NOTE: There were 193176 observations read from the data set WORK.NDC2.
NOTE: The data set WORK.CDMEDS has 193176 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 0.34 seconds
cpu time 0.32 seconds

188
189 proc print data=cdmeds;
190 var metron natal inflix;
191 run;

NOTE: There were 193176 observations read from the data set WORK.CDMEDS.
NOTE: PROCEDURE PRINT used (Total process time):
real time 0.57 seconds
cpu time 0.57 seconds

192 ***Re

193 data cdmeds;
194 set ndc2;
195
196 if lowcase(NONPROPRIETARYNAME) = 'metronidazole' then metron=1;
197 else if lowcase(NONPROPRIETARYNAME) = 'infliximab' then inflix=1;
198 else if lowcase(NONPROPRIETARYNAME) = 'natalizumab' then natal=1;
199

200 proc print data=cdmeds;
201 var natal inflix metron;
202 run;

This is my log. Although, there is no error message, I still do not have any values in my output.

Re: if-then

unison — Mon, 18 Nov 2019 15:49:07 GMT

Add this into your case statement.

else delete;

It could be that your proc print isn't printing enough observations to view a hit. This will show you for sure that something (or nothing) is being identified.

-unison

Re: if-then

ed_sas_member — Mon, 18 Nov 2019 15:58:50 GMT

The same using an array an more practical if you have a long list of drugs:


data cdmeds;

	set ndc2;

	array presc(3) $20  ('metronidazole','infliximab','natalizumab'); /* specify the list of drugs */
	array flag(3) metron inflix natal; /* specify the list of associated flags in the same order */
	
	do i=1 to dim(presc);
		if index(lowcase(nonproprietaryname),presc(i))>0 then do;
			flag(i)=1;
			leave;
		end;
	end;
	
	drop i;
	
run;

proc print data=cdmeds;
	var metron inflix natal;
run;

Re: if-then

Kurt_Bremser — Mon, 18 Nov 2019 16:10:15 GMT

Add nonproprietaryname to your var list in proc print, to check it.

Re: if-then

nturne — Mon, 18 Nov 2019 16:11:57 GMT

Hi,

I received the following error:

361 do i=1 to dim(presc);
362 if index(nonproprietaryname),presc(i))>0 then do;
- -
22 22
200 200
-----
71
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=,
<>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN,
OR, THEN, ^, ^=, |, ||, ~, ~=.

ERROR 200-322: The symbol is not recognized and will be ignored.

ERROR 71-185: The INDEX function call does not have enough arguments.

Re: if-then

ed_sas_member — Mon, 18 Nov 2019 16:13:42 GMT

Hi,

it seems that lowercase is missing :

index(lowcase(nonproprietaryname),presc(i))

Re: if-then

Kurt_Bremser — Mon, 18 Nov 2019 16:24:02 GMT

@nturne wrote:

Hi,

I received the following error:

361 do i=1 to dim(presc);
362 if index(nonproprietaryname),presc(i))>0 then do;
- -
22 22
200 200
-----
71
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, *, **, +, -, /, ;, <, <=,
<>, =, >, ><, >=, AND, EQ, GE, GT, IN, LE, LT, MAX, MIN, NE, NG, NL, NOT, NOTIN,
OR, THEN, ^, ^=, |, ||, ~, ~=.

ERROR 200-322: The symbol is not recognized and will be ignored.

ERROR 71-185: The INDEX function call does not have enough arguments.

Count your opening and closing brackets in line 362.

Re: if-then

nturne — Mon, 18 Nov 2019 18:46:54 GMT

I apologize if i offended the SAS experts. I am new to sas communities so I'm still learning how to use this. I had no idea we could not take screen shots (note to self).