cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Elma
‎03-11-2020
  • 5 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Report table with missing percentage visit*treatment

by Calcite | Level 5 in SAS Programming
‎03-03-2020 01:25 AM
‎03-03-2020 01:25 AM
Well, that was my point in the previous post. From the beginning I wanted only one % percent missing: the %missing (from the "want" table): due to the fact that the dataset is monotone, if at visit1 the dropout rate is for example 5%, an added dropout rate of for example 4% at visit2 would yield a total dropout rate of 9% and so on. That was what I meant as "cummulative". The second % percent: "want_cum" deriving from the code has no practice. Many thanks ... View more

Re: Report table with missing percentage visit*treatment

by Calcite | Level 5 in SAS Programming
‎02-28-2020 03:11 AM
‎02-28-2020 03:11 AM
Yep, my mistake. As "cummulative" I meant the %missing from the derived 'want' table. So no need for the 'want_cum'.   Many thanks for solving. ... View more

Re: Report table with missing percentage visit*treatment

by Calcite | Level 5 in SAS Programming
‎02-27-2020 08:32 AM
‎02-27-2020 08:32 AM
Well, as I have a monotone dataset (once dropout, forever dropout), what I want is the 'Want ' dataset .   For example if 5% is missing at visit1 and then another 6% at visit2, then in total 11% are missing at visit2, and so on (by treatment). So everything great until here.   I'm trying to understand what the 'want_cum' includes as percentages       ... View more

Re: Report table with missing percentage visit*treatment

by Calcite | Level 5 in SAS Programming
‎02-27-2020 06:35 AM
‎02-27-2020 06:35 AM
Thanks a lot!Works great and gives the cumulative %missing. Is it a way to adjust the code to take the simple (not accumulated) %missing? ... View more

Report table with missing percentage visit*treatment

by Calcite | Level 5 in SAS Programming
‎02-27-2020 05:21 AM
‎02-27-2020 05:21 AM
Hi all,   I have a horizontal repeated measurements data set that looks like this:   Id   trt   visit1  visit2  visit3 1     1      2       3      . 2     1      3       4      . 3     2      .        .       . 4     2      4       .       .   where trt=treatment. 1) I would like to create a table with % missing percentage for each visit variable by treatment (like the below table):     treatment   1 2 visit1 %missing %missing visit2 %missing %missing visit3 %missing %missing   I've used proc means data=want nmiss N; by trt; var visit1 visit2 visit3; run;   but the result is in different treatment tables and there is no missing percentage.. 2) I would like to create the same table with accumulate % missing percentages towards the last visit by treatment.   I've also read the attached but with no outcome..   Any help would be appreciated.. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-11-2020 08:55 AM
Quick links