Thanks for this approach. After running the above code, a listing of the different members were collected as line records. Hence a search is required to determine the required factor. Got it. ... View more

Hi, Thanks for the useful information, but i am seeking the members of system directory not only SAS. In other words if i have a list of excel files or word documents etc... how to capture all those files in a sas dataset with the DOS attributes (name,date modified,type,size etc....) Thanks again. ... View more

Hi another simple solution : PROC SORT DATA=HAVE;      BY BIN; RUN; ODS LISTING CLOSE; PROC TABULATE DATA=HAVE OUT=FREQ;      CLASS BIN  /  ASCENDING;      TABLE BIN; RUN; ODS LISTING; DATA WANT; MERGE TEST (IN=I) FREQ (KEEP=BIN N);      BY BIN;      IF I;      RETAIN CUM_PROB;      IF FIRST.BIN THEN CUM_PROB = 0;      CUM_PROB = CUM_PROB + PROB;      CUMM_PCT = CUM_PROB / N; RUN; ... View more