https://communities.sas.com/t5/New-SAS-User/Creating-new-variables-by-grouping-existing-variable/m-p/694742#M25143 <P>Not clear how the result should look like, please explain.</P> Wed, 28 Oct 2020 05:59:02 GMT andreas_lds 2020-10-28T05:59:02Z https://communities.sas.com/t5/New-SAS-User/Creating-new-variables-by-grouping-existing-variable/m-p/694741#M25142 <P>Hi</P><P>I have a dataset that has variables such as basketball baseball football swimming chess softball. I want to&nbsp;categorize the various sports under “high” or “low” risk sport under a new variable risklevel; basketball baseball football=high and&nbsp;swimming chess softball=low.</P><P>&nbsp;</P><P>dataset looks something like below</P><P>&nbsp; &nbsp; &nbsp;basketball baseball football swimming chess softball</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; 1</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 0&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1</P><P>&nbsp;</P><P>Any help is greatly appreciated!</P><P>&nbsp;</P> Wed, 28 Oct 2020 05:55:20 GMT https://communities.sas.com/t5/New-SAS-User/Creating-new-variables-by-grouping-existing-variable/m-p/694741#M25142 nematullah17 2020-10-28T05:55:20Z https://communities.sas.com/t5/New-SAS-User/Creating-new-variables-by-grouping-existing-variable/m-p/694742#M25143 <P>Not clear how the result should look like, please explain.</P> Wed, 28 Oct 2020 05:59:02 GMT https://communities.sas.com/t5/New-SAS-User/Creating-new-variables-by-grouping-existing-variable/m-p/694742#M25143 andreas_lds 2020-10-28T05:59:02Z