topic new to IFC/IFN in SAS Programming

new to IFC/IFN

Steelers_In_DC — Wed, 10 Dec 2014 17:15:51 GMT

Running the code below I am expecting to see a 'null' for the check2 variable from the third row. I get a 'wrong'. Can someone explain why?

Thank You,

data ifc;

infile cards dsd;

input one two three;

cards;

1,2,3

,2,3

1,,3

1,3,

;

run;

data test;

set ifc;

check1 = ifc(one,.,'one is null');

check2 = ifc(two = 2,'right','wrong','null');

run;

Re: new to IFC/IFN

PGStats — Wed, 10 Dec 2014 17:39:04 GMT

Try :

data test2;

desc = "2 = 1"; c = 2 = 1; output;

desc = "2 = ."; c = 2 = .; output;

desc = ". = ."; c = . = .; output;

run;

pric print data=test2; run;

Re: new to IFC/IFN

Haikuo — Wed, 10 Dec 2014 17:42:33 GMT

I have made some modifications on your data and your code, now you can easily figure out what is going on:

data ifc;

infile cards dsd;

input one two three;

cards;

1,2,3

,0,3

1,,3

1,3,

;

run;

data test;

set ifc;

check1 = ifc(one,.,'one is null');

check2 = ifc(two,'right','wrong','null');

run;

Update: a boolean evaluation such as 'two=2' will never be missing, it is either 1 or 0, so this is why you are not getting 'null' as an outcome.

Re: new to IFC/IFN

Steelers_In_DC — Wed, 10 Dec 2014 18:37:12 GMT

Excellent, thank you!