I have two distinct questions. One question is about how to convert a = today(); to be formatted as 08212019.   Question 2 is about how to make table two from table one. Project_number could have > 1 task_number. I want to be able to fill the missing project_number by the previous one.   Table 1       project_number Task_number customer Bill_amt 97008003 693WHSOTN0001 097-WASHINGTON HEADQUARTERS SERVICES-DODH91268 100000 97008880 693DSCAOTN0002 097-DEFENSE SECURITY COOPERATION AGENCY-DODHQ0013 100000 3572599 693DCPSOTN0003 DISTRICT OF COLUMBIA PUBLIC SCHOOLS 50000   693DCPSOTN0003_NREV DISTRICT OF COLUMBIA PUBLIC SCHOOLS   97008003 693WHSOTN0001 097-WASHINGTON HEADQUARTERS SERVICES-DODH91268 200000 97008880 693DSCAOTN0002 097-DEFENSE SECURITY COOPERATION AGENCY-DODHQ0013 200000 3572599 693DCPSOTN0003 DISTRICT OF COLUMBIA PUBLIC SCHOOLS 670000   693DCPSOTN0003_NREV DISTRICT OF COLUMBIA PUBLIC SCHOOLS   97008003 693WHSOTN0001 097-WASHINGTON HEADQUARTERS SERVICES-DODH91268 300000 97008880 693DSCAOTN0002 097-DEFENSE SECURITY COOPERATION AGENCY-DODHQ0013 300000 3572599 693DCPSOTN0003 DISTRICT OF COLUMBIA PUBLIC SCHOOLS 80000   693DCPSOTN0003_NREV DISTRICT OF COLUMBIA PUBLIC SCHOOLS           Table 2       project_number Task_number customer Bill_amt 97008003 693WHSOTN0001 097-WASHINGTON HEADQUARTERS SERVICES-DODH91268 100000 97008880 693DSCAOTN0002 097-DEFENSE SECURITY COOPERATION AGENCY-DODHQ0013 100000 3572599 693DCPSOTN0003 DISTRICT OF COLUMBIA PUBLIC SCHOOLS 50000 3572599 693DCPSOTN0003_NREV DISTRICT OF COLUMBIA PUBLIC SCHOOLS   97008003 693WHSOTN0001 097-WASHINGTON HEADQUARTERS SERVICES-DODH91268 200000 97008880 693DSCAOTN0002 097-DEFENSE SECURITY COOPERATION AGENCY-DODHQ0013 200000 3572599 693DCPSOTN0003 DISTRICT OF COLUMBIA PUBLIC SCHOOLS 670000 3572599 693DCPSOTN0003_NREV DISTRICT OF COLUMBIA PUBLIC SCHOOLS   97008003 693WHSOTN0001 097-WASHINGTON HEADQUARTERS SERVICES-DODH91268 300000 97008880 693DSCAOTN0002 097-DEFENSE SECURITY COOPERATION AGENCY-DODHQ0013 300000 3572599 693DCPSOTN0003 DISTRICT OF COLUMBIA PUBLIC SCHOOLS 80000 3572599 693DCPSOTN0003_NREV DISTRICT OF COLUMBIA PUBLIC SCHOOLS   ... View more

DAI and PIPS are two SAS datasets. PIPS could have missing values for the variables ALC, ODN, LOA, and TAS. We want to lookup the DAI dataset and populate the missing variables from PIPS. We have 8 different Scenarios as stated on the attached document. I have created the below code that takes care of the scenario 1 and 5. However I am stocked on other scenarios. We don't have to use hash merging necessarily. Anything that can cover the scenarios is fine with me. Your help is highly and professionally appreciated.   Best Regards, Mauri Esfandiari   My code for scenarios 1 and 5 is below,   /**************************************************** Use the SAS has merge to find the matches between the two tables and if they match place them in the PIPS_DAI_Match table and if they don't then place them in the table Error_File. ****************************************************/ data sas_perm.PIPS_DAI_Match sas_perm.Error_File(drop=rc); if 0 then set work.pips_no_sudo; if _N_ = 1 then do; declare hash h(dataset:'work.dai_fixed'); h.defineKey('ipac'); h.defineData('OBLIGATING_DOC_NO', 'accounting', 'tas');   h.defineDone(); call missing(OBLIGATING_DOC_NO, accounting, tas); end;     set work.dai_fixed;   rc=h.find(); if rc then output sas_perm.PIPS_DAI_Match; else output sas_perm.Error_file; run;   ... View more

I need to create a SAS timestamp starting not with today() but starting with May 01, 2019. Please help if you can.   Thank you! ... View more

This will be my last question to ask for today.   I have the following dataset,       ALC           ODN  7007001    GA0131a  7007002    KA0131a  7007120    ZZ0131a  7003120    DA0131a  5689020    CA0131a  4738590    PB0131a  8302345    GA0131b  8302345   ZZ0131a  8302345   DA0131a  8302345   ZZ0131a  5790234   KK1Y90                   KFGG80                  This is where a single ALC has multiple ODNs 5892034   ZZZ1809                   ZZB1809                   MMN09                  CVGqQ2                  GXPPO0  I need to see when I have the same ALC but multiple ODNs to place those in a dataset called Exceptions.   Thank you and have a great weekend.   -mauri   ... View more

I have merged two table together for the purpose of table lookup. I want the pips dataset to lookup the dai_fixed dataset for the variables task_number, loa, and tas. The code does that. What else I want the code to do is if it find the match I want it to place it in a pips_dai_match and if not place it in another dataset called error. Below is the code.   data PIPS_DAI_Match(drop=rc); if 0 then set work.dai_fixed; if _N_ = 1 then do; declare hash h(dataset:'work.dai_fixed'); h.defineKey('project_number'); h.defineData('task_number', 'loa', 'tas');   h.defineDone(); call missing(task_number, loa, tas); end;     set pips;     rc=h.find(); run;   ... View more

Hello,   when I sum a variable called transaction I get $18,964,936. I want this number to be $18,964,935.59. This is because the people that use excel to obtain this sum they come up with $18,964,935.59 and not $18,964,936. So I am 42 cent short and I am being blamed.   Thank you!   -mauri ... View more