With my SASFolders I literally mean all the SAS directories and files that I have. The environment is Windows. I just want the whole file tree weather that's in the windows command prompt or in SAS Enterprise guide.
... View more
Got This back, No DATALINES or INFILE statement.. Probably because I have this:
data work.merged_table;
input Year Month Day Hour Minute Second;
;
data want;
set work.merged_table;
date = mdy(Month, Day, Year );
datetime = dhms(date, Hour, Minute, Second);
format date ddmmyy10. datetime datetime20.;
run;
... View more
For the ones who want to know the solution. I changed the graph to a numeric graph and used seconds instead of datetimes on the x-axis. I also placed a maximum on the Y-axis
... View more
Maximizing the object helps a bit, as soon I as I maximize it I see there are more peaks visual. However, when I open the same in Labview or even in Excel I get much more peaks to see which means that the graph in reality is much more detailed.
... View more
@Kurt_Bremser Okay, finally got it working. Appreciate your help.
It seemed that it copied the table from the ODBC to WORK. Is that correct? If so whats the benefit of this and should I always start with below code on every table? It seemd to make things 1000X faster.
data datameting;
set tms.datameting;
run;
And of course also interested in:
proc sort data=datameting;
by UniekID Tijd;
run;
data removeseconds;
do until (last.UniekID);
set work.datameting;
by UniekID;
if first.UniekID then start = Tijd;
end;
end = Tijd;
do until (last.UniekID);
set work.datameting;
by UniekID;
if start + 8 le Tijd le end - 8 then output;
end;
drop start end;
run;
... View more
@Kurt_Bremser There you go:
I must say that below code works super fast:
data remove8seconds;
do until (last.UniekID);
set work.datameting;
by UniekID;
if first.UniekID then start = Tijd;
end;
end = Tijd;
do until (last.UniekID);
set work.datameting;
by UniekID;
if start + 8 le Tijd le end - 8 then output;
end;
drop start end;
run;
So it gives output data but it also gives the following error:
... View more
@Kurt_Bremser Okay So it finished running the first part (it took about 12 miutes I guess). I now have a new datameting. So now you want me to run the following: Is that correct?
data remove8seconds;
do until (last.UniekID);
set work.datameting;
by UniekID;
if first.UniekID then start = Tijd;
end;
end = Tijd;
do until (last.UniekID);
set work.datameting;
by UniekID;
if start + 8 le Tijd le end - 8 then output;
end;
drop start end;
run;
... View more
