topic Re: SAS code help in New SAS User

SAS code help

mariamon0 — Fri, 06 Sep 2019 13:32:01 GMT

I am trying to determine how many "valid wear days" my participants have.

I have already determined a step valid to be more than 200 steps. stepvalid=1 vs. stepvalid=0

I want to know how many participants have 10 valid wear days 9 etc.

How would I code this?

I assume I use proc freq

Re: SAS code help

PeterClemmensen — Fri, 06 Sep 2019 13:50:28 GMT

Can you post some sample of your data for us to work with?

Makes it much easier to provide a usable code answer

Re: SAS code help

mariamon0 — Fri, 06 Sep 2019 13:53:36 GMT

data stepdata3; set stepdata2;
format date mmddyy10. ped_date mmddyy10. match_date mmddyy10. baseline_day1 mmddyy10. baseline_day10 mmddyy10.;
ped_date = date;
if steps >31000 then steps = .;
if steps >= 200 then stepvalid = 1;
else if steps < 200 then stepvalid = 0;
else stepvalid = .;
match_date = ped_date;
run;

I want to know how many of my study_id's have 10 stepvalid days 9 stepvalid days etc.

Re: SAS code help

Astounding — Fri, 06 Sep 2019 14:21:19 GMT

A two-step counting process should make this easy:

proc freq data=have;
   where stepvalid=1;
   tables study_id / noprint out=counts (rename=(count=per_study_id) ) ;
run;

proc freq data=counts;
   tables per_study_id;
run;

The first PROC FREQ saves the number of valid days for each Study ID. Then the second PROC FREQ uses those counts to produce the report.

Re: SAS code help

mariamon0 — Fri, 06 Sep 2019 14:40:55 GMT

But I want to know how many study ids have 10 valid step days...this doesnt produce what I need

Re: SAS code help

Astounding — Fri, 06 Sep 2019 14:44:46 GMT

Yes it does. Did you try it?

The report shows two key columns: per_study_ID and COUNT.

PER_STUDY_ID is the number of valid step days per Study ID.

COUNT is the number of Study IDs with that number of valid step days.

Re: SAS code help

mariamon0 — Fri, 06 Sep 2019 15:08:40 GMT

thanks for clearing that up! makes sense now!