Re-Assigning records into groups in SAS

[ja01]

/*Print the report_log2 report, choosing variables
proc print data=test_log2;
run;

/*Use group count by rloguser */
/*Order=freq means sort descending*/
proc freq data=test_log2 order=freq;
tables rloguser;
run;

What I am trying to do is say that if the rloguser = 'Smith' then put him in the Group A, If rloguser = 'Jones' then put in group B. Right now I get a list of rlogusers in descending order which I asked for. Now I want to group them and reassign them to group names

 

[ChrisW75]

Just use a data step.

 data testlog3;
   set testlog2;

   if rloguser = 'Smith' then group = 'A';
   else if reloguser = 'Jones' then group = 'B';
   ...
   ...
 run;