Hey Guys!
sorry for my english but I hope you understand and could help me.
I want to get the following information:
The time betweeen the timestamps "e" in seconds from one object with an unique "ipid".
Please see my attachement.
I tried with DATADIFF and LAG:
SELECT DATEDIFF (second, ptime, e), q.*
FROM (SELECT *,
LAG(e) OVER (PARTITION BY ipid ORDER BY e) ptime
FROM Table ) q
WHERE ptime IS NOT NULL
But: "The LAG function is not supported in PROC SQL, it is only valid within the DATA step."
You have any other idea?
Thanks!!!
You could do the calculations in a data step instead of PROC SQL. Then the LAG function would work.
OVER BY and PARTITION are also not supported so your best best is to switch to a data step.
You can also use the DIF() function directly instead.
@Hans_Mahler wrote:
Hey Guys!
sorry for my english but I hope you understand and could help me.
I want to get the following information:
The time betweeen the timestamps "e" in seconds from one object with an unique "ipid".
Please see my attachement.
I tried with DATADIFF and LAG:
SELECT DATEDIFF (second, ptime, e), q.*
FROM (SELECT *,
LAG(e) OVER (PARTITION BY ipid ORDER BY e) ptime
FROM Table ) q
WHERE ptime IS NOT NULL
But: "The LAG function is not supported in PROC SQL, it is only valid within the DATA step."
You have any other idea?
Thanks!!!
*sort data for by group processing;
proc sort data=sashelp.stocks out=stocks1; by stock date;
data stocks2;
set stocks1;
by stock date;
*get previous value;
prev_open = lag(open);
*if first record for the stock group, set to missing to avoid using
previous stocks value;
if first.stock then call missing(prev_open);
*calculate difference when not missing;
if not missing(prev_open) then difference = open - prev_open;
run;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.