**Date:** Mon, 9 May 2005 09:50:32 -0700
**Reply-To:** Yiyu <shenyiyu@GMAIL.COM>
**Sender:** "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
**From:** Yiyu <shenyiyu@GMAIL.COM>
**Organization:** http://groups.google.com
**Subject:** fill each group with continuous numbers
**Content-Type:** text/plain; charset="iso-8859-1"
I have a data set like this:

Date Permno Signal
19900101 19383 1
19900101 29304 0
19900101 29590 0
........
19900102 29340 0
19900102 29584 1
19900102 99999 1
........

I know the maximum possible value of permno is 99999, and for each date
group I want to fill it with obs with continuous values of permno from
1 to 99999, if the permno is in the original data set then the original
obs is kept, if it's not then the value is set to missing. So for each
date there are exactly 99999 obs and it looks like:

Date Permno Signal
19900101 1 .
19900101 2 .
........
19900101 19383 1
19900101 19384 .
........
19900101 99999 .

19900102 1 .
19900102 2 .
........
19900102 99999 1

What's the most simple way to do it? and the most efficient way?

Thank you very much.

Yiyu