SAS Support Communities

Get SAS tips, share your knowledge, and find out about upcoming SAS-related events.

‎12-07-2018

Obsidian | Level 7

Member since

15 Posts
7 Likes Given
0 Solutions
1 Likes Received

Follow abc44

Re: How to average values over a range of observations

6987

‎11-19-2018 02:17 PM

Re: How to average values over a range of observations

7025

‎11-16-2018 09:51 AM

Re: How to average values over a range of observations

7025

‎11-16-2018 09:50 AM

Re: How to average values over a range of observations

7097

‎11-15-2018 05:28 PM

How to average values over a range of observations

7118

‎11-15-2018 05:03 PM

Re: How to delete an observation if another observation for the same s...

946

‎10-12-2018 04:44 PM

How to delete an observation if another observation for the same subje...

978

‎10-12-2018 03:41 PM

Re: how to delete a group of observations based on certain conditions

2460

‎09-18-2018 09:25 AM

how to delete a group of observations based on certain conditions

2501

‎09-17-2018 05:08 PM

Re: Assignments of visit number based on date

1276

‎09-14-2018 06:29 PM

Activity Feed for abc44

Liked Re: How to average values over a range of observations for PGStats. ‎11-22-2018 03:30 PM
Posted Re: How to average values over a range of observations on SAS Programming. ‎11-19-2018 02:17 PM
Posted Re: How to average values over a range of observations on SAS Programming. ‎11-16-2018 09:51 AM
Posted Re: How to average values over a range of observations on SAS Programming. ‎11-16-2018 09:50 AM
Liked Re: How to average values over a range of observations for hashman. ‎11-16-2018 09:50 AM
Liked Re: How to average values over a range of observations for PGStats. ‎11-16-2018 09:46 AM
Posted Re: How to average values over a range of observations on SAS Programming. ‎11-15-2018 05:28 PM
Posted How to average values over a range of observations on SAS Programming. ‎11-15-2018 05:03 PM
Posted Re: How to delete an observation if another observation for the same subject does not meet a conditi on SAS Programming. ‎10-12-2018 04:44 PM
Liked Re: How to delete an observation if another observation for the same subject does not meet a conditi for novinosrin. ‎10-12-2018 04:41 PM
Liked Re: How to delete an observation if another observation for the same subject does not meet a conditi for sidpesar. ‎10-12-2018 04:41 PM
Posted How to delete an observation if another observation for the same subject does not meet a condition? on SAS Programming. ‎10-12-2018 03:41 PM
Posted Re: how to delete a group of observations based on certain conditions on SAS Programming. ‎09-18-2018 09:25 AM
Liked Re: how to delete a group of observations based on certain conditions for novinosrin. ‎09-18-2018 09:25 AM
Posted how to delete a group of observations based on certain conditions on SAS Programming. ‎09-17-2018 05:08 PM
Posted Re: Assignments of visit number based on date on SAS Programming. ‎09-14-2018 06:29 PM
Liked Re: Assignments of visit number based on date for novinosrin. ‎09-14-2018 06:29 PM
Posted Assignments of visit number based on date on SAS Programming. ‎09-14-2018 06:07 PM
Got a Like for Re: how to select top 3 observations based on 2 conditions. ‎07-27-2018 04:43 PM
Posted Re: how to select top 3 observations based on 2 conditions on SAS Programming. ‎07-27-2018 04:41 PM

To remove the initial missing values, build the steps dataset with: data steps; retain day; set work.subject_: indsname=dsn curobs=d; subject = scan(dsn,2); if d = 1 then call missing(day); if missing(day) then do; if not missing(steps) then day = 0; end; if not missing(day) then do; day = day + 1; output; end; run;

Thank you! Both solutions worked perfectly!

Thanks so much!

a teaser fun i learned from genius PD's dazzle playing with PDV . Don't use this, but play with it. It's a joy as it gives an intuition of how DOW works 🙂 data want1; if 0 then set have; visit=0; do until(last.id); visit+1; do until(last.date); set have; by id date; output; end; end; run;