topic Re: output if a subject or site or visit or date is missing in SAS Programming

output if a subject or site or visit or date is missing

Vijay77 — Wed, 07 Aug 2019 11:50:35 GMT

Hi ,

i have a scenario to

Output If the Site or Subject or Visit number or Visit Date is either present in the "A" data set but is missing from the "B" data set or vice versa?

any suggestions will be helpful, Thanks.

Re: output if a subject or site or visit or date is missing

Jagadishkatam — Wed, 07 Aug 2019 11:54:08 GMT

You can use the merge statement with by group to output such records or else you can also use the proc sql joins.

An example data would help to get better inputs.

Re: output if a subject or site or visit or date is missing

Vijay77 — Wed, 07 Aug 2019 14:05:13 GMT

Hi,

consider these as a example data

A B

site subject Visit number Visit Date site subject Visit number Visit Date

101 123 10 12aug2019 101 123 15 12aug2019 *here visit number diff so i should get as missing visnumber

101 134 05 14aug2019 101 134 05 . *here output missing date from b

101 135 09 . 101 135 09 14aug2019 *here output missing date from a

Re: output if a subject or site or visit or date is missing

Jagadishkatam — Wed, 07 Aug 2019 14:16:10 GMT

please try the below code

proc sort data=dataset_a;
by site subject visit_number visit_date;
run;

proc sort data=dataset_b;
by site subject visit_number visit_date;
run;

data want;
merge dataset_a(in=a) dataset_b(in=b);
by site subject visit_number visit_date;
if b and not a;
run;

Re: output if a subject or site or visit or date is missing

Shmuel — Thu, 08 Aug 2019 10:09:41 GMT

As @Vijay77 asked for: "...present in the "A" data set but is missing from the "B" data set or vice versa?"

a light change need to last step of @Jagadishkatam :

data want;
merge dataset_a(in=a) dataset_b(in=b);
by site subject visit_number visit_date;
if not (a and b);   /* line changed */
run;

Re: output if a subject or site or visit or date is missing

Vijay77 — Thu, 08 Aug 2019 07:10:40 GMT

Will this work for missing dates from either A or B with same site subject and visit

Re: output if a subject or site or visit or date is missing

Shmuel — Thu, 08 Aug 2019 10:08:45 GMT

Yes. of course. The checking is done after merging.

Re: output if a subject or site or visit or date is missing

Vijay77 — Fri, 09 Aug 2019 15:16:05 GMT

for missing dates:
merge a(in=x) b(in=y);
by site subjid visit;
if (x and y);
if missing(vis_date); run;