Date:         Thu, 22 Mar 2012 14:26:27 -0400
Reply-To:     Ethan Zhou <e75wez1@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Ethan Zhou <e75wez1@GMAIL.COM>
Subject:      Add Missing Records to Table and Impute Values of all Missing.

Hi all,

I have a dataset comprised of  state , group, price and volume.There are
some missing records for month per each state.



data test;
input  state $  group $  MONTH $ PRICE VOLUME;
datalines;
AK  A 02 60 100
AK  A 03 70 120
AK  A 04 80 130
AK  B 02 60 100
AK  B 03 70 120
AK  B 04 80 130
AL  A 01 5 10
AL  A 03 7 12
AL  A 04 8 13
AL  B 01 5 10
AL  B 03 7 12
AL  B 04 8 13
AR  A 01 15 105
AR  A 02 16 106
AR  A 04 18 108
AR  B 01 15 105
AR  B 02 16 106
AR  B 04 18 108
;
RUN;

Wanted data:

AK  A 01 . .
AK  A 02 60 100
AK  A 03 70 120
AK  A 04 80 130
AK  B 01 . .
AK  B 02 60 100
AK  B 03 70 120
AK  B 04 80 130
AL  A 01 5 10
AL  A 02 . .
AL  A 03 7 12
AL  A 04 8 13
AL  B 01 5 10
AL  B 02 . .
AL  B 03 7 12
AL  B 04 8 13
AR  A 01 15 105
AR  A 02 16 106
AR  A 03 . .
AR  A 04 18 108
AR  B 01 15 105
AR  B 02 16 106
AR  B 03 . .
AR  B 04 18 108

I want to first make sure each STATE has 4 records. So, STATE would add 1
or 2 records with MISSING values for MONTH and make variables PRICE &
VOLUME are MISSING values.


Is there an easy way to do this?

Joe