Prev: SGF 2010 Proceedings Available
Next: What is the option in Macro to display ERROR message if macro variable is not Resolved
From: Mike Anas on 28 Mar 2010 09:44 Does anyone know how to use PROC EXPAND without it dropping an observation when there is only 1 "usable input observation" per by group? I'm using PROC EXPAND to lag fields and want it to function similar to a left join. Thanks.
From: GuyA on 30 Mar 2010 06:29
I don't currently have PROC EXPAND available, but I've used it in the past. I don't miss it really: I don't think there is anything that its lagging capabilities can do that can't be done fairly easily with the lag functions (lag1 - lag100) in the data step. I think the only thing that PROC EXPAND can do that no other single step process can do is return forward looking results. |