topic Re: how to change character values in SAS Programming

how to change character values

HitmonTran — Mon, 22 Mar 2021 20:04:22 GMT

Hi,

I have a character date that need to be imputed with dates containing '00' (day) to '01' & '000' (month) to 'jan':

data:

00-000-2013

20-000-2013

00-dec-2013

want:

01-jan-2013

20-jan-2013

01-dec-2013

Re: how to change character values

qoit — Mon, 22 Mar 2021 20:31:18 GMT

A simple SUBSTR should do it:

data have;
	infile datalines;
	input date_str $20.;
	format want_date_str $20.;
	want_date_str = date_str;

	if substr(date_str,1,2) = '00' then
		substr(want_date_str,1,2) = '01';

	if substr(date_str,4,3) = '000' then
		substr(want_date_str,4,3) = 'JAN';
	datalines;
00-000-2013
20-000-2013
00-dec-2013
;
run;

Re: how to change character values

Phil_NZ — Mon, 22 Mar 2021 20:34:26 GMT

Hi @qoit

A great code, I also thought of using substr but I did not know that substr can be used to output.

Btw, just adjust the "JAN" in your code to "jan" to align with @HitmonTran 's requirement.

Warm.