12-07-2018
abc44
Obsidian | Level 7
Member since
07-27-2018
- 15 Posts
- 7 Likes Given
- 0 Solutions
- 1 Likes Received
-
Latest posts by abc44
Subject Views Posted 6987 11-19-2018 02:17 PM 7025 11-16-2018 09:51 AM 7025 11-16-2018 09:50 AM 7097 11-15-2018 05:28 PM 7118 11-15-2018 05:03 PM 946 10-12-2018 04:44 PM 978 10-12-2018 03:41 PM 2460 09-18-2018 09:25 AM 2501 09-17-2018 05:08 PM 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
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 1 1 -
My Liked Posts
Subject Likes Posted 1 07-27-2018 04:41 PM
11-19-2018
04:04 PM
1 Like
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;
... View more
10-12-2018
04:44 PM
Thank you! Both solutions worked perfectly!
... View more
09-14-2018
06:33 PM
1 Like
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;
... View more
07-27-2018
04:41 PM
1 Like
This worked perfectly! Thank you so much!
... View more