topic Re: MODIFYING row values based on duplicate in SAS Programming

MODIFYING row values based on duplicate

TheNovice — Fri, 09 Oct 2020 06:20:21 GMT

Hi there,

hoping for a data step and proc sql solution please.

C_Date and E_date represent same date, different formats. Same for Memo date and m_date

my data has records where the memo_id is duplicated for 2 records because the M_date is equal to the next_date and the c_date.Unfortunately the time stamp in e_date is not specific. So I need the memo_id to only be available for the first/earliest record.

Original:

ID	TIME	C_DATE	e_date	next_date	MEMO_TYPE	memo_date	m_date	MEMO_ID
665	0	02-Sep-20	02SEP2020:00:00:00	03-Oct-20	MC	03-Oct-20	03OCT2020:12:56:02	4411047528
665	1	03-Oct-20	03OCT2020:00:00:00	08-Oct-20	MC	03-Oct-20	03OCT2020:12:56:02	4411047528

Outcome needed:

ID	TIME	C_DATE	e_date	next_date	MEMO_TYPE	memo_date	m_date	MEMO_ID
665	0	02-Sep-20	02SEP2020:00:00:00	03-Oct-20	MC	03-Oct-20	03OCT2020:12:56:02	4411047528
665	1	03-Oct-20	03OCT2020:00:00:00	08-Oct-20	.	.	.	.

Appreciate any and all direction.

Re: MODIFYING row values based on duplicate

PeterClemmensen — Fri, 09 Oct 2020 06:31:26 GMT

Is the data sorted by memo_ID? Or can the Memo_ID=4411047528 appear further down?

Re: MODIFYING row values based on duplicate

TheNovice — Fri, 09 Oct 2020 14:56:42 GMT

The data is sorted by ID, C_date and Memo_id. the memo_id would be a unique transaction. It will never appear for another ID

Re: MODIFYING row values based on duplicate

TheNovice — Fri, 16 Oct 2020 20:52:22 GMT

Hi Draycut,

Would you have a suggestion on this by any chance?

Regards,