need to tell it to remove spaces, Try this.  Also you should use quit, not run to end a proc SQL.   proc sql; CREATE TABLE xxx AS SELECT A AS CommDesc ,COMPRESS('0802 12',' ') AS CN ; Quit; ... View more

data want;     set have;     retain prevField;     if field ne "" then prevField = field;     if field = "" then field = prevField; run; ... View more

If statements dont function in proc sql but you can do either of the following.   Case when obs1 = . then 0 else obs1 end as obs1 or you can simply do this   sum(obs1, 0) as obs1 ... View more

Can you post your code or the part of the log above the error? You probably have an extra comma somewhere. ... View more

Proc SQL; create table want as select State, city, food, sum(eligible2) as eligible from havetable group by state, city, food ; quit; Something like this? ... View more

Why do you need to convert this dataset from a long to a wide set? ... View more

Yes many parts do have actual seasonality.  Is there a statistical test that can be used to Validate this? Output i am looking for would look like this Part# Year Month ActualQuantity Expected Quantity 5d3423 2015 1 70 80 5d3423 2015 2 65 85 5d3423 2015 3 45 40 5d3423 2015 4 25 35 5d3423 2015 5 15 30 5d3423 2015 6 15 10 5d3423 2015 7 0 5 5d3423 2015 8 0 5 5d3423 2015 9 0 10 5d3423 2015 10 0 25 5d3423 2015 11 0 30 5d3423 2015 12 0 45 400 Total expected for 2015 based on past trends So basically I need to take a 1 year estimated Number and generate the properly weighted values by month based on the past trend data.  This i hope will allow me to see if I am out of the box on the estimated numbers early in the year.  I am not a statistician but do have a good understanding of sas programing and I am really looking for Ideas on what tools i need and the process to go through to get to this end result. Thank you so much for all your time. ... View more

Sorry I know i am not explaining this well.  Let me try again. From my first data set there is many years and about a million records.  I want to figure out from all that previous history by part number and month an average trend across the year.  I then want to use that trend to change my second data set from a yearly total into a monthly trend based on past  history of that part.   I need to do that so I can compare my expected usage to my actual usage and account for the trends of previous history. I hope this helps Thank you ... View more

I am no SAS expert and i'm sure the real experts on this sight can make this better.  I would love some suggestions but this is what i came up with.  There is currently no logic to increment your email numbers up but i wasn't sure that was necessary proc format ; value formula     low - 15 =0        16-40 =1         41-70=2        71-100=3       101-140=4       141-175=5       176-225=6       226-300=7       301-high=8 ; run; data have; input ID Email $ type $ edate mmddyy10. ; format edate mmddyy10.; datalines; 1 1 rdate 05/20/2015 1 2 rdate 05/21/2015 1 3 Sdate 10/05/2015 1 4 Sdate 11/09/2015 1 5 Sdate 12/11/2015 2 1 rdate 06/21/2015 2 2 rdate 07/05/2015 2 3 rdate 07/09/2015 2 4 Sdate 06/21/2016 2 5 Sdate 07/05/2016 2 6 Sdate 07/09/2016 ; run; /*Sort have dataset*/ proc sort data=have;     by id email type edate; run; data want;     /*merge have dataset to itself with on incremented forward on record*/     merge have           have(firstobs=2 rename=(id=_nxt_id email=_nxt_email                                 type=_nxt_type edate=_nxt_edate));        /*test if current and next record are same id and expected types*/     if id=_nxt_id and type = 'rdate' and _nxt_type = 'Sdate' then do;         output; /*ouput rdate observations*/         /*calculate the interval between the rdate and sdate records*/         /*then get formula count from the format*/         _interval = intck('days', edate, _nxt_edate);         _form_cnt = put(_interval, formula.);                type = 'formula';         /*loop through and create formula observations based on above calc's*/         do i=1 to _form_cnt;             edate = intnx('days',edate, _interval/(_form_cnt+1));             output; /*output formula observations*/         end;     end;     else output; /*output the Sdate observations*/     drop _: i; /*drop temp variables and loop variable*/ run; ... View more