topic How can I get the Month and Year as New variable extracted from dates on another variable? in SAS Enterprise Guide

How can I get the Month and Year as New variable extracted from dates on another variable?

nyedetsy — Tue, 14 Jul 2015 19:14:32 GMT

Here is the coding that I need to use:

PROC SQL;

CREATE TABLE WORK.FILTER_FOR_XXXX AS

SELECT t1.sale_dt,

t1.DUE_DT,

t1.TOWN,

t1.POSTAL_CD,

t1.PROV_CD,

t1.COMPETITION,

t1.AGENT_CD,

t1.STORE,

t1.MRKT,

t1.AGENT_ID,

FROM WORK.FILTER_FOR_XXXX

WHERE TOWN = 'NY' AND t1.sale_dt > 19724

ORDER BY t1.sale_dt;

QUIT;

I have sale dates in variable t1.sale_dt appearing as for example 11JAN2014 (in French) etc.. I want to add to more variables one for the Month January (or 1) and the second for the Year 2014. Which exact coding should I add to have it please?

thank you.

Re: How can I get the Month and Year as New variable extracted from dates on another variable?

dcruik — Tue, 14 Jul 2015 19:26:20 GMT

This should work for you:

PROC SQL;

CREATE TABLE WORK.FILTER_FOR_XXXX AS

SELECT t1.sale_dt,

month(t1.sale_dt) as Month format=2.,

year(t1.sale_dt) as Year format=4.,

t1.DUE_DT,

t1.TOWN,

t1.POSTAL_CD,

t1.PROV_CD,

t1.COMPETITION,

t1.AGENT_CD,

t1.STORE,

t1.MRKT,

t1.AGENT_ID

FROM WORK.FILTER_FOR_XXXX

WHERE TOWN = 'NY' AND t1.sale_dt > 19724

ORDER BY t1.sale_dt;

QUIT;

Re: How can I get the Month and Year as New variable extracted from dates on another variable?

nyedetsy — Tue, 14 Jul 2015 19:31:34 GMT

THank you!!!