Date: Tue, 9 Mar 2010 09:35:28 -0500
Reply-To: Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Nathaniel Wooding <nathaniel.wooding@DOM.COM>
Subject: Selecting dates in a period. Was RE: new joinee
Content-Type: text/plain; charset="us-ascii"
While I can suspect where the problem lies, could you post (to the group, not just to me) the actual code that you used. That would help a lot.
From: sasbond1981 sasbond1981 [mailto:firstname.lastname@example.org]
Sent: Tuesday, March 09, 2010 9:14 AM
To: Nathaniel Wooding (Services - 6)
Cc: SAS-L@listserv.uga.edu; SAS-Lemail@example.com
Subject: Re: new joinee
need suggestion please..
Suppose I have a dataset containing two variables "Start_Date and End_Date" and here I need to create a variable called "period".
Here the start and end dates were in Datetime format and I took only datepart by "datepart" function and formated it as date9. And created "Period" variable by giving some logic as
" MDY(month(today()),1,year(today()))-1 "
which will give value as "FEB2010" (which is Monyy7. format). So now based on this period variable I need to pull only the FEB month data from years of data.
Actually the data contains two years (historical) data till last month.
START_DATE END_DATE PERIOD
01FEB2010 01FEB2010 JAN2010
01FEB2010 02FEB2010 JAN2010
16JUL2009 16JUL2009 JAN2010
19DEC2009 20DEC2009 JAN2010
21JAN2010 22FEB2010 JAN2010
26FEB2010 26FEB2010 JAN2010
30JAN2010 30JAN2010 JAN2010
31DEC2009 31DEC2009 JAN2010
the above is the sample data... now what I need is based on this period I need to pull only Feb dates starting from 01FEB2010 and ending of 31FEB2010. So in simple I want FEB data only.
START_DATE is in date9. format
END_DATE is in date9. format
Period is in Monyy7. format
I tried with between and >= and <= and etc etc... but it is not workin for me... please give me ur idea on this...
CONFIDENTIALITY NOTICE: This electronic message contains
information which may be legally confidential and or privileged and
does not in any case represent a firm ENERGY COMMODITY bid or offer
relating thereto which binds the sender without an additional
express written confirmation to that effect. The information is
intended solely for the individual or entity named above and access
by anyone else is unauthorized. If you are not the intended
recipient, any disclosure, copying, distribution, or use of the
contents of this information is prohibited and may be unlawful. If
you have received this electronic transmission in error, please
reply immediately to the sender that you have received the message
in error, and delete it. Thank you.