WOW. This is the first response that makes sense! I will give it a whirl and let you know how it goes. THANK YOU!! ... View more

Thank you so much! I really appreciate your feedback and I am looking it over and dissecting it then digesting it. I feel really lost. I can't even fig out how to take a 192 ob, 15 year data set and chop it into qtrs. I know SQL, some Python and some R. All simple comparatively. I don't know why I am having such a hard time. Thank you again. -Kate ... View more

   So my code is this - and basically works - except it's giving me missing values ' . ' that I don't want (also a 192 obs data set) where could I add 'missing'/'no missing'/;misstext' to ensure the table is cleaner? or do I change my format _all_ to a different variable?    DATA proj4.gas; SET proj4.gas; IF MONTH in (1,2,3) THEN Q1 = 1; ELSE IF MONTH in (4,5,6) THEN Q2 = 2; ELSE IF MONTH in (7,8,9) THEN Q3 = 3; ELSE IF MONTH in (10,11,12) THEN Q4 = 4; quarter = MONTH; FORMAT _all_; RUN;   ... View more