I am reading several files into 1 dataset, using a wildcard for the last 8 positions. Now I want to determine these 8 positions, to be also written to my output. My input files are: payments_20240110 payments_20240209 payments_20240309 etc ... So my code is: data overview; set payments:; run; How do I add a column 'payment_date' to my output? I have been struggling with 'SCAN' function, but I don't get it...
... View more