topic merge statement error in Statistical Procedures

merge statement error

mona4u — Mon, 01 Aug 2022 18:34:03 GMT

data WBC;
input subject $ TRTA $ Amethod $ WBC;
datalines;
1 A Upper 2.2
1 A lower 2.1
;

data QS;
input subject $ TRTA $ QS $ QSVAL;
datalines;
1 A Q1 99
1 A Q2 100
;

proc sort data=wbc; by subject trta; run;
proc sort data=qs; by subject trta; run;

data all;
merge wbc qs;
by subject trta ;
RUN;

here is the data that I get

SUBJECT	TRTA	AMETHOD	WBC	QS	QSVAL
1	A	Upper	2.2	Q1	99
1	A	lower	2.1	Q2	100

this is what I want

SUBJECT	TRTA	AMETHOD	WBC	QS	QSVAL
1	A	Upper	2.2	Q1	99
1	A	Upper	2.2	Q2	100
1	A	lower	2.1	Q1	99
1	A	lower	2.1	Q2	100

Re: merge statement error

PaigeMiller — Mon, 01 Aug 2022 18:42:39 GMT

Use a Cartesian join in PROC SQL

https://support.sas.com/kb/25/270.html

Re: merge statement error

mona4u — Mon, 01 Aug 2022 19:43:14 GMT

created this and it is not working for me.

Re: merge statement error

PaigeMiller — Mon, 01 Aug 2022 19:49:36 GMT

@mona4u wrote:

created this and it is not working for me.

I don't know what to say. You have provided no information from which I can help you.

Re: merge statement error

mona4u — Mon, 01 Aug 2022 20:23:06 GMT

I have multiple treatments and multiple subjects. when I tried that type of merge it is creating some weird results.

Re: merge statement error

mona4u — Mon, 01 Aug 2022 20:35:54 GMT

I added the where statement and it worked.

Thanks

Re: merge statement error

Dianahemes — Thu, 22 Dec 2022 06:30:23 GMT

A MERGE statement cannot UPDATE/DELETE the same row of the target table multiple times. Refine the ON clause to ensure a target row matches at most one source row, or use the GROUP BY clause to group the source rows.

Regards,

Will