About arjinram

Ksharp · ‎03-08-2016

data _null_; x='08MAR2016'd; start=intnx('week',x,0,'b'); end=intnx('week',x,0,'e'); put (x start end) (= date9.); run;

Rick_SAS · ‎03-07-2016

If you have SAS/ETS software, you can compute a three-month moving average by using PROC EXPAND and then merge the data and the average. By the way, the usual way to compute a three-month rolling average is to associate the rolling mean with the CURRENT month and the two PREVIOUS months. To use @ballardw's notation: New_app= mean(new,lag1(new),lag2(new));

LinusH · ‎03-02-2016

Step 1: PROC TRANSPOSE on the table with customer id (cols to rows). Step 2: SQL join with reference table.

Kurt_Bremser · ‎01-22-2016

Then please have the courtesy and mark Ksharp's post as the solution.

Online Status	Offline
Date Last Visited	‎07-07-2016 12:33 AM

HOW TO ASSIGN A WEEK RANGE TO A DATE

Calculating average

Need help in Transforming data while joining with other tables

Re: Conditional extraction of dates

Conditional extraction of dates

Re: Calculating average

Re: Conditional extraction of dates

Re: HOW TO ASSIGN A WEEK RANGE TO A DATE

Re: Calculating average

Re: Need help in Transforming data while joining with other tables

Re: Conditional extraction of dates