Hello,
Looking for suggestions to add missing entries to a sparse data matrix. For example, say I have the following:
data list / var1 var2 var3 1-6.
begin data.
1 1 5
1 2 6
1 3 7
2 1 8
2 3 3
end data.
Notice record for combination var1=2 & var2=2 is missing. I would like to have the following output to complete the data. In SAS you can use the SPARSE option in PROC FREQ.
1 1 5
1 2 6
1 3 7
2 1 8
2 2 .
2 3 3
Thank you!
E.
This e-mail and any files transmitted with it may contain privileged or confidential information. It is solely for use by the individual for whom it is intended, even if addressed incorrectly. If you received this e-mail in error, please notify the sender; do not disclose, copy, distribute, or take any action in reliance on the contents of this information; and delete it from your system. Any other use of this e-mail is prohibited.
Thank you for your compliance.