topic Re: Converting a datetime variable into two other date formats in SAS Data Management

Converting a datetime variable into two other date formats

TurnTheBacon — Thu, 25 Oct 2012 11:35:13 GMT

I have a datetime macrovariable called &extract_dttm, which has the value 31OCT12:23:59:59. Based on this, I need to create two additional macrovariables:

&period_dt, which should get the value 31OCT2012.

&period_yyyymm, which should get the value 201210.

Can someone please advise me on how to accomplish this in the precode of an Extract transformation?

Thank you.

Re: Converting a datetime variable into two other date formats

Linlin — Thu, 25 Oct 2012 12:03:58 GMT

24 %let d=31OCT12:23:59:59;

25 %let dd=%sysfunc(putn(%sysfunc(datepart("&d"dt)),date9));

26 %put &dd;

31OCT2012

27 %let ddd=%sysfunc(putn("&dd"d,yymmn6.));

28 %put &ddd;

201210

Re: Converting a datetime variable into two other date formats

Tom — Thu, 25 Oct 2012 12:07:56 GMT

%let x=31OCT2012:23:59:59 ;

%let y=%sysfunc(putn("&x"dt,dtdate9.));

%let z=%sysfunc(putn("&y"d,yymmddn8.),$6.);

x=31OCT2012:23:59:59

y=31OCT2012

z=201210

Re: Converting a datetime variable into two other date formats

Patrick — Thu, 25 Oct 2012 12:08:53 GMT

%let extract_dttm=31OCT12:23:59:59;

%let period_dt=%sysfunc(inputn(&extract_dttm,datetime.),dtdate9.);

%put period_dt=&period_dt;

%let period_yyyymm=%sysfunc(inputn(&period_dt,date9.),yymmn6.);
%put period_yyyymmt=&period_yyyymm;

Re: Converting a datetime variable into two other date formats

data_null__ — Thu, 25 Oct 2012 12:26:07 GMT

First create extract_dttm as a SAS datetime value. Then you can write the value in any format with out having to do the conversion everything you need it.

%let extract_dttm = 31OCT12:23:59:59;

%let dt=%sysevalF("&extract_dttm"dt);

%let period_dt = %sysfunc(putn(&dt,dtdate,9));
%let period_yyyymm =%sysfunc(datepart(&dt),yymmn6);