About AK100

AK100 · ‎11-17-2020

I just did this: `data datameting; set tms.datameting; run;` Its running for 6 minutes now and still running...

AK100 · ‎11-17-2020

@Kurt_Bremser Isn't it already in my SAS environment?

AK100 · ‎11-17-2020

@Kurt_Bremser @Kurt_Bremser This is the code I tried and its still running now for few minutes... data remove8seconds; do until (last.UniekID); set tms.datameting; by UniekID; if first.UniekID then start = Tijd; end; end = Tijd; do until (last.UniekID); set tms.datameting; by UniekID; if start + 8 le Tijd le end - 8 then output; end; drop start end; run;

AK100 · ‎11-17-2020

@FreelanceReinh @Kurt_Bremser @PeterClemmensen I tried all your suggestions. Im sure they all would work but the point is that it takes hours to run ... I did not wait for the result because my SAS EG started to crash and it took me to long. In the usable data I showed you above I indeed asked for the first 3 and last 3 seconds, but in the original data 1 measurement is much much longer (approx. 40 seconds and it has around 1500 records). And every day has maybe hundreds of measurements and the I have data of more then 1,5 year.. So you can already count how much records I have. Should be millions+. Got such a headache from this continually crashing...

AK100 · ‎11-17-2020

About Seconds

AK100 · ‎11-16-2020

@FreelanceReinhard. So what if I wanted to remove the first and last 8 seconds.

AK100 · ‎11-16-2020

Where does the 5 stand for in your code?

AK100 · ‎11-16-2020

@FreelanceReinhard. So this is the same as above, but much faster?

AK100 · ‎11-16-2020

Thank you. I will check it.

AK100 · ‎11-16-2020

Thank you. I will check it

AK100 · ‎11-16-2020

@Kurt_Bremser See usable data below: data have; input ID Value DateTime; datalines; 1 5 0.0 1 15 1.5 1 74 2.2 1 19 3.1 1 13 4.2 1 71 4.9 1 40 5.6 1 31 6.8 1 87 7.8 1 10 8.4 1 11 9.3 1 47 10.1 2 9 0.0 2 11 0.9 2 7 1.9 2 10 2.8 2 11 4.5 2 74 5.2 2 10 6.6 2 11 7.1 2 71 7.8 2 80 8.9 2 16 9.9 2 15 10.9 ; Please note that not every measurements has 12 observations.

AK100 · ‎11-16-2020

@PeterClemmensen No they don't all have 12 observations.

AK100 · ‎11-16-2020

I need the first and last 3 seconds removed because don't actually add something. The client doesn't need them. Yes, I forgot to say but they also have an ID yes. So record 1 till 12 have the same ID record 13 till 24 to etc..

AK100 · ‎11-16-2020

Hello Guys,| Simple question. I have a dataset which looks like below (in reality much bigger). I want to remove the first 3 seconds and the last 3 seconds of every measurement. How can that easily be done? Value - DateTime 5 - 0.0 15 - 1.5 74 - 2.2 19 - 3.1 13 - 4.2 71 - 4.9 40 - 5.6 31 - 6.8 87 - 7.8 10 - 8.4 11 - 9.3 47 - 10.1 9 - 0.0 11 - 0.9 7 - 1.9 10 - 2.8 11 - 4.5 74 - 5.2 10 - 6.6 11 - 7.1 71 - 7.8 80 - 8.9 16 - 9.9 15 - 10.9 So I actually want the BOLD ones removed.. Would like to hear. Thank you

AK100 · ‎11-12-2020

@anandchitale below you see the difference. The graph of SAS is less detailed then the graph above(The labview graph shows more points).

Problems when registering tables in the SAS Management Console

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

Re: How to get the folder tree of the SASFolders?

How to get the folder tree of the SASFolders?

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

Re: How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

How to concatenate Year, Month, Day, Hour, Minute, Second in SAS?

Re: SAS VA Graph's resolution

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: Rank until it reaches a specific percentage.

Re: Select top 1 (highest value )per section and day in SAS EG

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

Re: How to remove the first 3 seconds and last 3 seconds of a measurem...

How to remove the first 3 seconds and last 3 seconds of a measurement ...

Re: SAS VA Graph's resolution