topic Re: How to show same variables side by side in SAS Programming

How to show same variables side by side

chinna0369 — Tue, 21 Feb 2023 20:36:27 GMT

Hi all,

I am merging the below datasets but I am not getting the output which I want. Can anyone help me with this?

data local;
	input subject $1-10 local_visit $11-20 local_date $21-30 local_time $31-40;
datalines;
101-007   WEEK 18   13JUL2022  12:49
101-007   WEEK 18   13JUL2022  12:50
101-007   WEEK 18   13JUL2022  12:51
101-007   WEEK 20   28SEP2022  14:38
101-007   WEEK 20   28SEP2022  14:39
101-007   WEEK 20   28SEP2022  14:40
101-007   WEEK 22   13APR2022  13:02
101-007   WEEK 22   13APR2022  13:03
101-007   WEEK 22   13APR2022  13:04
;
run;
proc sort; by subject; run;

data central;
	input subject $1-10 central_visit $11-20 central_date $21-30 central_time $31-40;
datalines;
101-007   WEEK 18   13JUL2022  12:30
101-007   WEEK 18   13JUL2022  12:31
101-007   WEEK 19   14JUL2022  12:32
101-007   WEEK 20   28SEP2022  14:01
101-007   WEEK 20   28SEP2022  14:02
101-007   WEEK 20   29SEP2022  14:03
101-007   WEEK 22   13APR2022  13:45
101-007   WEEK 22   13APR2022  13:46
101-007   WEEK 22   14APR2022  13:47
;
run;
proc sort; by subject; run;

data want;
	input subject $1-10 local_visit $11-20 central_visit $21-30 local_date $31-40 central_date $42-51 local_time $53-58 central_time $60-65;
datalines;
101-007   WEEK 18   WEEK 18   13JUL2022  13JUL2022  12:49  12:30
101-007   WEEK 18   WEEK 18   13JUL2022  13JUL2022  12:50  12:31
101-007   WEEK 18             13JUL2022             12:51      
101-007             WEEK 19              14JUL2022         12:51
101-007   WEEK 20   WEEK 20   28SEP2022  28SEP2022  14:38  14:01
101-007   WEEK 20   WEEK 20   28SEP2022  28SEP2022  14:39  14:02
101-007   WEEK 20   WEEK 20   28SEP2022  29SEP2022  14:40  14:03
101-007   WEEK 22   WEEK 22   13APR2022  28SEP2022  13:02  13:45
101-007   WEEK 22   WEEK 22   13APR2022  28SEP2022  13:03  13:46
101-007   WEEK 22   WEEK 22   13APR2022  24SEP2022  13:04  13:47
;
run;

I am unable to merge because of mutiple records.

Thanks in advance!

Anyala

Re: How to show same variables side by side

PaigeMiller — Tue, 21 Feb 2023 20:55:21 GMT

What is the logic you want when merging data sets here? I don't think we can generalize or infer what you want from the one mismatch in your two tables. Please provide more details.

Re: How to show same variables side by side

chinna0369 — Tue, 21 Feb 2023 20:58:31 GMT

I want to combine two datasets by visits and compare dates and time for each visit from two datasets.

Re: How to show same variables side by side

data_null__ — Tue, 21 Feb 2023 21:24:13 GMT

PROC COMPARE

Re: How to show same variables side by side

chinna0369 — Tue, 21 Feb 2023 21:33:41 GMT

No, I would like to create a dataset which is shown in example the
dataset name called want to show variables side by side from each dataset for manual comaparision.

Re: How to show same variables side by side

PaigeMiller — Tue, 21 Feb 2023 21:59:18 GMT

@chinna0369 wrote:
I want to combine two datasets by visits and compare dates and time for each visit from two datasets.

I ask you to provide the logic, and you repeat the same information as in your original message. That's not what I want. I want a more complete explanation of how to merge these data sets and create the desired output. The example you give has only one mismatch and I do not think I can generalize from one mismatch what to do in that situation.

Re: How to show same variables side by side

ballardw — Tue, 21 Feb 2023 22:00:43 GMT

Suggestion: Don't worry much about the order of variables in a data set. Any of the report procedures can write variables in any order that you prefer.

Proc Print the data concerned and list the variables in the order you want them on a VAR statement.

And do you really have that many "date" variables that are character??? That is basically shooting yourself in the foot as pretty much the first thing involved for most analysis or manipulation is going to be create a date value instead of character.