topic Trimming dates to yyyy only in SAS Procedures

Trimming dates to yyyy only

Woody_UNCW — Mon, 16 Jun 2014 01:34:58 GMT

How can I reformat a date from mmmyy7. to yyyy only? The data set I’m working in has multiple years of data. I want to strip/trim the ddMMM from the YYYY, i.e. leaving on the YYYY.

Message was edited by: Woody Sutton

Re: Trimming dates to yyyy only

Ksharp — Mon, 16 Jun 2014 02:18:10 GMT

data x;
 x='01jan2012'd;
 format x year4.;
 run;

Xia Keshan

Re: Trimming dates to yyyy only

RW9 — Mon, 16 Jun 2014 07:59:52 GMT

Hi,

Or:

data x;

x='01jan2012'd;

y=year(x);

run;

Re: Trimming dates to yyyy only

ballardw — Mon, 16 Jun 2014 14:49:54 GMT

Actually with SAS dates I wouldn't change any values unless you want to add a new variable to a data set. Most analysis functions will use a formatted value and in your case that format would be YEAR4. when you need it. If you modify the date value I would bet that in short order someone will want quarterly or monthly summaries. Which with the original date value means you likely only have to change ther format to one appropriate. You don't even have to make the format change permanent, use at run time. However Proc Datasets will let you change change the default format by code or open the dataset in the SAS explorer in column view, click on the variable and type the desired format in the format box.

To build a new variable: Year=year(datevalue);

Re: Trimming dates to yyyy only

Woody_UNCW — Mon, 16 Jun 2014 14:57:36 GMT

thank you all for your help. i was successful in formatting the data.