Please post an example of your source dataset (see my footnotes for hints how to post example datasets), and what you expect to get out of it. ... View more

Again without code this is a guess, but you can't replace a data set while it's open. Make sure to check your log in the future, the errors are usually noted there. ... View more

@kmj636  You wrote -"Thanks again - the SAS community people are the best"   We the community(you included) are a team we are the best. It's fun to be here. I like the slogan "ask, find and share" by our managers @ChrisHemedinger et al. I am glad to be so active here that indirectly made my fellow class mates at my university use SAS  ... View more

Some actual example data and desired results might be helpful.   For some uses perhaps a multilabel format would work, but only a few procedures will honor multilabel such as Proc Tabulate, Report and Means/Summary. ... View more

@kmj636 wrote: I really apologize and appreciate your view and time. Yes, it should be and is "then output." I am still not able to see the contributing observations to the totals from the by groups. Even though your code was incorrect and omitted the word "then", if you remove this line entirely, you will see the contributing observations. ... View more

Reading the documentation can actually help. For instance from the online help for CATX:   Length of Returned Variable In a DATA step, if the CATX function returns a value to a variable that has not previously been assigned a length, then that variable is given a length of 200 bytes. If the concatenation operator (||) returns a value to a variable that has not previously been assigned a length, then that variable is given a length that is the sum of the lengths of the values that are being concatenated.   So this paragraph shows why you may get different lengths with y = catx(',', var1, var2); and y = var1||','||var2;   when y has not had a length assigned. ... View more

Thank you! ... View more