Hello, all, I was trying to concatenate some variables, but I noticed it was taking quite some time to run the code. I tried using a keep statement in the set statement to decrease the time, and it took less CPU time but more real time (to my surprise). I assumed that since the keep statement pulls only the variable of interest, it would take less time (and it does take less CPU time!). Just for the heck of it, I ran both codes 10 times and the averages are shown below the code snippets. This is more of a curiosity than an actual problem.
So I guess my overall question is, why does it take more real-time?
/*Code Snippet 1*/
data want;
set Lib.have;
cat_var = catt(var1,"_",var2,"_",var3,"_",var4);
run; /* CPU 9.62 Real-time 1.21
*/
/*Code Snippet 2*/
data want;
set Lib.have(keep= var1 var2 var3 var4);
cat_var = catt(var1,"_",var2,"_",var3,"_",var4);
run;
/* CPU 5.17 Real-time 2.35
*/
... View more