Hi all,
I want to ask a quick question. I think I can explain better by using simple sample.
So, I have the following data:
Time Value
13:45 0.2
13:45 0.4
13:45 0.3
13:46 0.1
13:46 0.2
13:46 0.3
13:46 0.5
13:46 0.4
I want to add one more column. The value in this column should be the standard deviation for each minute. So, I want to get the following data:
Time Value St.D
13:45 0.2 0.1 (it is the standard deviation of 0.2,0.4 and 0.3 - so st.dev for 13:45)
13:45 0.4 0.1
13:45 0.3 0.1
13:46 0.1 0.1528 (it is the standard deviation of 0.1,0.2,0.3,0.5 and 0.6 - so st.dev for 13:46)
13:46 0.2 0.1528
13:46 0.3 0.1528
13:46 0.5 0.1528
13:46 0.6 0.1528
Many thanks in advance for your helps.
Just a guess as not guessing what your code structure is nor typing that in:
proc means data=have; by time; var value; ouput out=m stddev=stddev; run; data want; merge have m; by time; run;
Just a guess as not guessing what your code structure is nor typing that in:
proc means data=have; by time; var value; ouput out=m stddev=stddev; run; data want; merge have m; by time; 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.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.