topic Re: write sas program in SAS Programming

write sas program

niladri_routray — Tue, 18 Apr 2017 12:08:01 GMT

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)

Re: write sas program

Kurt_Bremser — Tue, 18 Apr 2017 12:15:56 GMT

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.

Re: write sas program

PeterClemmensen — Tue, 18 Apr 2017 12:22:52 GMT

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;

Re: write sas program

niladri_routray — Tue, 18 Apr 2017 12:48:01 GMT

thanks for the reply.