Hello SAS.
I need some help with following situation :
I have two tables :
NOCONT | prod | DPD_0 | DPD0 | CDSITC1 | DAT_REST | STARE1 | TOTAL11 | DPD_1 | DPD WCS | DPD1 | Scadenta |
500338833 | CR | 0 | B0. 0 | 1 | 20181015 | A | 2925.076 | 9 | 39 | B1. 1-30 | 22 |
and
NOCONT | DTCSTS03 |
5416257158 | 20180718 |
500338833 | 20180731 |
I want to add DTCSTS03 from second table to equivalent NOCONT in first table , also I need a modify the structure and format of DTCSTS03
I want to modify from 20180731 to 07/31/2018 and to replace de 31 with value of scadenta column.
in excel I use vlookup and DATE(LEFT(A2,4),RIGHT(LEFT(A2,6),2),RIGHT(A2,2)) date formula to make those changes , In SAS I didn't manage to create something near close.
Thank you in advance