topic Re: Problem when converting separated date time year month variables into datetime in SAS Programming

Problem when converting separated date time year month variables into datetime

WorkingMan — Mon, 01 Oct 2018 05:07:35 GMT

Hi, I've asked similar question few days back but this time round, the situation is a lil bit different.

I have 4 variables of date time combination that i want to merge them into a datetime column. Variables as below

Day is numeric

Month is Character(January February....)

Year is numeric

Time is CHARACTER

Take note that my original data contains   before i split them into 4 individual variable (day month year time). Hence you will see i use scan and then input.

now the issue is, i tried converting the character time by using :

INPUT(chartime,time.)

but it will give me the time in 10000 or 73000 or 56800 value instead of 10:00 and etc

so here are my code

proc format;
invalue inmonth
  'January' = 1
  'February' = 2
  'March' = 3
  'April' = 4
  'May' = 5
  'June' = 6
  'July' = 7
  'August' = 8
  'September' = 9
  'October' = 10
  'November' = 11
  'December' = 12
;

data converttonewdatetime;
    length 	demand_occurence_day 8 demand_occurence_month $10 demand_occurence_year 8 demand_occurence_time 
		demand_occurence_newdate 8 newdemand_occurence_date 8;


demand_occurence_day=scan(demand_occurence,1,'&nbsp;');
	   demand_occurence_month=scan(demand_occurence,2,'&nbsp;');
	   demand_occurence_year=scan(demand_occurence,3,'&nbsp;');
	   demand_occurence_time=input(scan(demand_occurence,-1,'&nbsp;'),time.);
		demand_occurence_newdate=mdy(input(demand_occurence_month,inmonth.),demand_occurence_day,demand_occurence_year);
		newdemand_occurence_date = dhms(demand_occurence_newdate,0,0,demand_occurence_time);

run;

What did i do wrong?

The result set is as below.

Re: Problem when converting separated date time year month variables into datetime

Patrick — Mon, 01 Oct 2018 05:43:07 GMT

Have you checked your log?

Your informat inmonth. doesn't match your data (only 3 letter months in data). I would assume this results in a missing date and some SAS warning or at least a note about missing data generated.

Re: Problem when converting separated date time year month variables into datetime

WorkingMan — Mon, 01 Oct 2018 06:49:51 GMT

You mean the function mdy? I cannot see 3 words data Patrick. Can you help me further ?

Re: Problem when converting separated date time year month variables into datetime

Kurt_Bremser — Mon, 01 Oct 2018 06:56:31 GMT

You have not assigned a display format to demand_occurence_time, so you see the raw value (count in seconds).

The same is true for the date and the datetime.