Hi,   I have a query related to SAS code.   I have two data sets : A and B   dataset A   Location          ID loc1                  1,2 loc2                  3 loc3                   4   dataset B   ID    Target        Condition      Process 2      A1                c1               T1 1      A2                c2               T2 3      A3                c3               T3 4      A4                c4                T4 5      A5                Default         T5 6      A6                Default         T6   Here in the dataset A , I would like to look for ID corresponding to each location. Say, for loc1 there are two id's 1 and 2. So i would like to create a condition (if condition ) from dataset B which corresponds to ID 1 and 2.   if location in (" loc1") then do; if (c1) then A1= T1; if (C2) then A2= T2;   Right now i have a macro cplan which creates the condition {if location in (" loc1") } for all the records in the datasetA and the macro pullstring which creates the condition (if (c1) then A1= T1;) for all records in the dataset B but how do i correlate two ?   Below code generates all the conditions from B for each condition of A but I need only those condition specific to ID's from B ..It will be great if you can guide me on how to do that %MACRO LOOP; %cplan; %pullstring; data _null_; %DO I=1 %TO &count;/* count is the number of records in A*/ &&condition&i then do;                               /* condition from dataset A*/ %DO j=1 %TO &map_count;/*map_count is the number of records in B*/ &&map&j;              /* condition from dataset B*/ %END; end; %END; run; %MEND LOOP; %LOOP;     Any help will be greatly appreciated. Thanks in advance, Sheeba ... View more

Hi, I am planning to take SAS DI certification. I have been working on SAS DI for  some time. I have gone through the user guide from SAS It ill be great if  you can suggest  training materials/books/websites for ‘SAS Certified Data Integration Developer for SAS 9http://support.sas.com/certify/creds/did.html‘ exam ? Thanks in advance, Regards, Sheeba Swaminathan ... View more