Hi, After spending the better part of the morning searching the Web without success I thought I would ask for help. Can anyone point me to a simple procedure to import data from a web page? Thanks Fred ... View more

Hi, I am performing the Proc Means using dates Aug 1 - Oct 20 and getting results below. Now I am concern because during that date range we have 3 holidays all falling on a Monday, is it possible to  apply weighting for holidays? proc MEANS NOPRINT data=Temp2; class day ; var count ; output out=Results_Mean  mean= MEAN min=MIN max=MAX median = median std= STD var = Variance uclm=UCL LCLM=LCL; run; day mean Min Max median UCL LCL Friday 15363.09 14520.75 16941.08 15125.04 15835.18 14891.01 Monday 15599.47 9884.35 18428.43 16710.27 17539.17 13659.77 Sunday 5177.31 4678.88 5627.83 5180.03 5378.74 4975.88 Tuesday 15741.51 15093 17173.3 15478.78 16231.36 15251.66 Saturday 7365.93 6257.15 8060.95 7559.72 7688.33 7043.53 Thursday 15488.72 14891.9 16958.3 15222.39 15934.34 15043.09 Wednesday 15825.44 14951.63 17371.22 15489.8 16405.85 15245.03 ... View more

Hello, Is it possible to apply a weighting to certain products when using proc means? My situation is that a new group of products has just been introduced causing the results of the proc means to be inflated. Previous to the new group of products the results fall between the UCL & LCL normally for each day, after results are very high. I don't want the customer to think that something is wrong with the data. Fred ... View more

Hello, I am having an issue with the join below as it takes for ever to run, any suggestions would be great. proc sql; create table Source_Lights as select datepart(a.date)format Date9. as date,a.employee,a.count(a.timestamp) as Totals, sum(a.Valid) as Valid from Lights a inner join Emp_List b on (a.employee = b.employee or a.employee = b.legacyemployee) and a.date = b.date group by a.date, a.employee; quit; Without the or a.employee = b.legacyemployee it works but when this is added it just spolls and still has yet to complete after an hour. Fred ... View more