Please post your code (use the "little running man" icon) and the respective lines from the file (use the {i} button). ... View more

As mentioned by @FreelanceReinh, use lenghtn() instead of length(). ... View more

Hi: I'm not sure what you mean by "fields" -- numeric variables, character variables? What do you mean by summary? You want the N (Count), you want the sum of all numeric variables, you want the min, mean, max of all numeric variables? You say that you want to get a summary "on all fields dynamically" -- by this statement, I would assume that all your "fields" are numeric values and perhaps that you don't want to list them out in a COLUMN statement? What code have you tried? What does your data set look like ...does it look more like SASHELP.CLASS or SASHELP.SHOES? Can you clarify? Cynthia ... View more

@Sir_Lancelot wrote: I am trying to compare two fields and output the difference. Please see below example:   field_1 field_2 results 003,004,006 003,004 006 002,003,005 002,005 003 003,004 003,004,006 006 002,005 002,003,005 003   Thanks in advance And perhaps yet another example why having multiple values in a single field such as "003, 004, 006" is a poor idea in general. ... View more

Not used db2 in a very long time, so can't remember.  I think there is a: server= ,option.  ... View more