LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (September 2008, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 23 Sep 2008 09:04:12 -0400
Reply-To:     Nathaniel.Wooding@DOM.COM
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nat Wooding <Nathaniel.Wooding@DOM.COM>
Subject:      Re: creating variables based on dates range
Comments: To: "edina.cmanjcanin@gmail.com" <edina.cmanjcanin@GMAIL.COM>
In-Reply-To:  <efc56cf1-a4f8-4351-8a8a-dbcd0725c4b5@d1g2000hsg.googlegroups.com>
Content-Type: text/plain; charset="US-ASCII"

Dina

Try the following code:

Data period; informat CustomerID 8. date $10. article $3. ; input CustomerID Date Article ; cards; 1 02.01.2008 KTM 1 03.01.2008 FTM 1 18.01.2008 KTM 1 02.02.2008 BBS run; proc print;run; Data period;* I am doing this in a second data step based on the assumption that date is stored as a character string and not as a sas date variable. If date is actually a sas date variable, then Period = put( Month( Date ) , Worddate9. ); set period; Period = put( Month( input ( Date , ddmmyy10. ) ) , Worddate9. ); run; Proc Print; run;

Nat Wooding Environmental Specialist III Dominion, Environmental Biology 4111 Castlewood Rd Richmond, VA 23234 Phone:804-271-5313, Fax: 804-271-2977

"edina.cmanjcanin @gmail.com" <edina.cmanjcanin To @GMAIL.COM> SAS-L@LISTSERV.UGA.EDU Sent by: "SAS(r) cc Discussion" <SAS-L@LISTSERV.U Subject GA.EDU> creating variables based on dates range

09/23/2008 08:45 AM

Please respond to "edina.cmanjcanin @gmail.com" <edina.cmanjcanin @GMAIL.COM>

Hello

I need to create new variable "Period" based on observation Dates. To be more accurate, if observation Dates is in time period (eg. from 01.01.2008 - 01.02.2008 ) to add new values "Januar" to that observation so on...

example

my data

Customer ID | Date | Article

1 02.01.2008 KTM 1 03.01.2008 FTM 1 18.01.2008 KTM 1 02.02.2008 BBS 2 ... ........ ...

1455 05.01.2008 OEK

...

results should look like

Customer ID | Date | Article | Period

1 02.01.2008 KTM Januar 1 03.01.2008 FTM Januar 1 18.01.2008 KTM Januar 1 02.02.2008 BBS Februar 2 ... ........ ...

1455 05.05.2008 OEK May

After that I will group my data by period, and try to find how many articles was bought in Januar or some other period.

Thx for your help

Dina

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.


Back to: Top of message | Previous page | Main SAS-L page