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
See
Convert Numeric Variables to Character - sasCommunity
However, the technique might be defeated by the sheer number of columns.
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
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.
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.
Thanks I will do that, bests
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.