Hi,   I am running below code proc means data = p_tra qntldef=5 mean median min q3 q1 max stddev n ; var Baseline "Follow-up 1"n "Follow-up 2"n "Follow-up 3"n; output out=p_tra_out ; run; Output: Variable Mean Median Minimum Upper Quartile Lower Quartile Maximum Std Dev N Baseline 1.944444 1 1 4 1 5 1.589385 18 Follow-up 1 1.777778 1 1 1 1 5 1.516791 18 Follow-up 2 1.6 1 1 1 1 5 1.298351 15 Follow-up 3 . . . . . . . 0 It is giving me perfect output what I wanted whole displying the output of PROC Means. But, When I want the same output in output work dataset, I am not getting that.  Tried of using mean= median=, but no use. Without specifying any options, I am getting default vars N,Min,Max,Mean,STD. along with them I want Median, Q3, Q1 as well in output dataset. Could someone tell me how to get output dataset with all variables like proc means output.   Thanks, Pessi ... View more

Hello,   Most of our users today faced an issue. "An error occurred executing the workspace job. Server disconnected." It happened only when trying to use excel  1)Defining a lib libname mos "\<path>\SSS\IT\Mos.xlsx"; 2)proc export data=moc outfile="C:\Users\john\Desktop\IT\test_file.xlsx" dbms=excel replace; run; The above two worked till yesterday. Today we have issues.Jobs failed in both batch and EG. When we replace dbms=excel with dbms=xlsx, it worked for some users. But not for all.   Is there anything wrong with excel went on our servers?  What could be the possible issue and resolution?   ... View more