https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785746#M250796 <P>If what you want is to flag the screenings that come before another instance (g.e. blinded tratment), it can be done like this:</P> <PRE><CODE class=" language-sas">data want; set have; by sub epoch notsorted; if last.epoch and not last.sub and epoch='SCREENING' then flag='Y'; run;</CODE></PRE> Mon, 13 Dec 2021 13:05:25 GMT s_lassen 2021-12-13T13:05:25Z https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785621#M250755 <P>Data Have ;</P> <P>sub&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;no&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; stdt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dtc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; epoch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT</P> <P>&nbsp;</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-06-14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SCREENING</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp;2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT</P> <P>&nbsp;</P> <P>I want data&nbsp;</P> <P>sub&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;no&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; stdt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dtc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; epoch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; flg</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;""</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ""</P> <P>&nbsp;</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-06-14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ""</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp;2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ""</P> <P>&nbsp;</P> Sun, 12 Dec 2021 14:11:20 GMT https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785621#M250755 teja5959 2021-12-12T14:11:20Z https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785625#M250756 <P>What are the rules involved?</P> <P>&nbsp;</P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/127990">@teja5959</a>&nbsp;wrote:<BR /> <P>Data Have ;</P> <P>sub&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;no&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; stdt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dtc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; epoch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT</P> <P>&nbsp;</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-06-14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SCREENING</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp;2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT</P> <P>&nbsp;</P> <P>I want data&nbsp;</P> <P>sub&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;no&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; stdt&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;dtc&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; epoch&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; flg</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-17&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;""</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y</P> <P>101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2021-06-22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-06&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ""</P> <P>&nbsp;</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-06-14&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SCREENING&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Y</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; 2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ""</P> <P>102&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3&nbsp; &nbsp; &nbsp; &nbsp;2021-07-12&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;2021-07-26&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; BLINDED TREATMENT&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ""</P> <P>&nbsp;</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Sun, 12 Dec 2021 15:08:39 GMT https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785625#M250756 ballardw 2021-12-12T15:08:39Z https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785639#M250761 <P>is it the last non missing screening visit?&nbsp;</P> Sun, 12 Dec 2021 18:05:41 GMT https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785639#M250761 tarheel13 2021-12-12T18:05:41Z https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785746#M250796 <P>If what you want is to flag the screenings that come before another instance (g.e. blinded tratment), it can be done like this:</P> <PRE><CODE class=" language-sas">data want; set have; by sub epoch notsorted; if last.epoch and not last.sub and epoch='SCREENING' then flag='Y'; run;</CODE></PRE> Mon, 13 Dec 2021 13:05:25 GMT https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785746#M250796 s_lassen 2021-12-13T13:05:25Z https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785792#M250822 <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/181158">@tarheel13</a>&nbsp;wrote:<BR /> <P>is it the last non missing screening visit?&nbsp;</P> <HR /></BLOCKQUOTE> <P>Do you have any missing "Epoch" values? (If that is how to tell if a visit is screening or not)</P> <P>&nbsp;</P> Mon, 13 Dec 2021 16:25:09 GMT https://communities.sas.com/t5/SAS-Programming/Baseline-Flag-how-to-Assigned/m-p/785792#M250822 ballardw 2021-12-13T16:25:09Z