topic Re: Confused: Why SAS fail to select a row by condition... in SAS Programming

Confused: Why SAS fail to select a row by condition...

LisaYIN9309 — Thu, 26 Oct 2017 20:55:23 GMT

Hi I need some help to figure out this puzzle, I am QAing my own work, and found an error:

I have this dataset called , with a calculated column called 'week', which, from both proc freq and my eye ball checking, has values from 0 -41.But, I try to print out some extreme values, like 41, log keeps telling me 'no rows were selected'.....

proc freq data=numerator2_full;

tables week;

run;

I know this probably looks very stupid, but this has drive me crazy....

Thank you for your help!

Re: Confused: Why SAS fail to select a row by condition...

art297 — Thu, 26 Oct 2017 21:05:01 GMT

Please post you full log, i.e., including the part where you ran the proc freq.

Art, CEO, AnalystFinder.com

Re: Confused: Why SAS fail to select a row by condition...

Tom — Thu, 26 Oct 2017 21:18:25 GMT

Perhaps it is not exactly 41?

where round(week,1)=41 ;

Or perhaps you have a format attached?

data want;
 set have ;
 if strip(vvalue(week))='41';
run;

Re: Confused: Why SAS fail to select a row by condition...

Reeza — Thu, 26 Oct 2017 23:59:45 GMT

Run a PROC CONTENTS on your dataset and check the format and type.

Re: Confused: Why SAS fail to select a row by condition...

ShiroAmada — Fri, 27 Oct 2017 00:51:33 GMT

How did you calculate the variable WEEK?

Re: Confused: Why SAS fail to select a row by condition...

LisaYIN9309 — Fri, 27 Oct 2017 01:42:29 GMT

good point @Tom, this week variable is calculated. I calculated as (Vaccine_Day - Pre_day)/7 = week format 8.0

Now I am curious to see how my

Re: Confused: Why SAS fail to select a row by condition...

LisaYIN9309 — Fri, 27 Oct 2017 01:43:17 GMT

I calculated as (Vaccine_Day - Pre_start_day)/7 = week format 8.0

week is supposed to be 'at which week at pregnant a lady got her vaccine'.

Re: Confused: Why SAS fail to select a row by condition...

Reeza — Fri, 27 Oct 2017 03:24:49 GMT

Ah, yes, you definitely have decimal points then. If you want it actually rounded then round the value.

round((Vaccine_Day - Pre_day)/7, 1) format = 8.0

Re: Confused: Why SAS fail to select a row by condition...

Tom — Fri, 27 Oct 2017 04:31:55 GMT

@LisaYIN9309 wrote:
I calculated as (Vaccine_Day - Pre_start_day)/7 = week format 8.0

week is supposed to be 'at which week at pregnant a lady got her vaccine'.

Attaching a format to a variable will change how the variable is printed, but it does not change the value. If you want WEEK to be an integer then use ROUND() or INT() function.

I am also curious as to why you picked 8.0 as the format to attach. Did you really expect to have WEEK counts as high as 99 Million?

Re: Confused: Why SAS fail to select a row by condition...

ShiroAmada — Fri, 27 Oct 2017 07:22:05 GMT

you can try using int(week)=41, that should help.