topic Re: Merged on two variables in SAS Programming

Merged on two variables

NickA1 — Tue, 16 Jul 2019 14:30:03 GMT

I am looking to merge on two variables, rather than just one. I want to match on both and ID number and a Date.

Thanks

data Final;
	merge Gts_7 (in=in1) 
		  Merged5;
	by ID Date;
	if in1;
	run;

Re: Merged on two variables

PaigeMiller — Tue, 16 Jul 2019 14:30:50 GMT

What problems are you having?

Re: Merged on two variables

NickA1 — Tue, 16 Jul 2019 14:31:25 GMT

ERROR: BY variables are not properly sorted on data set WORK.MERGED5.
in1=0 Date=. Govt_Yield=. GT=30 Cusip=915217WX7 Yield=. FIRST.GT=0 LAST.GT=0 FIRST.Date=0
LAST.Date=0 _ERROR_=1 _N_=42
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 6 observations read from the data set WORK.GTS_7.
NOTE: There were 38 observations read from the data set WORK.MERGED5.
WARNING: The data set WORK.FINAL may be incomplete. When this step was stopped there were 5
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.04 seconds

Re: Merged on two variables

PaigeMiller — Tue, 16 Jul 2019 14:33:37 GMT

@NickA1 wrote:
ERROR: BY variables are not properly sorted on data set WORK.MERGED5.
in1=0 Date=. Govt_Yield=. GT=30 Cusip=915217WX7 Yield=. FIRST.GT=0 LAST.GT=0 FIRST.Date=0
LAST.Date=0 _ERROR_=1 _N_=42
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 6 observations read from the data set WORK.GTS_7.
NOTE: There were 38 observations read from the data set WORK.MERGED5.
WARNING: The data set WORK.FINAL may be incomplete. When this step was stopped there were 5
observations and 5 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.04 seconds

Seems like the error message (which I have highlighted in red) is relatively clear.

Re: Merged on two variables

PeterClemmensen — Tue, 16 Jul 2019 14:34:17 GMT

You have to sort your data first.

proc sort data=Merged5;
   by ID Date;
run;

Re: Merged on two variables

NickA1 — Tue, 16 Jul 2019 14:34:44 GMT

proc sort data=Gts_7; by Date; run;
proc sort data=Merged5; by Date; run;

They were already sorted prior to that first code being run. Thanks.