G'day. Appreciate any help you can give.   I've a file named fileA that has a unique identifying variable facility_code, no duplicates and it has variableX that I need to populate in fileB for certain years.   I've a second file named fileB (combined years of data) with the  facility_code listed once for each year so since the file which has 7 years worth of data, if the facility reported information each year, it will  be listed 7 times.  It may not have reported each of the years, only some. fileB is missing data for variable X in years 2020-21 through 2023-24.   I have a variable in fileA named variableX I want to populate in fileB for only 4 of the seven school years (2020-21, 2021-22, 2022-23, 2023-24).   How do i update fileB, specifically variable X only for the four school years with the information  in FileA matched on facility_code for variable X only for specific school years?  I only know how to update the file if it is a one to one relationship in each file, for example if the facilty_code is listed only once in fileZ, code below, I know how to update it with the information in fileA (2nd SAS code window below).   thanks! DATA fileA; INPUT facility_code $ facility_type$ physical_zip$ variableX schoolyr$; CARDS; 1234567 public 14524 Yes 2019-20 1234568 public 23561 No 2019-20 1234569 public 84972 No 2019-20 0234567 public 94801 Yes 2019-20 0234568 public 89024 No 2019-20 0234569 public 28201 No 2019-20 ; RUN; DATA fileB; INPUT facility_code $ status$ facility_type$ physical_zip$ variableX schoolyr$; CARDS; 1234567 active public 14524 Yes 2017-18 1234567 closed public 14524 Yes 2018-19 1234567 active public 14524 No 2017-18 1234567 closed public 14524 . 2021-22 1234568 active public 23561 Yes 2017-18 1234568 active public 23561 Yes 2018-19 1234568 active public 23561 Yes 2019-20 1234568 active public 23561 . 2020-21 1234568 active public 23561 . 2021-22 1234568 active public 23561 . 2022-23 1234568 active public 23561 . 2023-24 1234568 active public 23561 . 2018-19 1234569 closed public 84972 . 2020-21 1234569 closed public 84972 . 2021-22 1234569 closed public 84972 . 2022-23 1234569 closed public 84972 . 2023-24 0234567 active public 94801 . 2021-22 0234568 active public 89024 . 2022-23 0234569 active public 28201 . 2023-24 ; RUN; DATA want; INPUT facility_code $ status$ facility_type$ physical_zip$ variableX $ schoolyr$; CARDS; 1234567 active public 14524 Yes 2017-18 1234567 closed public 14524 Yes 2018-19 1234567 active public 14524 No 2017-18 1234567 closed public 14524 Yes 2021-22 1234568 active public 23561 Yes 2017-18 1234568 active public 23561 Yes 2018-19 1234568 active public 23561 No 2019-20 1234568 active public 23561 No 2020-21 1234568 active public 23561 No 2021-22 1234568 active public 23561 No 2022-23 1234568 active public 23561 No 2023-24 1234568 active public 23561 No 2018-19 1234569 closed public 84972 No 2020-21 1234569 closed public 84972 No 2021-22 1234569 closed public 84972 No 2022-23 1234569 closed public 84972 No 2023-24 0234567 active public 94801 Yes 2021-22 0234568 active public 89024 No 2022-23 0234569 active public 28201 No 2023-24 ; RUN;   data transaction; set fileA (keep=facility_code variableX); run; *--sort transaction; proc sort data=transaction; by facility_code; run; *--sort list to be updated; proc sort data=fileZ; by facility_code; run; *-update; data updatedZ; update fileZ transaction updatemode=missingcheck; by facility_code; run;   ... View more

G'day,   I've a question -- I'm trying to find observations below a certain cutoff value across any four years for the same ID.   Here's the data below and what I tried.  I realized it doesn't work.  what i want is to have identify in  a list that has ids which are below 90 for any four years (Yr), something like the table below.  Any help you can give is much appreciated. Or is there a better way to do it in proc sql?  Can this be done in the DATA step? Thank you!   id pctvax2000 pctvax2001 pctvax2002 pctvax2003 pctvax2004 pctvax2005 pctLT90_2000 pctLT90_2001 pctLT90_2002 pctLT90_2003 pctLT90_2004 pctLT90_2005 any4 1234567 88 90 57 95 77 62 1 0 1 0 1 1 4 1234568 82 91 53 78 90 95 1 0 1 1 0 0 5   *--2017-18 ; DATA vax; INPUT id $ pctvax yr $; CARDS; 1234567 88 2000 1234567 90 2001 1234565 57 2002 1234567 95 2003 1234567 77 2004 1234567 62 2005 1234568 82 2000 1234568 91 2001 1234568 53 2002 1234568 78 2003 1234568 90 2004 1234568 45 2005 ; RUN; data vax1; set vax; if yr='2000' then do; pctvax2000=pctvax; if pctvax2000<90 then pctLT90_2000=1; end; if yr='2001' then do; pctvax2001=pctvax; if pctvax2001<90 then pctLT90_2001=1; end; if yr='2002' then do; pctvax2002=pctvax; if pctvax2002<90 then pctLT90_2002=1; end; if yr='2003' then do; pctvax2003=pctvax; if pctvax2003<90 then pctLT90_2003=1; end; if yr='2004' then do; pctvax2004=pctvax; if pctvax2004<90 then pctLT90_2004=1; end; if yr='2005' then do; pctvax2005=pctvax; if pctvax2005<90 then pctLT90_2005=1; end; if sum(pctLT90_2000, pctLT90_2001, pctLT90_2002, pctLT90_2003, pctLT90_2004, pctLT90_2005)=4 then any4=1; else any4=0; run;   ... View more