Date format question

[evaaseow]

Hi I want to take a datetime field and reformt it so it looks like 'YYYYMM'.

Is this possible in SAS?

 

[klaz2002]

Here try this:

data _null_;
  x = datetime(); *** THIS IS THE DATETIME VALUE ***;
  y = datepart(x);*** THIS IS THE DATE PORTION   ***;
  put x= y=;
  format x worddate32. y yymmn6.;*** NOTICE THE FORMAT FOR YYYYMM ***;
run;

Now that you understand the theory here is the shorter version.

formated_date = put(datepart(datetime_value),yymmn6.);

Hope this helps you.
Klaz

 

[evaaseow]

I tried this but i'm getting format not found or could not be loaded.

 

[klaz2002]

What version of SAS are you using? I tried this on versions 6, 8 & 9 and it works with all of them. Perhaps, you can contact SAS tech support for why you can't access this format.
Klaz

 

[evaaseow]

Using Base SAS 9.1