topic Re: Combine dataset without common key in SAS Programming https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719978#M222982 What's the logic? Can you simplify this and create a fully worked example that shows the exact input and expected output?<BR />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.<BR /> Wed, 17 Feb 2021 17:41:36 GMT Reeza 2021-02-17T17:41:36Z Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719977#M222981 <P>Greetings!</P><P>&nbsp;</P><P>I want to apply the following calculated mean + 1 SD and mean + 2 SD to another dataset&nbsp;</P><TABLE><TBODY><TR><TD>variables</TD><TD>a_SD1</TD><TD>a_SD2</TD><TD>b_SD1</TD><TD>b_SD2</TD><TD>c_SD1</TD><TD>c_SD2</TD><TD>d_SD1</TD><TD>d_SD2</TD></TR><TR><TD>level</TD><TD>.</TD><TD>.</TD><TD>1.2059</TD><TD>1.5366</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>score</TD><TD>1.0951</TD><TD>1.584</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD></TR><TR><TD>SAE</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>1.3645</TD><TD>2.2222</TD><TD>.</TD><TD>.</TD></TR><TR><TD>PD</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>.</TD><TD>2.5832</TD><TD>3.9519</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>and get a dataset like below:</P><TABLE><TBODY><TR><TD>1001</TD><TD>01MAR17:12:52:00</TD><TD>Placebo</TD><TD>a_SD1</TD><TD>a_SD2</TD><TD>b_SD1</TD><TD>b_SD2</TD><TD>c_SD1</TD><TD>c_SD2</TD><TD>d_SD1</TD><TD>d_SD2</TD></TR><TR><TD>1002</TD><TD>01MAR17:13:33:00</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1003</TD><TD>07MAR17:22:20:00</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1004</TD><TD>19MAR17:09:39:00</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1005</TD><TD>12APR17:11:54:00</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1006</TD><TD>26APR17:14:46:00</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1007</TD><TD>26MAY17:12:45:00</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1008</TD><TD>27MAY17:12:12:00</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1009</TD><TD>12JUN17:12:53:00</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1010</TD><TD>28JUN17:18:42:00</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1011</TD><TD>29JUN17:15:01:00</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1012</TD><TD>16SEP17:21:21:00</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1013</TD><TD>17SEP17:12:50:00</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1014</TD><TD>01MAR17:12:52:01</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1015</TD><TD>01MAR17:13:33:01</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1016</TD><TD>07MAR17:22:20:01</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1017</TD><TD>19MAR17:09:39:01</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1018</TD><TD>12APR17:11:54:01</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1019</TD><TD>26APR17:14:46:01</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1020</TD><TD>26MAY17:12:45:01</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1021</TD><TD>27MAY17:12:12:01</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1022</TD><TD>12JUN17:12:53:01</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1023</TD><TD>28JUN17:18:42:01</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1024</TD><TD>29JUN17:15:01:01</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1025</TD><TD>16SEP17:21:21:01</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1026</TD><TD>17SEP17:12:50:01</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1027</TD><TD>01MAR17:12:52:02</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1028</TD><TD>01MAR17:13:33:02</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1029</TD><TD>07MAR17:22:20:02</TD><TD>Active</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR><TR><TD>1030</TD><TD>19MAR17:09:39:02</TD><TD>Placebo</TD><TD>1.09512</TD><TD>1.5839</TD><TD>1.20585</TD><TD>1.53659</TD><TD>1.36451</TD><TD>2.22223</TD><TD>2.58318</TD><TD>3.95188</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Thanks as always!!</P> Wed, 17 Feb 2021 17:37:11 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719977#M222981 zimcom 2021-02-17T17:37:11Z Re: Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719978#M222982 What's the logic? Can you simplify this and create a fully worked example that shows the exact input and expected output?<BR />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.<BR /> Wed, 17 Feb 2021 17:41:36 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719978#M222982 Reeza 2021-02-17T17:41:36Z Re: Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719986#M222987 Yes, I am expecting all the values to be exactly the same regardless of date and whatever the variables are in the second table.<BR /><BR />Where did the times and placebo variables come from?<BR />the times and placebo variables come from another table<BR /> Wed, 17 Feb 2021 18:03:39 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719986#M222987 zimcom 2021-02-17T18:03:39Z Re: Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719990#M222991 <P>Alright, then use the if _n_=1 then <A href="https://github.com/statgeek/SAS-Tutorials/blob/master/add_average_value_to_dataset.sas" target="_self">set trick</A>. <BR /><BR /></P> Wed, 17 Feb 2021 18:23:17 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719990#M222991 Reeza 2021-02-17T18:23:17Z Re: Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719993#M222992 Could you please elaborate more on the coding part?<BR />Thanks!! Wed, 17 Feb 2021 18:23:17 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719993#M222992 zimcom 2021-02-17T18:23:17Z Re: Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719995#M222993 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. Wed, 17 Feb 2021 18:24:31 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/719995#M222993 Reeza 2021-02-17T18:24:31Z Re: Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/720008#M222998 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.<BR /><BR />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.<BR />Hope this helps.<BR /><BR />Thanks Wed, 17 Feb 2021 18:53:53 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/720008#M222998 zimcom 2021-02-17T18:53:53Z Re: Combine dataset without common key https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/720009#M222999 Please check the link on my second post then. Wed, 17 Feb 2021 18:58:06 GMT https://communities.sas.com/t5/SAS-Programming/Combine-dataset-without-common-key/m-p/720009#M222999 Reeza 2021-02-17T18:58:06Z