Combine dataset without common key

[zimcom]

Greetings!

I want to apply the following calculated mean + 1 SD and mean + 2 SD to another dataset 

variables	a_SD1	a_SD2	b_SD1	b_SD2	c_SD1	c_SD2	d_SD1	d_SD2
level	.	.	1.2059	1.5366	.	.	.	.
score	1.0951	1.584	.	.	.	.	.	.
SAE	.	.	.	.	1.3645	2.2222	.	.
PD	.	.	.	.	.	.	2.5832	3.9519

and get a dataset like below:

1001	01MAR17:12:52:00	Placebo	a_SD1	a_SD2	b_SD1	b_SD2	c_SD1	c_SD2	d_SD1	d_SD2
1002	01MAR17:13:33:00	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1003	07MAR17:22:20:00	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1004	19MAR17:09:39:00	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1005	12APR17:11:54:00	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1006	26APR17:14:46:00	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1007	26MAY17:12:45:00	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1008	27MAY17:12:12:00	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1009	12JUN17:12:53:00	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1010	28JUN17:18:42:00	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1011	29JUN17:15:01:00	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1012	16SEP17:21:21:00	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1013	17SEP17:12:50:00	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1014	01MAR17:12:52:01	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1015	01MAR17:13:33:01	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1016	07MAR17:22:20:01	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1017	19MAR17:09:39:01	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1018	12APR17:11:54:01	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1019	26APR17:14:46:01	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1020	26MAY17:12:45:01	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1021	27MAY17:12:12:01	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1022	12JUN17:12:53:01	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1023	28JUN17:18:42:01	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1024	29JUN17:15:01:01	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1025	16SEP17:21:21:01	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1026	17SEP17:12:50:01	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1027	01MAR17:12:52:02	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1028	01MAR17:13:33:02	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1029	07MAR17:22:20:02	Active	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188
1030	19MAR17:09:39:02	Placebo	1.09512	1.5839	1.20585	1.53659	1.36451	2.22223	2.58318	3.95188

Thanks as always!!

[Reeza]

What's the logic? Can you simplify this and create a fully worked example that shows the exact input and expected output?
I can see the values are filled down, so are you actually expecting all the values to be exactly the same regardless of date and whatever the variables are in the second table. Where did the times and placebo variables come from? What's the logic there? Your example will help answer these questions.

[zimcom]

Yes, I am expecting all the values to be exactly the same regardless of date and whatever the variables are in the second table.

Where did the times and placebo variables come from?
the times and placebo variables come from another table

[Reeza]

Alright, then use the if _n_=1 then set trick.

[zimcom]

Could you please elaborate more on the coding part?
Thanks!!

[Reeza]

Could you please provide a full example as requested to ensure your problem is clear and the answer provided is correct. There's a linked example that shows how it works in general.

[zimcom]

Basically I have a demographic dataset with 4 numeric variables which I calculated the mean and SD separetly. now I need to merge back the mean + 1SD and mean + 2SD back to the demographic dataset so that I can cross check if the 4 numeric variables is higher or lower compared with the mean + 1SD and mean + 2SD.

So that is why I need to put all the values to be exactly the same regardless of date and whatever the variables are in the second table.
Hope this helps.

Thanks

[Reeza · Accepted solution]

Please check the link on my second post then.