topic can anyone help me in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/can-anyone-help-me/m-p/131027#M35655 <HTML><HEAD></HEAD><BODY><P>I am doing validation for a dataset</P><P></P><P>I have two datasets</P><P></P><P>dataset A has usubjid, trt, studywk</P><P>dataset B has usubjid&nbsp; visit</P><P></P><P></P><P>dataset A has studywk as 1 2 3 ...11...99</P><P></P><P>dataset B also has studywk as s01 s02 s03 ....s11,s12,,,s99&nbsp; B datasets has more number of observations but i need visit only from dataset B and studywk also.</P><P></P><P>what is the best proc sql method to get this two datasets merged.</P></BODY></HTML> Tue, 07 May 2013 02:30:20 GMT lm 2013-05-07T02:30:20Z can anyone help me https://communities.sas.com/t5/SAS-Procedures/can-anyone-help-me/m-p/131027#M35655 <HTML><HEAD></HEAD><BODY><P>I am doing validation for a dataset</P><P></P><P>I have two datasets</P><P></P><P>dataset A has usubjid, trt, studywk</P><P>dataset B has usubjid&nbsp; visit</P><P></P><P></P><P>dataset A has studywk as 1 2 3 ...11...99</P><P></P><P>dataset B also has studywk as s01 s02 s03 ....s11,s12,,,s99&nbsp; B datasets has more number of observations but i need visit only from dataset B and studywk also.</P><P></P><P>what is the best proc sql method to get this two datasets merged.</P></BODY></HTML> Tue, 07 May 2013 02:30:20 GMT https://communities.sas.com/t5/SAS-Procedures/can-anyone-help-me/m-p/131027#M35655 lm 2013-05-07T02:30:20Z Re: can anyone help me https://communities.sas.com/t5/SAS-Procedures/can-anyone-help-me/m-p/131028#M35656 <HTML><HEAD></HEAD><BODY><P>if variable studywk in dataset A is character type. it is first starting:</P><P></P><P>select b.*</P><P> from b,a</P><P>&nbsp; where b.studywk contains strip(put(a.studywk,z2.)) ;</P><P></P><P></P><P></P><P>Ksharp</P></BODY></HTML> Tue, 07 May 2013 03:49:17 GMT https://communities.sas.com/t5/SAS-Procedures/can-anyone-help-me/m-p/131028#M35656 Ksharp 2013-05-07T03:49:17Z