topic Re: Producing Report in New SAS User https://communities.sas.com/t5/New-SAS-User/Producing-Report/m-p/608493#M17683 <P><A href="https://video.sas.com/detail/video/4573016761001/filtering-a-sas-table-in-a-data-step?autoStart=true&amp;q=Filter%20data%20step" target="_blank">https://video.sas.com/detail/video/4573016761001/filtering-a-sas-table-in-a-data-step?autoStart=true&amp;q=Filter%20data%20step</A><BR /><BR /></P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/134135">@swayto</a>&nbsp;wrote:<BR /> <P>Obs League Division Team Div123456</P> <TABLE> <TBODY> <TR> <TD>National</TD> <TD>West</TD> <TD>Atlanta</TD> <TD>NW</TD> </TR> <TR> <TD>American</TD> <TD>East</TD> <TD>Baltimore</TD> <TD>AE</TD> </TR> <TR> <TD>American</TD> <TD>East</TD> <TD>Boston</TD> <TD>AE</TD> </TR> <TR> <TD>American</TD> <TD>West</TD> <TD>California</TD> <TD>AW</TD> </TR> <TR> <TD>American</TD> <TD>West</TD> <TD>Chicago</TD> <TD>AW</TD> </TR> <TR> <TD>National</TD> <TD>East</TD> <TD>Chicago</TD> <TD>NE</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>How do i get the value variable Div for observation that has variable Team=Boston?</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Sat, 30 Nov 2019 21:32:17 GMT Reeza 2019-11-30T21:32:17Z Producing Report https://communities.sas.com/t5/New-SAS-User/Producing-Report/m-p/608486#M17681 <P>Obs League Division Team Div123456</P><TABLE><TBODY><TR><TD>National</TD><TD>West</TD><TD>Atlanta</TD><TD>NW</TD></TR><TR><TD>American</TD><TD>East</TD><TD>Baltimore</TD><TD>AE</TD></TR><TR><TD>American</TD><TD>East</TD><TD>Boston</TD><TD>AE</TD></TR><TR><TD>American</TD><TD>West</TD><TD>California</TD><TD>AW</TD></TR><TR><TD>American</TD><TD>West</TD><TD>Chicago</TD><TD>AW</TD></TR><TR><TD>National</TD><TD>East</TD><TD>Chicago</TD><TD>NE</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>How do i get the value variable Div for observation that has variable Team=Boston?</P> Sat, 30 Nov 2019 20:58:30 GMT https://communities.sas.com/t5/New-SAS-User/Producing-Report/m-p/608486#M17681 swayto 2019-11-30T20:58:30Z Re: Producing Report https://communities.sas.com/t5/New-SAS-User/Producing-Report/m-p/608493#M17683 <P><A href="https://video.sas.com/detail/video/4573016761001/filtering-a-sas-table-in-a-data-step?autoStart=true&amp;q=Filter%20data%20step" target="_blank">https://video.sas.com/detail/video/4573016761001/filtering-a-sas-table-in-a-data-step?autoStart=true&amp;q=Filter%20data%20step</A><BR /><BR /></P> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/134135">@swayto</a>&nbsp;wrote:<BR /> <P>Obs League Division Team Div123456</P> <TABLE> <TBODY> <TR> <TD>National</TD> <TD>West</TD> <TD>Atlanta</TD> <TD>NW</TD> </TR> <TR> <TD>American</TD> <TD>East</TD> <TD>Baltimore</TD> <TD>AE</TD> </TR> <TR> <TD>American</TD> <TD>East</TD> <TD>Boston</TD> <TD>AE</TD> </TR> <TR> <TD>American</TD> <TD>West</TD> <TD>California</TD> <TD>AW</TD> </TR> <TR> <TD>American</TD> <TD>West</TD> <TD>Chicago</TD> <TD>AW</TD> </TR> <TR> <TD>National</TD> <TD>East</TD> <TD>Chicago</TD> <TD>NE</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>How do i get the value variable Div for observation that has variable Team=Boston?</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Sat, 30 Nov 2019 21:32:17 GMT https://communities.sas.com/t5/New-SAS-User/Producing-Report/m-p/608493#M17683 Reeza 2019-11-30T21:32:17Z