지식노동자의 노트

문자형 날짜시간값을 SAS datetime으로...... 본문

SAS

문자형 날짜시간값을 SAS datetime으로......

생각하는너구리 2010. 8. 4. 21:35
728x90


data _test01;


char_begin_date = "20100703120340"; /*201073112340*/

char_end_date = "20100801150340"; /*20108115340*/

put char_begin_date char_end_date;


begin_mdy = mdy(substr(char_begin_date,5,2),substr(char_begin_date,7,2),substr(char_begin_date,1,4)); /*시작년월일*/

begin_hms = hms(substr(char_begin_date,9,2),substr(char_begin_date,11,2),substr(char_begin_date,13,2));/*시작시분초*/

end_mdy = mdy(substr(char_end_date,5,2),substr(char_end_date,7,2),substr(char_end_date,1,4));

end_hms = hms(substr(char_end_date,9,2),substr(char_end_date,11,2),substr(char_end_date,13,2));


num_begin_date = (begin_mdy * 24 * 60 * 60) + begin_hms ;

num_end_date = (end_mdy * 24 * 60 * 60) + end_hms ;

format num_begin_date num_end_date datetime16.;

run;


반응형
Comments