https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552784#M153700 Let's suppose we have a large data containing airline information like<BR />airline name, depart time, arrival time and now from airline name we have<BR />to categorize data into two group like jet Airways and air india<BR />information in group A and other airline information in group B<BR /><BR />Hope now it's understandable<BR /><BR />Thanks,<BR />Manoj Ahuja<BR /> Mon, 22 Apr 2019 11:15:18 GMT Manojahuja1418 2019-04-22T11:15:18Z https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552758#M153688 How to categorize the data into two group in sad? For example if we have dataset for airline so how we categorize the data into two group; one group for jet Airways and air india and second group for all other airlines?<BR /><BR />Please help Mon, 22 Apr 2019 06:24:56 GMT https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552758#M153688 Manojahuja1418 2019-04-22T06:24:56Z https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552761#M153691 <P>You already categorized your data into two groups:</P> <P>&nbsp;&nbsp;<STRONG><SPAN>one group for jet Airways and air india and second group for all other airlines</SPAN></STRONG></P> <P>&nbsp;</P> <P>It is not clear what do you want.</P> <P>If you can identify the group inside your data,</P> <P>then you can add a flag or a category variable with appropriate value,</P> <P>like 1 or 0, "Jet" or " ", etc.</P> Mon, 22 Apr 2019 06:41:48 GMT https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552761#M153691 Shmuel 2019-04-22T06:41:48Z https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552764#M153693 Thanks for replying so quickly<BR /><BR />But do you please help me with coding also, as I have a data and in the<BR />given data set I need to categorize the data into two group group 1 for jet<BR />airways and air india only and group 2 for all other airlines,<BR />Thanks<BR /> Mon, 22 Apr 2019 07:04:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552764#M153693 Manojahuja1418 2019-04-22T07:04:18Z https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552765#M153694 <P>Can you supply a test data with both categories data, and define the rules how</P> <P>to distinguish between the groups - what variables to check for what values ?</P> Mon, 22 Apr 2019 07:09:42 GMT https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552765#M153694 Shmuel 2019-04-22T07:09:42Z https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552784#M153700 Let's suppose we have a large data containing airline information like<BR />airline name, depart time, arrival time and now from airline name we have<BR />to categorize data into two group like jet Airways and air india<BR />information in group A and other airline information in group B<BR /><BR />Hope now it's understandable<BR /><BR />Thanks,<BR />Manoj Ahuja<BR /> Mon, 22 Apr 2019 11:15:18 GMT https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552784#M153700 Manojahuja1418 2019-04-22T11:15:18Z https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552793#M153701 <P>You asked for a code, but you did not gave any example of input (few lines) nor of the rules of</P> <P>how to decide to which category should be.</P> <P>&nbsp;</P> <P>Your note is&nbsp;<STRONG><SPAN>&nbsp;"from airline name we have&nbsp;</SPAN><SPAN>to categorize data" -</SPAN></STRONG></P> <P>can you supply airline names and define their categories?</P> <P>&nbsp;</P> <P>&nbsp;</P> Mon, 22 Apr 2019 11:39:55 GMT https://communities.sas.com/t5/SAS-Programming/How-to-categorize-the-data-into-two-group/m-p/552793#M153701 Shmuel 2019-04-22T11:39:55Z