Hi, I hope you could help me with my problem. I have this kind of data: Date Cat Price 01/10/2013 A 1.1 02/10/2013 A 1.2 03/10/2013 A 1.3 04/10/2013 A 1.4 05/10/2013 A 1.5 01/10/2013 B 33 02/10/2013 B 33 03/10/2013 B 29 04/10/2013 B 32 05/10/2013 B 30 I need transform the data to have when it would be possible the price of the each category 2 and 4 days before: Date Cat Price Price-2 Price-4 01/10/2013 A 1.1 . 02/10/2013 A 1.2 . 03/10/2013 A 1.3 1.1 04/10/2013 A 1.4 1.2 05/10/2013 A 1.5 1.3 1.1 01/10/2013 B 33 02/10/2013 B 33 03/10/2013 B 29 33 04/10/2013 B 32 33 05/10/2013 B 30 30 33 I was trying with this: PROC SQL; CREATE TABLE WORK.OUTPUT AS SELECT A.DATE, A.CAT, A.PRICE AS PRICE, (SELECT B.PRICE FROM WORK.COT_LAST AS B WHERE DATEPART(B.DATE) = INTNX('workday',DATEPART(A.DATE),-2,'same')AND A.CAT=B.CAT) AS PRICE2 (SELECT B.PRICE FROM WORK.COT_LAST AS B WHERE DATEPART(B.DATE) = INTNX('workday',DATEPART(A.DATE),-4,'same')AND A.CAT=B.CAT) AS PRICE2 FROM WORK.PREV AS A; QUIT; Any idea using sql or data? Thanks in advance!
... View more