Thank you for your help. I tried this but get this response NOTE: The execution of this query involves performing one or more Cartesian product joins that can not be optimized. NOTE: Table WORK.TEMP created, with 14 rows and 4 columns. But in my real data, what I need is that if Jan11 there is data, and in Feb11 no data and again in Mar11 is data again. Jan value is 10, feb no value, Mar value is 20. What I would like to see is Jan 10, Feb 10 and Mar 20 I know there is a solution, but I can't find it yet. Thanks, I really appreciate this forum, it really helps people that are less skilled in SAS.
... View more