https://communities.sas.com/t5/SAS-Studio/Create-variable-with-multiple-conditions/m-p/639501#M9028 <P>Anything involving "different type of sport" is going to involve having a list or format that can assign every value of sport of encountered into a "type" category.</P> <P>So you might start with listing all of your sports and what category you want to use for each.</P> Mon, 13 Apr 2020 15:39:06 GMT ballardw 2020-04-13T15:39:06Z https://communities.sas.com/t5/SAS-Studio/Create-variable-with-multiple-conditions/m-p/639499#M9027 <PRE>data have; input Person_ID $ date Date9. Sport $ ; format date date9.; datalines; 1234 20FEB2020 Football 1234 20FEB2020 Basketball 1234 25FEB2020 Ski 1234 07SEP2020 Football</PRE><P>How would I create a variable that says 'Y' for line 1 and 4 because there is at least a 6 month difference between the two days; and 'Y' for line 3 because it is a different type of sport? I want 'N' if it is on the same day and has a different sport, 'Y' if it is on a different day and a different sport, and 'Y' if the same (or different) sport is played with a 6 month difference.&nbsp;</P> Mon, 13 Apr 2020 15:36:31 GMT https://communities.sas.com/t5/SAS-Studio/Create-variable-with-multiple-conditions/m-p/639499#M9027 mar0000 2020-04-13T15:36:31Z https://communities.sas.com/t5/SAS-Studio/Create-variable-with-multiple-conditions/m-p/639501#M9028 <P>Anything involving "different type of sport" is going to involve having a list or format that can assign every value of sport of encountered into a "type" category.</P> <P>So you might start with listing all of your sports and what category you want to use for each.</P> Mon, 13 Apr 2020 15:39:06 GMT https://communities.sas.com/t5/SAS-Studio/Create-variable-with-multiple-conditions/m-p/639501#M9028 ballardw 2020-04-13T15:39:06Z