How to append 2 datasets having dataset1 has one column is character type and in dataset2 for same column is numeric.
example:
dataset1:- 19/02/2017 (numeric)
dataset2:- 19feb17(character)
Convert your variable in your second dataset (SAS date variables are better for date values than character variables):
data dataset2;
set dataset2 (rename=(date=_date));
format date ddmmyy10.;
date = input(_date,date7.);
drop _date;
run;
Then you can append without problems.
thanks for the reply.
This converts the numeric to character so they are comparable
data have;
informat date1 DDMMYY10.;
format date1 DDMMYY10.;
input date1 date2 $;
datalines;
19/02/2017 19feb17
;
data want(drop = date1);
set have;
length date3 $8.;
format date1 date7.;
date2 = upcase(date2);
date3 = cats(date1);
run;
proc contents data = want;
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.