Hi,   I'm using SAS Universitiy Edition. Can anyone guide me how to write this in data step based on condition below:   If any employee get appl = 'P' and n_indi = 'In' then will be tagged as 'A1' under new_ind. (A1 repeat for subsequent row under same name) If any employee get appl = 'P' and n_indi = 'Co' then will be tagged as 'A2' under new_ind.  (A2 repeat for subsequent row under same name)   My Output:    employee_name appl n_indi new_ind 1 AAA P Co A2 2 AAA Gu In N 3 AAA Gu In N 4 BBB P In A1 5 BBB Gu In N 6 BBB Gu In N 7 CCC P Co A2 8 CCC P Co N 9 DDD P In A1 10 DDD Gu In N 11 EEW Gu In N   Desired Output:   employee_name appl n_indi new_ind 1 AAA P Co A2 2 AAA Gu In A2 3 AAA Gu In A2 4 BBB P In A1 5 BBB Gu In A1 6 BBB Gu In A1 7 CCC P Co A2 8 CCC P Co A2 9 DDD P In A1 10 DDD Gu In A1 11 EEW Gu In Error   My script   data employee; input employee_name $ appl $ n_indi $; datalines; AAA Gu In AAA P Co AAA Gu In BBB Gu In BBB P In BBB Gu In CCC P Co CCC P Co DDD P In EEE Gu In FFF Gu In ; run; proc sort data= employee out= employee2; by employee_name descending appl ; run; data employee3; set employee2; by employee_name descending appl; if first.employee_name and appl = 'P' and n_indi = 'Co' then new_ind = 'HPA2' ; else if appl = 'P' and n_indi = 'In' then new_ind = 'HPA1' ; retain new_ind; else new_ind = 'N'; ;run;   ... View more

Hi All,   How do I join two tables using PROC SQL if one of my field containing both character and numeric?   Sample dataset   Table 1   Book_number Identification_nbr Checkout ABC 00005 Y ABC 00004A Y BU 881123-01-1234 Y BU 1/123332 Y C 001 Y   Table 2     Book_number Identification_nbr Age ABC 5 1 ABC 00004A 2 BU 881123-01-1234 3 BU 1/123332 4 C 1 6   Desired result:   Book_number Identification_nbr Checkout Age ABC 00005 Y 1 ABC 00004A Y 2 BU 881123-01-1234 Y 3 BU 1/123332 Y 4 C 001 Y 6     Table 2 extracted identification_nbr from table 1 initially but after processing, the 0000 in front missing. I was unable to join both tables because Identification_nbr defined as character in table 1 and table 2.   ... View more

Hi,   Can anyone help me to understand why the final output x= 5 index = 7 appear?   Code: data work.loop; x = 0; do index = 1 to 5 by 2; x = index; output; end; output; run;  Output:  ... View more