Not sure how you wish to do that? In the same SAS session? Don't think that's possible, and why? SAS interacts/uses system resources so monitoring should take place outside SAS. For statistical purposes, you could use SAS to collect the figures, like options fullstimer, or ARM stuff. ... View more

Hi guys,   Thanks a lot for your suggestions and help. With your help i wrote the followoing code to solve my problem. I am just copy pasting my code here --------------------------------START------------------------------------------------- proc sql;         select             trim(name), trim(name)||'p' into :avl_selected_100K_spalten separated by ' ', :avl_selected_100K_spalten_P99 separated by ' '         from             dictionary.columns         where             libname = 'WORK'             and             memname = 'AVL_SELECTED_100K_PATCH'             and             upcase(name) not in('PERSON_ID');     quit; proc univariate data=AVL_SELECTED_100K_Patch noprint;    var &avl_selected_100K_spalten.;    output out=AVL_SELECTED_100K_P99 pctlpts  =99                            pctlpre  = &avl_selected_100K_spalten.                            pctlname = p; run; data AVL_SELECTED_100K_P99;     set AVL_SELECTED_100K_P99;     _TYPE_=0; run; PROC SORT     DATA=AVL_SELECTED_100K_P99     OUT=AVL_SELECTED_100K_P99_sort;     BY _TYPE_; RUN; PROC TRANSPOSE DATA=AVL_SELECTED_100K_P99_sort     OUT=Trans_AVL_SELECTED_100K_P99_sort     PREFIX=Column     NAME=Column_name     LABEL=Label;     BY _TYPE_;     VAR &avl_selected_100K_spalten_P99.; RUN; data AVL_SELECTED_100K_P99 (drop=_TYPE_ Label rename=(column1=P99));     set Trans_AVL_SELECTED_100K_P99_sort;     Column_name=substrn(Column_name,1,length(Column_name)-1); run; proc sql ;         select Column_name, P99 into :Column_nameP99 separated by ' ', :Column_nameP99_value separated by ' ' from AVL_SELECTED_100K_P99;     quit; %macro computePercentile();     %let count = 0;         %do %while (%qscan(&Column_nameP99.,%eval(&count + 1),%str( )) ne );             %let count = %eval(&count + 1);         %end;     %do i = 1 %to &count;     %let currentVar&i = %qscan(&Column_nameP99.,&i,%str( ));     %let currentValue&i = %qscan(&Column_nameP99_value.,&i,%str( ));     data AVL_SELECTED_100K_Patch;         set AVL_SELECTED_100K_Patch;           if &&currentVar&i.. gt &&currentValue&i.. then &&currentVar&i.. = &&currentValue&i..;               run;     %end; %mend; %computePercentile(); --------------------------------------END----------------------------------------------- ... View more

Hi, You need to put ods output before proc fastclus syntax. All the desired output datasets will be saved in work library. Regards, Naeem ods output InitialSeeds=InitialSeeds MinDist=MinDist IterHistory=IterHistory ConvergenceStatus=ConvergenceStatus ClusterSum=ClusterSum  VariableStat=VariableStat; proc fastclus data=have Replace=FULL  Radius=0  Maxclusters=3 Maxiter=20  Converge=0.02; var a b c d e; run; proc print data=InitialSeeds; run; proc print data=MinDist; run; ......... ...... ... View more

There a some good notes about native and foreign format of SAS tables/datasets. Moving and Accessing SAS(R) 9.4 Files  (Creating or Changing a SAS File's Format) As the sorting order is possible dependent on the NLS coding and the local machine there is an issue to able to definen that on an other machine. Looking at the documentation of transfering data all options have advantages and disadvantages. cport cimport can possible regress to V6 naming convetnions. SAS/connect is requiring more technical skills te let it work well. The proc upload/download procedures are reacting as separated process not knowing by default the status. The move option is not available. RLS (remote libraru Services) might offer a transparant processing by hiding the translation. You could be hit by some effects of the translation and automatic steps hidden in that.    ... View more

I think that the biggest concern about performance would be to question the need to create a single file containing more that 9.2 quadrillion records. ... View more