topic Re: Create a new variable based on value of a specific observation in another variable in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/Re-Create-a-new-variable-based-on-value-of-a-specific/m-p/145435#M2353 <HTML><HEAD></HEAD><BODY><P>Another way to do this...</P><P></P><P>proc sql;<BR />select x1, y1 into :x2, :y2 from have<BR />where group=2;<BR />select x1, y1 into :x3, :y3 from have<BR />where group=6;<BR />quit;</P><P></P><P>data want;<BR />set have;<BR />x2=&amp;x2;<BR />y2=&amp;y2;<BR />x3=&amp;x3;<BR />y3=&amp;y3;<BR />run;</P></BODY></HTML> Mon, 05 May 2014 20:49:30 GMT stat_sas 2014-05-05T20:49:30Z Re: Create a new variable based on value of a specific observation in another variable https://communities.sas.com/t5/SAS-Data-Management/Re-Create-a-new-variable-based-on-value-of-a-specific/m-p/145435#M2353 <HTML><HEAD></HEAD><BODY><P>Another way to do this...</P><P></P><P>proc sql;<BR />select x1, y1 into :x2, :y2 from have<BR />where group=2;<BR />select x1, y1 into :x3, :y3 from have<BR />where group=6;<BR />quit;</P><P></P><P>data want;<BR />set have;<BR />x2=&amp;x2;<BR />y2=&amp;y2;<BR />x3=&amp;x3;<BR />y3=&amp;y3;<BR />run;</P></BODY></HTML> Mon, 05 May 2014 20:49:30 GMT https://communities.sas.com/t5/SAS-Data-Management/Re-Create-a-new-variable-based-on-value-of-a-specific/m-p/145435#M2353 stat_sas 2014-05-05T20:49:30Z