topic filliong out missing data in SAS Programming

filliong out missing data

mauri0623 — Mon, 30 Sep 2019 13:40:10 GMT

Please see the attachment.

Re: filliong out missing data

Kurt_Bremser — Mon, 30 Sep 2019 13:54:51 GMT

You can join on the common column, or you can create formats from the columns in the wide dataset, or you can load the wide dataset into a hash object. It depends on dataset sizes and how you process the "small" dataset.

Re: filliong out missing data

PeterClemmensen — Mon, 30 Sep 2019 14:03:42 GMT

data table1;
input ALC $ 1-21 TAS $ 10-23 ODN $ 25-41 FundingCode $ 43-48;
datalines;
89000001 08919/200243   89303019SEA000002 20EA01
89000001 089X0243       89303019SAU000016 20AU01
89000001 089-17/20-0321 89243419SEE000038 20GO01
89000001 089-17/20-0243 89303019SLM000012 20LM01
89000001 089-X-0319     89243219SNE000007 20ID01
;

data table2;
input ALC $ 1-21 TAS $ 10-23 ODN $ 25-41 FundingCode $ 43-48;
datalines;
                                          20EA01
                                          20AU01
                                          20GO01
                                          20LM01
                                          20ID01
;

data want(drop=rc);
    if _N_=1 then do;
        declare hash h(dataset:'table1');
        h.definekey('FundingCode');
        h.definedata('ALC', 'TAS', 'ODN');
        h.definedone();
    end;

    set table2;

    rc=h.find();
run;