Hi @SASKiwi,
Sorry for not including the datalines. Basically I want the 'Path' column to be deduped into a single line only. That is from:
m01, m02, m03 --> To: mXX
/sas/table_new_20210301.sas7bdat, /sas/table_new_20210302.sas7bdat --> /sas/table_new_YYYYMMDD.sas7bdat
Below are the datalines for reference:
DATA HAVE;
INFILE DATALINES DELIMITER=',' DSD;
INPUT id PATH & $50. REMARK & $50. ;
DATALINES;
1, "/sas/table_hist_m01.sas7bdat", "Keep but rename _m01 to mXX"
2, "/sas/table_hist_m02.sas7bdat", "Remove"
3, "/sas/table_hist_m03.sas7bdat", "Remove"
4, "/sas/table_hist_m04.sas7bdat", "Remove"
5, "/sas/ww0.sas7bdat", "Keep, no change due to single table"
6, "/sas/table_new_20210301.sas7bdat", "Keep, but rename _20210301 to _YYYYMMDD"
7, "/sas/table_new_20210302.sas7bdat", "Remove"
8, "/sas/table_new_20210303.sas7bdat", "Remove"
9, "/sas/table_new_20210304.sas7bdat", "Remove"
RUN;
DATA WANT;
INFILE DATALINES DELIMITER=',' DSD;
INPUT id PATH & $50.;
DATALINES;
1, "/sas/table_hist_mXX.sas7bdat"
2, "/sas/ww0.sas7bdat"
3, "/sas/table_new_YYYYMMDD.sas7bdat"
RUN;
... View more