There are probably many ways to go about fixing my issue, and I have tried all that I know and still no luck. I have many variables and observations, but let's just focus on four of them. Subject, Projectedid, Actual, Actualid. I have a single observation for each subject and I need each variable to be populated, but some subjects are missing actual and actualin. If a subject is missing actual and actual in then I need it to be populated with what was projected. This would be an example of my dataset (obviously this is not the actual dataset). Subject Projectedid Actual Actualid 001 1 summer sum 002 2 winter win 003 1 winter win 004 1 . . I need my final dataset to look like; Subject Projectedid Actual Actualid 001 1 summer sum 002 2 winter win 003 1 winter win 004 1 summer sum Note: If the variabels are not missing, then sometimes the projected and actual do not match and that is how it is suppose to be. So, I thought I could use a data step and populate the missing variables by using an if then do; data favorite_seasons; set seasons; if actual='.' then do; if projectid='1' then actual='summer'; else if projectid='2' then actual='winter' end; if actualid='.' then do; if projectedid='1' then actualid='sum'; if projectedid='2' then actualid='win'; end; run; I thought this would work, but it is not populating correctly. Also, I need to kept my variables names that same so I am not sure if I need to do that in proc sql or not. Any help?
... View more