topic Re: proc expand deletes single observation for by groups in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/proc-expand-deletes-single-observation-for-by-groups/m-p/14684#M2403 <HTML><HEAD></HEAD><BODY><P>Does anyone know the answer to this question? Proc expand deletes single observations. Is there any way to prevent this?</P></BODY></HTML> Wed, 24 Jul 2013 11:30:45 GMT 5forwards 2013-07-24T11:30:45Z proc expand deletes single observation for by groups https://communities.sas.com/t5/SAS-Procedures/proc-expand-deletes-single-observation-for-by-groups/m-p/14683#M2402 hi,<BR /> I was wondering if I could tell proc expand not to delete rows in a data set for which there exists only a single observation per by-group. For example<BR /> <BR /> proc expand data=IN out=OUT method=none;<BR /> by bgrp1 bygrp2 bygrp3;<BR /> run;<BR /> <BR /> will delete all lines in the OUT data set for which there exist only one observation per by-group in the IN dataset. I would prefer that the lines would still be there with the automatic variable TIME having a value of zero (I know that I could use a data step to create the automatic variable TIME). Mon, 11 Oct 2010 12:39:35 GMT https://communities.sas.com/t5/SAS-Procedures/proc-expand-deletes-single-observation-for-by-groups/m-p/14683#M2402 niemannk 2010-10-11T12:39:35Z Re: proc expand deletes single observation for by groups https://communities.sas.com/t5/SAS-Procedures/proc-expand-deletes-single-observation-for-by-groups/m-p/14684#M2403 <HTML><HEAD></HEAD><BODY><P>Does anyone know the answer to this question? Proc expand deletes single observations. Is there any way to prevent this?</P></BODY></HTML> Wed, 24 Jul 2013 11:30:45 GMT https://communities.sas.com/t5/SAS-Procedures/proc-expand-deletes-single-observation-for-by-groups/m-p/14684#M2403 5forwards 2013-07-24T11:30:45Z