How to convert all numeric columns to character columns in one shot using SAS

[Peter_C]

Tom

Please accept my apologies if the phrasing in my most recent posting appears addressed to you.

I really meant to be addressing the original poster.

kind regards

and compliments of the season

peterC

[Howles]

See

Convert Numeric Variables to Character - sasCommunity

However, the technique might be defeated by the sheer number of columns.

[MAXISAS]

Thanks everyone for their generous answer, I have one more question which is how to append two datasets (lets say data1 and data1) which has the same number of rows append horizontally (I dont want to merge or sort just glue two files horizontally)? thanks for your help in advance

btw, Im new to this website and I dont know if I should make new discussion if I have question or just continue to ask questions on the same discussion?

Bests

[Reeza]

You should make a new discussion and mark the correct/helpful answers in this post. If none are the exact answer, check your first post to mark the question: Assumed Answered.

[art297]

You really should ask new questions by starting a new discussion, as well as give people credit for providing responses (i.e., helpful and correct where applicable).

However, assuming your two files are data1 and data2, you can "glue" them together by using a datastep. e.g.:

data want;

set data1;

set data2;

run;

Of course, you may have to drop or rename some variables in the event variables of the same name exist in the two datasets.

[MAXISAS]

Thanks I will do that, bests