topic Re: data logic in SAS Programming

topic Re: data logic in SAS Programming https://communities.sas.com/t5/SAS-Programming/data-logic/m-p/498603#M132547 <P>Look at the MOD function in combination with the _N_ automatic variable. </P> <P> </P> <P> </P> <PRE><CODE class=" language-sas">flag='X'; if mod(_n_, 4) =0 then flag='Y'; </CODE></PRE> Mon, 24 Sep 2018 21:49:26 GMT Reeza 2018-09-24T21:49:26Z data logic https://communities.sas.com/t5/SAS-Programming/data-logic/m-p/498600#M132545 <P> </P> <P>Hi All</P> <P>I have the following data set and I want to populate ‘x’  for every 3<SUP>rd</SUP>  observation  and “Y”  for the 4<SUP>th</SUP> observation in Res variable</P> <P> </P> <P> </P> <TABLE width="151"> <TBODY> <TR> <TD width="87"> <P>              ID</P> </TD> <TD width="64"> <P>Res</P> </TD> </TR> <TR> <TD width="87"> <P>111</P> </TD> <TD width="64"> <P>x</P> </TD> </TR> <TR> <TD width="87"> <P>222</P> </TD> <TD width="64"> <P>x</P> </TD> </TR> <TR> <TD width="87"> <P>333</P> </TD> <TD width="64"> <P>x</P> </TD> </TR> <TR> <TD width="87"> <P>444</P> </TD> <TD width="64"> <P>y</P> </TD> </TR> <TR> <TD width="87"> <P>555</P> </TD> <TD width="64"> <P>x</P> </TD> </TR> <TR> <TD width="87"> <P>666</P> </TD> <TD width="64"> <P>x</P> </TD> </TR> <TR> <TD width="87"> <P>777</P> </TD> <TD width="64"> <P>x</P> </TD> </TR> <TR> <TD width="87"> <P>888</P> </TD> <TD width="64"> <P>y</P> </TD> </TR> <TR> <TD width="87"> <P> </P> <P>    …..</P> </TD> <TD width="64"> <P> </P> </TD> </TR> </TBODY> </TABLE> <P> </P> <P> </P> <P>Any pointers?</P> <P>Thanks</P> <P>Al</P> <P> </P> Mon, 24 Sep 2018 21:31:30 GMT https://communities.sas.com/t5/SAS-Programming/data-logic/m-p/498600#M132545 Almoha 2018-09-24T21:31:30Z Re: data logic https://communities.sas.com/t5/SAS-Programming/data-logic/m-p/498603#M132547 <P>Look at the MOD function in combination with the _N_ automatic variable. </P> <P> </P> <P> </P> <PRE><CODE class=" language-sas">flag='X'; if mod(_n_, 4) =0 then flag='Y'; </CODE></PRE> Mon, 24 Sep 2018 21:49:26 GMT https://communities.sas.com/t5/SAS-Programming/data-logic/m-p/498603#M132547 Reeza 2018-09-24T21:49:26Z