I am using Table 1 to update the missing values in Table 2 as most of the actual values don't exist in Table 2. But I only want to replace the missing values in Table 2 if missing and retain the values if not missing. I am using hash for processing as it's a large table. Is there a way to do this with a hash statement? Thanks ... View more

Sorry for the confusion. Let me try again: Table 1 is the table I am using to update/merge the missing values in Table 2.                                 Table 3 is what I get as the result. The values from Table 1 replaces the values on Table 2.  How can I only update values if missing on Table 2? In this instance ID# 1, 2, 4 and 6 will be retained after the merge.                         Table 4 is what I want.  Thank you  Table 1          ID# Date Gender Code Class 1 . F AB LOW 2 . F CD LOW 3 1/1/2021 M CD MIDDLE 4 . F CD MIDDLE 5 7/10/2020 M AB LOW 6 . M DE HIGH 7 3/1/2019 F AB HIGH 8 5/2/2017 F AB HIGH   Table 2         ID# Date Gender Code Class 1 7/1/2020 F AB   2 7/2/2020 F     3   M   MIDDLE 4 1/2/2021     MIDDLE 5   M AB   6 7/11/2020 M   HIGH 7     AB   8     AB HIGH   Table 3          ID# Date Gender Code Class 1 . F AB LOW 2 . F CD LOW 3 1/1/2021 M CD MIDDLE 4 . F CD MIDDLE 5 7/10/2020 M AB LOW 6 . M DE HIGH 7 3/1/2019 F AB HIGH 8 5/2/2017 F AB HIGH   Table 4         ID# Date Gender Code Class 1 7/1/2020 F AB LOW 2 7/2/2020 F CD LOW 3 1/1/2021 M CD MIDDLE 4 1/2/2021 F CD MIDDLE 5 7/10/2020 M AB LOW 6 7/11/2020 M DE HIGH 7 3/1/2019 F AB HIGH 8 5/2/2017 F AB HIGH ... View more

Correction Below is what I Have and the output I am getting on my Need_Update dataset   Have         ID# Date Gender Code Class 1 . F AB LOW 2 . F CD LOW 3 1/1/2021 M CD MIDDLE 4 . F CD MIDDLE 5 7/10/2020 M AB LOW 6 . M DE HIGH 7 3/1/2019 F AB HIGH 8 5/2/2017 F AB HIGH   Need_Update        ID# Date Gender Code Class 1 7/1/2020 F AB LOW 2 7/2/2020 F CD LOW 3   M CD MIDDLE 4 1/2/2021 F CD MIDDLE 5   M AB LOW 6 7/11/2020 M DE HIGH 7   F AB HIGH 8   F AB HIGH ... View more

I have multiple vars I am attempting to update. For the Date var I only want to update where it's missing. Below is the code I am using and the result I get. How can I update all the vars and only the instance where the Date is missing? Thanks   data Want; drop rc; length Flag $35 Comment $35; if _n_=1 then do; declare hash lookup(dataset:"Have"); lookup.defineKey("ID"); lookup.defineData("Date" ,"Gender" ,"Code" ,"Class" ,"Flag" ,"Comment"); lookup.definedone(); call missing(Flag,Comment); end; set Need_Update; rc=lookup.find(); run;   Have                     ID# Date Gender Code Class 1 . F AB   2 . F     3 1/1/2021 M   MIDDLE 4 .     MIDDLE 5 7/10/2020 M AB   6 . M   HIGH 7 3/1/2019   AB   8 5/2/2017   AB HIGH   Want                   ID# Date Gender Code Class 1 7/1/2020 F AB LOW 2 7/2/2020 F CD LOW 3 1/1/2021 M CD MIDDLE 4 1/2/2021 F CD MIDDLE 5 7/10/2020 M AB LOW 6 7/11/2020 M DE HIGH 7 3/1/2019 F AB HIGH 8 5/2/2017 F AB HIGH   What I am getting       ID# Date Gender Code Class 1 7/1/2020 F AB LOW 2 7/2/2020 F CD LOW 3   M CD MIDDLE 4 1/2/2021 F CD MIDDLE 5   M AB LOW 6 7/11/2020 M DE HIGH 7   F AB HIGH 8   F AB HIGH ... View more

OKay----where in the hash statement will this be declared? Below is the syntax I am using. Thanks! data ; drop rc; length ; if _n_=1 then do; declare hash lookup(dataset:""); lookup.defineKey(""); lookup.defineData(""); lookup.definedone(); call missing(); end; set ; rc=lookup.find(); run; ... View more

Thank you! This worked to convert the dates! ... View more

Thank you! ... View more

Hi,   How can I create a macro variable for the prior year, current year and future year. The prior year will be the current year minus one year, future year will be the current year plus one year. So it will look something like this   %let cy= 2020 %let fy = &cy+1 (2021) %let py = &cy-1 (2019)   Thanks! ... View more