I am trying to write a program that pulls data from a SQL server for the last 45 days.  The format on the SQL server for the date is a datetime format. I have this so far: %let BEG = '2013-10-01'; %put &BEG; %let END = '2013-11-14'; %put &END; proc sql; ....where date between &BEG and &END...; The above code works, but I would love to have something that automatically fills in yesterday's date and 45 days prior.  I tried this : %let BEG = %sysfunc(PUTN(%eval(%sysfunc(date())-45),yymmdd10.)); %put &BEG; %let END = %sysfunc(PUTN(%eval(%sysfunc(date())-1),yymmdd10.)); %put &END; This almost works.  It outputs 2013-10-01 and 2013-11-14, but I need it to output '2013-10-01' and '2013-11-14' so that my where statement evaluates correctly.  Is that possible?  Thanks for all of your help. ... View more

I have a dataset that I only want to use if the last obs of a certain variable meets a condition.  Otherwise I want to delete the data.  I tried something like this: data xyz; set xyz end=last;      if last then do;           if variable = 1 then output;           else delete;           end; run; When I run this it works in determining if the last obs of a variable meets the condition, but it only outputs the last observation.  I want it to output the entire data set for use in other processes, is there an easy way to do this? ... View more

Is it possible to set up the PROC Shewhart procedure to only print a chart or output if a CL is violated?  I am trying to set it up as a reporting procedure for multiple metrics at multiple units so checking through each graph would be time intensive.  Is there a way to only have the procedure output if there is a data point outside of either the UCL or LCL?   ... View more