topic Re: How to add missing hours into SAS file? in SAS Programming

How to add missing hours into SAS file?

CMepistudent — Thu, 13 Jun 2019 19:40:30 GMT

Hi!

I have a SAS file of 200 zones. In each zone, there are 150 houses. I then have a binary event variable.

I do not have info on all the houses but need to fill in the missing values and put event= '.'

Like for zone 0, I am missing house 4,5,6,7, the values between 8-30, etc. Is there a way I can add these missing values for each of the zones in SAS?

I hope this question makes sense!

the picture is how it looks now:

Re: How to add missing hours into SAS file?

Reeza — Thu, 13 Jun 2019 19:37:45 GMT

Sure, but you need to have the infomration somewhere? Does it exist elsewhere in a different data set? How do you know which values are missing besides obvious sequential order? For example,should 90 to 101 be present for zone 2?

There's a CLASSDATA option in PROC MEANS that helps with setting this up.

We can't really help from images though, unless we type out your data. If you need help with code please take the time to paste your data as text and also show your expected output.

Re: How to add missing hours into SAS file?

CMepistudent — Thu, 13 Jun 2019 19:42:57 GMT

I already have this file imported into SAS.

We know that there are 150 houses per zone. So for the houses with missing info: I need it to say zone 0, hour 4, accident "." (to indicate that it's missing).

We have information for a lot of the houses, but need to indicate missing for the ones that aren't listed in the file.

Re: How to add missing hours into SAS file?

PGStats — Thu, 13 Jun 2019 19:45:37 GMT

Can't do any testing with a picture.

Re: How to add missing hours into SAS file?

Reeza — Thu, 13 Jun 2019 19:48:27 GMT

We know that there are 150 houses per zone.

So houses are labeled 0 to 150 and how many zones do you have?

Probably the simplest way is to build an empty table and merge into it.

data skeleton;
do zone=1 to 200;
do house=1 to 150;
output;
end;
end;
run;

data want;
merge skeleton have;
by zone house;
run;

A bunch of other options are outlined in this document, some are easier, some are harder.

https://www.lexjansen.com/pharmasug/2005/CodersCorner/cc22.pdf

Re: How to add missing hours into SAS file?

CMepistudent — Thu, 13 Jun 2019 20:22:05 GMT

Thank you! I appreciate it!