Dear All, I have delimited txt file with 3 million records. I would like to convert into SAS Dataset. Please help me how can I do that ? sampele Text Records are below. "0000012121","ROSE","N","N","N","N","N","N","N" "0000002103","ROBT JENKINS","N","N","N","N","N","N","N" "0000010111","ANA MAY NAG","N","N","N","N","N","N","N" "0000010222","DAAA AA","N","N","N","N","N","N","N" "0000011333","THAA C BLUUU HEEEEEEE","N","N","N","N","N","N","N" "0000012444","MICCAAA SAAAAAAA","N","N","N","Y","Y","Y","Y" "0000013555","PATTTTTT SMITH","Y","Y","Y","Y","Y","N","Y" "0000013666","ELLMM BRAAAAA","N","N","N","N","N","N","N" "1001113777","DOK A BAAA, JR.","N","N","N","N","N","N","N" Note: 2nd field for some records, even in middle of the name, commas are there. Please suggest me how can I overcome this scenario while converting into SAS Dataset ? Regards, S Ravuri. ... View more

Dear All, We can get the count of distinct values using PROC SQL. Apart from that, I need to display the Distinct values along with count of each distinct value like below including spaces. Distinct Values       count       6                    25000       9                    40000      AS                  20000     ' '                      500000   000                    2000000 Note:   ' ' - denotes spaces . Regards, S Ravuri. ... View more

Dear All, I have a Dataset x   1   3   2   6   4   8   7   1   9 Usingn this Dataset, would like to get the smallest,largest, Mean and Median values in a single program. Is it possible ? Syntaxes for all as below: Smallest - MIN(argument,argument, ...) Largest - MAX(argument,argument, ...) Mean    - MEAN(argument,argument, ...) MEDIAN(value1<, value2, ...>) Regards, S Ravuri. ... View more