topic formatted values in if condition in New SAS User

formatted values in if condition

chinna0369 — Tue, 14 May 2019 20:04:30 GMT

Hi,

I am having problem in passing fomatted values in if condition.

I have below TRTP values in my count dataset:

And I want to create another variable by using below calculation.

data count1;
	set count;
	if TRTP eq "A" then c2=count/Count1*100;
run;

but I am getting missing values for c2 variable, but log is clear.

Is there anything I am missing there?

Thanks,

Adithya

PaigeMiller — Tue, 14 May 2019 20:15:16 GMT

Your code compares TRTP to "A", but if TRTP is formatted, it may have underlying values different than what you see.

Any such comparison

if TRTP eq "A"

uses the unformatted values, not the formatted values. So the comparison would fail, even if it LOOKS LIKE your variable TRTP has value "A".

So just to make up an example, if the format $TRT1. is something like this:

proc format;
    value $trt "A","B","Q","T"="A";
run;

Then the comparison you would want to do is

if TRTP in ("A","B","Q","T")

ballardw — Tue, 14 May 2019 20:16:38 GMT

To compare a value to a formatted value explicitly use the format:

If put(trtp,$trt1.) = 'A' then <whatever>;

FreelanceReinh — Tue, 14 May 2019 21:20:40 GMT

@ballardw wrote:

To compare a value to a formatted value explicitly use the format:

If put(trtp,$trt1.) = 'A' then <whatever>;

Another option is to use the format implicitly:

if vvalue(trtp)='A' then ...

(See VVALUE function. Be careful, however, when using this for unformatted numeric variables. In that case the default format BEST12. will apply.)