Hello to all,
I've run into an issue that I need a bit of help with.
I have a table that has a ID, ONum, notes columns.
What i'm trying to do concatenate every notes obs into one obs based on similer
ID & ONum with a space inbetween every concatenation.
ID ONum notes
-- --------- ----------
11 10001 "This is a Test"
11 10001 " of SAS"
11 10002 "Today the weather was good"
11 10002 "Busy Shopping"
44 19999 "Fishing"
55 77777 "Working on car"
55 77777 "Hunting"
55 77777 "Swimming"
After data step I need the data to look like this
ID ONum notes
-- --------- ----------
11 10001 "This is a Test of SAS"
11 10002 "Today the weather was good Busy Shopping"
44 19999 "Fishing"
55 77777 "Working on car Hunting Swimming"
Thank you to anyone who can help