topic Re: Merge in SAS Programming

Merge

art_srap — Sun, 12 Apr 2020 11:44:36 GMT

Hi SAS experts, could you tell me what is the problem? because the merge didn't work.Thanks for any help.

Re: Merge

PaigeMiller — Sun, 12 Apr 2020 11:53:43 GMT

Most of us will not click on a link such as the one you provide. Please post data, code and your SAS log as text by pasting it into the window that appears when you click on the </> icon. This helps keep formatting correct and readable.

Re: Merge

art_srap — Sun, 12 Apr 2020 12:00:29 GMT

ok, thank you.

Merge

art_srap — Sun, 12 Apr 2020 12:03:28 GMT

Hi SAS experts, could you tell me what is the problem? because the merge didn't work.Thanks for any help.

data DTC1;
input ID EVENT: $11. AESTDTC: $16.;
format AESTDTC1 yymmdd10.;
AESTDTC1=input(AESTDTC,yymmdd10.);
keep ID EVENT AESTDTC1;
datalines;
102 Vomit 2016-01-12T16:05
102 Headache 2016-01-19
103 Severepain 2016-02-17
102 Migraine 2016-02-18T02:00
103 Nausea 2016-02-19
;
proc sort data=DTC1;
by ID;
run;
data DTC2;
input ID RFSTDTC: $10.;
datalines;
102 2016-01-20
104 2016-01-05
103 2016-02-05
;
proc sort data=DTC1;
by ID;
run;
proc sort data=DTC2;
by ID;
run;
Data DTC3;
merge DTC1 DTC2;
by ID;
run;

Re: Merge

Ksharp — Sun, 12 Apr 2020 12:04:49 GMT

What is your log information ?

Re: Merge

Patrick — Sun, 12 Apr 2020 12:10:34 GMT

The merge works as it should and below what it returns. If this is not what you want then please explain what you're after and where below results differs.

Re: Merge

art_srap — Sun, 12 Apr 2020 12:10:42 GMT

in log everything is ok, but the output is wrong.

data DTC1;
input ID EVENT: $11. AESTDTC: $16.;
format AESTDTC1 yymmdd10.;
AESTDTC1=input(AESTDTC,yymmdd10.);
keep ID EVENT AESTDTC1;
datalines;
102 Vomit        2016-01-12T16:05 
102 Headache     2016-01-19 
103 Severepain   2016-02-17
102 Migraine     2016-02-18T02:00
103 Nausea       2016-02-19
;
proc sort data=DTC1; 
by ID;
run;
data DTC2;
input ID RFSTDTC: $10.;
datalines;
102 2016-01-20
104 2016-01-05 
103 2016-02-05
;
proc sort data=DTC1; 
by ID;
run;
proc sort data=DTC2;
by ID;
run;
Data DTC3;
merge DTC1 DTC2;
by ID; 
run;

Re: Merge

Patrick — Sun, 12 Apr 2020 12:12:53 GMT

@art_srap

Please post the same question only once. Answer to your duplicate here.

Re: Merge

art_srap — Sun, 12 Apr 2020 12:18:47 GMT

Thanks for the reply.

I haven't the last variable in output data https://prnt.sc/rxscbf, but now I now notice in proc print it appears

Re: Merge

Ksharp — Sun, 12 Apr 2020 12:35:54 GMT

Your code is right.
Please select TABLE WORK.DTC3, NOT WORK.DTC1 at top left corner .

Re: Merge

Kurt_Bremser — Sun, 12 Apr 2020 18:27:33 GMT

I merged the duplicate questions.