See below for my code. There may be more than one row/entry per application. I would like to get the following result: If the 1st entry has DecDecision = 1001 and DecPos=1, then I want SAS to look at the 2nd row/entry (for the same application). If the 2nd entry has DecDecision=1 and DecPos=2, then stamp the application as SYSTEM. So, for every row/entry associated with the application, another column would state SYSTEM. If the 1st entry has DecDecision = 1001 and DecPos=1, then I want SAS to look at the 2nd row/entry (for the same application). If the 2nd entry has DecDecision=2 and DecPos=2, then stamp the application as SYSTEM. So, for every row/entry associated with the application, another column would state SYSTEM. If the 1st entry has DecDecision = 1001 and DecPos=1, then I want SAS to look at the 2nd row/entry (for the same application). If the 2nd entry has DecDecision=4 and DecPos=2, then stamp the application as SYSTEM. So, for every row/entry associated with the application, another column would state SYSTEM. ELSE "Manual" When I run the code below the results were multiplied because of the inner join. In other words, for each row from T1, it is multiplied by the number of rows in T2 (for that application). Also, the results labeled SYSTEM for the row that had the DECPOS=1. But the row with DECPOS=2 had “Manual”. I would like for SAS to show SYSTEM for all rows associated with the same application. Any thoughts or help is appreciated! *************************************** PROC SQL; CREATE TABLE last_dcsn_sys_manual AS SELECT DISTINCT t1.APPLICATION_ID, t1.C_DECISION_NM, t1.DCSN_USER_NM, t1.DECDECISION, t1.DECTIME, t1.DECPOS, CASE WHEN (t1.DECDECISION=1001 and t1.DECPOS=1 and t2.DECDECISION=1 and t2.DECPOS=2)THEN "System" WHEN (t1.DECDECISION=1001 and t1.DECPOS=1 and t2.DECDECISION=4 and t2.DECPOS=2)THEN "System" ELSE "Manual" END AS SYS_MANUAL FROM decision_1 t1 INNER JOIN decision_2 t2 ON (t1.APPLICATION_ID = t2.APPLICATION_ID) ORDER BY t1.APPLICATION_ID, t1.DECPOS;
... View more