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
... View more