Help using Base SAS procedures

proc expand deletes single observation for by groups

Reply
Contributor
Posts: 29

proc expand deletes single observation for by groups

hi,
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

proc expand data=IN out=OUT method=none;
by bgrp1 bygrp2 bygrp3;
run;

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).
N/A
Posts: 1

Re: proc expand deletes single observation for by groups

Does anyone know the answer to this question? Proc expand deletes single observations. Is there any way to prevent this?

Ask a Question
Discussion stats
  • 1 reply
  • 208 views
  • 0 likes
  • 2 in conversation