Hi, I'm trying to use proc expand to do a rolling sum based on multiple columns. I'm able to do a rolling sum if I'm just using my year_month date column, but when I add another dimension, I can't have it perform the sum taking into account the 2nd dimension. I have the first three columns below.  I'm not sure how to get the 4th column.  I can do it if I I'm not including the 'State' field, but I need it broken out by month and state. Thank you in advance! Tom Year_Month State Value Rolling3 201401 CA 11 201402 CA 12 201403 CA 11 34 201404 CA 12 35 201405 CA 14 37 201401 TX 12 201402 TX 14 201403 TX 10 36 201404 TX 11 35 201405 TX 16 37 ... View more

Hi Everyone, I have a SAS Macro that looks like this: %LET SUBGRP=('202') and I'm using it in a proc SQL statement: cm.subgrp in @SUBGRP This works, but what if I want to allow the user of the program to select all subgroups?  Sometimes they will need to do that.  How would I adjust my macro? I tried: %LET SUBGRP=('*') and %LET SUBGRP=('%') ..and both of those didn't work.  Any suggestions? Thanks, Tom ... View more

I'm using Proc SQL to query an oracle database.  I have a date that comes through as a datetime20.  When I convert it to a SAS data, the numeric value of that data is 10 digits long.  Given that the dates are all in the past few years, the numeric value should be around 18000 (ex 4/13/2009 minus 1/1/1960 is 18000).  How do I get the date from Oracle to accurately be reflected in SAS?  My code is at work (I'm at home now), but it generally looks like this: PROC SQL;      CREATE TABLE APPT AS      (SELECT A.DATE FORMAT datew. FROM LIB.APPOINTMENT); QUIT; An example value in the field "Appointment" is 1080844400'.  Why is it 10 digits long?  The actual dates are recent, so should they all be around five digits? Thanks in advance. Tom ... View more

Hi, I have a data set: LEVEL 4 5 23 64 3 4 I Need: TIME     LEVEL 1          4 2          5 3          23 4          64 5          3 6          4 How do i read in the "time" variable that iterates by one with each "level" observation? Thanks in Advance! ... View more

I'm having more date issues.  I need to add a certain amount of months to a date, and the convert it to the 'YYYYMM' format. I can do this in PROC SQL if I'm pulling data from the oracle db.  Once I have a work table in SAS though I can no longer do this.  The proc sql doesn't recognize the to_char function or the add_months function. I don't know how to do the equivalent in SAS. Basically, if I have a date   16SEP2012:00:00:00 I need to add months to it, than convert it to a 'YYYYMM' format.  So in my code below, if RECALL=2, then I would add two months to the date above, and then convert it to YYYYMM.  I'd end up with 201211 (december 2011). Here's what I'm doing: PROC SQL; UPDATE PL.TREATMENT_PLANS_ADJ_RECALL SET RECALLDATE1=TO_CHAR(ADD_MONTHS(R.RECALLDATE, RECALL),'YYYYMM'); RUN; If I were connecting to Oracle it would work.  But I can't connect to Oracle because that's not where my table is. Thanks for helping out this SAS date newbie! ... View more