🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 09-15-2020 09:40 AM
(593 views)
data have;
infile datalines;
input ID $6. code $ date $;
datalines;
AP9734 300 6/19/2019
AP9734 301 2/15/2020
run;
WANT:
ID code1 code2 date1 date1
AP9734 300 301 6/19/2019 2/15/2020
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
not sure why you want to do it, if it's for reporting purpose, you should look into proc report.
But anyways, here is a quick solution
data mrg;
merge have (obs=1 firstobs=1 rename=(code=code1 date=date1))
have (obs=2 firstobs=2 rename=(code=code2 date=date2));
by id;
run;
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
What if you have 3 or more values the same for id?
Is it always exactly 2?
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
not sure why you want to do it, if it's for reporting purpose, you should look into proc report.
But anyways, here is a quick solution
data mrg;
merge have (obs=1 firstobs=1 rename=(code=code1 date=date1))
have (obs=2 firstobs=2 rename=(code=code2 date=date2));
by id;
run;