https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364378#M86427 <P>Dear,</P> <P>For sorting a dataset I need to populate the decod values all relavent OBS . Please help. Thank you very much</P> <P>&nbsp;</P> <P>output needed;</P> <P>Bodsys &nbsp; &nbsp; decod &nbsp; &nbsp; &nbsp; &nbsp; sev&nbsp;</P> <P>blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mild<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp;anae <BR />blsd &nbsp; &nbsp; &nbsp; anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; anae&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp;anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; lymp <BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; moderate<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; severe<BR />;</P> <PRE>data one; input bodsys $4. +1 decod $4. +1 sev $8.; datalines; blsd mild blsd moderate blsd severe blsd anae blsd mild blsd moderate blsd severe blsd lymp blsd mild blsd moderate blsd severe ;</PRE> Mon, 05 Jun 2017 21:12:41 GMT knveraraju91 2017-06-05T21:12:41Z https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364378#M86427 <P>Dear,</P> <P>For sorting a dataset I need to populate the decod values all relavent OBS . Please help. Thank you very much</P> <P>&nbsp;</P> <P>output needed;</P> <P>Bodsys &nbsp; &nbsp; decod &nbsp; &nbsp; &nbsp; &nbsp; sev&nbsp;</P> <P>blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mild<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp;anae <BR />blsd &nbsp; &nbsp; &nbsp; anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; anae&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp;anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; lymp <BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; moderate<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; severe<BR />;</P> <PRE>data one; input bodsys $4. +1 decod $4. +1 sev $8.; datalines; blsd mild blsd moderate blsd severe blsd anae blsd mild blsd moderate blsd severe blsd lymp blsd mild blsd moderate blsd severe ;</PRE> Mon, 05 Jun 2017 21:12:41 GMT https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364378#M86427 knveraraju91 2017-06-05T21:12:41Z https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364381#M86430 <PRE>data want (drop=hold);; set one; retain hold; if not missing(decod) then hold=decod; decod=hold; run; </PRE> <P>Art, CEO, AnalystFinder.com</P> <P>&nbsp;</P> Mon, 05 Jun 2017 21:21:13 GMT https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364381#M86430 art297 2017-06-05T21:21:13Z https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364408#M86433 <P>Dear,</P> <P>&nbsp;</P> <P>Thank you very much for the code.You code works for me for the sample data I posted. But if the bodsys values increase it is not getting the output i need.</P> <P>&nbsp;In the below example, The decod value='lymph' is populating for next OBS where bodsys='clsd'</P> <P>Output needed;</P> <P>&nbsp;</P> <P>output needed;</P> <P>Bodsys &nbsp; &nbsp; decod &nbsp; &nbsp; &nbsp; &nbsp; sev&nbsp;</P> <P>blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mild<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp;anae <BR />blsd &nbsp; &nbsp; &nbsp; anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; anae&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp;anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; lymp <BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; moderate<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; severe</P> <P><SPAN>clsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mild</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; &nbsp; cnae </SPAN><BR /><SPAN>clsd &nbsp; &nbsp; &nbsp;cnae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; cnae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate</SPAN></P> <P><SPAN>clsd &nbsp; &nbsp; cnae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe</SPAN></P> <P>&nbsp;</P> <PRE><BR />data one; input bodsys $4. +1 decod $4. +1 sev $8.; datalines; blsd mild blsd moderate blsd severe blsd anae blsd mild blsd moderate blsd severe blsd lymp blsd mild blsd moderate blsd severe clsd mild clsd moderate clsd severe clsd cnae blsd mild blsd moderate blsd severe ;<BR /><BR />data want;<BR /> set one;<BR /> retain hold;<BR /> if not missing(decod) then hold=decod;<BR /> decod=hold;<BR />run;</PRE> <P>&nbsp;</P> <P>output getting;</P> <P>Bodsys &nbsp; &nbsp; decod &nbsp; &nbsp; &nbsp; &nbsp; sev&nbsp;</P> <P>blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;mild<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; &nbsp;anae <BR />blsd &nbsp; &nbsp; &nbsp; anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; anae&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate<BR />blsd &nbsp; &nbsp; &nbsp;anae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe<BR />blsd &nbsp; &nbsp; &nbsp; lymp <BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; moderate<BR />blsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; severe</P> <P><SPAN>clsd &nbsp; &nbsp; &nbsp;lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; lymp &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; &nbsp; cnae </SPAN><BR /><SPAN>clsd &nbsp; &nbsp; &nbsp;cnae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mild</SPAN><BR /><SPAN>clsd &nbsp; &nbsp; cnae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;moderate</SPAN></P> <P><SPAN>clsd &nbsp; &nbsp; cnae &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;severe</SPAN></P> Mon, 05 Jun 2017 23:21:10 GMT https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364408#M86433 knveraraju91 2017-06-05T23:21:10Z https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364410#M86434 <P>You didn't show what you want in such a situation, but it might be:</P> <PRE>data want (drop=hold); set one; length hold $4; by bodsys notsorted; retain hold; if first.bodsys then call missing(hold); if not missing(decod) then hold=decod; decod=hold; run; </PRE> <P>Art, CEO, AnalystFinder.com</P> Mon, 05 Jun 2017 23:33:35 GMT https://communities.sas.com/t5/SAS-Programming/How-to-populate-a-group-variable-values-to-all-obs/m-p/364410#M86434 art297 2017-06-05T23:33:35Z