topic Re: mmdd format in New SAS User

mmdd format

Raj00007 — Wed, 12 Aug 2020 17:43:20 GMT

hi, I have a date 05/13 in a variable named 'date'.

1) now i want to split, date and month. How to split the date as day and month.

2) its is also in character format. how do i convert it to numeric..

date

05/13.

i want this as day month

13 05

Re: mmdd format

Reeza — Wed, 12 Aug 2020 19:58:13 GMT

SCAN() will allow you to separate the components based on a delimiter, in this case your /.
INPUT() will convert the values to numeric.

Another approach is to read it in as a date and then use DAY() and MONTH() functions.

data example;
	have='05/13';
	
	*character extraction;
	month_char=scan(have, 1, '/');
	day_char=scan(have, 2, '/');
	
	*conversion to numeric;
	month_num=input(month_char, 8.);
	day_char=input(day_char, 8.);
	
	*same as above but single step;
	month_num2=input(scan(have, 1, '/'), 8.);
	day_num2=input(scan(have, 2, '/'), 8.);
	
	*date method - requires year or custom informat;
	have_date=input(catt(have, '/2020'), mmddyy10.);
	month_num3=month(have_date);
	day_num3=day(have_date);
run;

Re: mmdd format

Raj00007 — Wed, 12 Aug 2020 17:50:24 GMT

i tried using day and month functions, but it is showing error. can you please write the code here

Re: mmdd format

Reeza — Wed, 12 Aug 2020 17:53:44 GMT

Show your code please. You cannot use MONTH/DAY() on a character variable so you first need to convert it.

Re: mmdd format

Raj00007 — Wed, 12 Aug 2020 18:08:29 GMT

data springrain;
set lib.SPRING_RAIN;
num = input (date, mmdd5.);
day = day (num);
month = month (num);
run;
proc print;
run;

here the informat mmdd5. says invalid. what is the right informat for 05/13 . and also day and month functions are no working.

Re: mmdd format

Reeza — Wed, 12 Aug 2020 18:47:40 GMT

There is no informat for just mmdd so you need to either add the year or create a custom informat.

Re: mmdd format

ballardw — Wed, 12 Aug 2020 19:03:20 GMT

Since a SAS date value must have a year there cannot be an informat to create a date from something without a year value.

Your best bet is likely to parse the character value and create numeric values of Month and Day and then create a date with the MDY function where you supply the year value.

Re: mmdd format

PaigeMiller — Wed, 12 Aug 2020 19:40:12 GMT

month=scan(date,1,'/');

day=scan(date,2,'/');