Extracting just the month as a new variable from a complete date

Hi,

I have a variable that shows me the date of funding in the format, "day, dd/month/year, time" and the chances of being funded (i.e successful/unsuccessful). As there is much data, I would just like to extract the month from the full date to see which months am I more likely to be funded. Could you please help me with the code? Thank you very much.

Code:

* Example generated by -dataex-. To install: ssc install dataex
clear
input str31 fundeddate str10 status
"Mon, 01 Aug 2011 15:12:26 -0000" "successful"
"Mon, 04 Apr 2011 00:41:32 -0000" "successful"
"Thu, 10 Mar 2011 22:38:51 -0000" "failed"    
"Sat, 09 Jun 2012 15:53:56 -0000" "live"      
"Fri, 14 Oct 2011 17:15:49 -0000" "successful"
"Thu, 17 Nov 2011 04:00:00 -0000" "successful"
"Fri, 01 Apr 2011 21:17:39 -0000" "successful"
"Thu, 03 Mar 2011 22:35:22 -0000" "successful"
"Wed, 07 Jul 2010 21:57:00 -0000" "failed"    
"Sun, 20 Mar 2011 15:28:49 -0000" "successful"
"Mon, 08 Aug 2011 06:59:00 -0000" "successful"
"Thu, 16 Jun 2011 23:30:12 -0000" "failed"    
"Thu, 17 Nov 2011 04:59:00 -0000" "successful"
"Sun, 05 Jun 2011 04:00:00 -0000" "failed"    
"Wed, 16 Dec 2009 05:00:00 -0000" "successful"
"Fri, 22 Jun 2012 18:07:00 -0000" "live"      
"Sun, 16 Oct 2011 21:00:00 -0000" "successful"
"Sat, 30 Jun 2012 02:42:00 -0000" "live"      
"Fri, 04 Mar 2011 22:14:45 -0000" "failed"    
"Tue, 17 May 2011 02:00:00 -0000" "successful"
"Thu, 06 Jan 2011 06:42:41 -0000" "successful"
"Sat, 02 Jun 2012 03:48:00 -0000" "successful"
"Mon, 02 May 2011 22:39:50 -0000" "successful"
"Thu, 02 Jun 2011 18:40:45 -0000" "failed"    
"Sun, 14 Aug 2011 20:51:18 -0000" "successful"
"Wed, 20 Jun 2012 04:00:00 -0000" "live"      
"Mon, 13 Sep 2010 03:00:00 -0000" "successful"
"Fri, 19 Aug 2011 14:52:18 -0000" "successful"
"Sat, 17 Sep 2011 16:08:06 -0000" "failed"    
"Thu, 21 Oct 2010 16:02:57 -0000" "successful"
"Sat, 12 May 2012 23:06:49 -0000" "successful"
"Fri, 13 Aug 2010 17:00:00 -0000" "failed"    
"Fri, 18 Mar 2011 21:57:53 -0000" "failed"    
"Wed, 16 May 2012 04:00:00 -0000" "successful"
"Sun, 20 May 2012 10:00:00 -0000" "successful"
"Fri, 30 Mar 2012 11:49:52 -0000" "failed"    
"Thu, 14 Jun 2012 15:26:26 -0000" "live"      
"Wed, 13 Jul 2011 05:29:19 -0000" "successful"
"Sun, 03 Oct 2010 01:13:17 -0000" "successful"
"Fri, 16 Apr 2010 03:59:00 -0000" "successful"
"Tue, 15 Feb 2011 04:59:00 -0000" "successful"
"Tue, 29 Mar 2011 02:48:05 -0000" "successful"
"Sun, 27 Feb 2011 02:18:30 -0000" "failed"    
"Fri, 19 Aug 2011 19:48:41 -0000" "successful"
"Wed, 15 Feb 2012 09:00:00 -0000" "failed"    
"Sat, 07 Jul 2012 03:21:14 -0000" "live"      
"Tue, 01 Sep 2009 19:00:00 -0000" "successful"
"Sat, 20 Nov 2010 23:56:07 -0000" "successful"
"Sun, 21 Nov 2010 02:00:08 -0000" "failed"    
"Sat, 01 Oct 2011 00:57:00 -0000" "successful"
"Mon, 10 Oct 2011 03:18:04 -0000" "successful"
"Sun, 11 Jul 2010 00:14:00 -0000" "successful"
"Tue, 24 Apr 2012 23:18:50 -0000" "failed"    
"Sat, 28 Apr 2012 21:32:15 -0000" "successful"
"Mon, 21 May 2012 08:15:25 -0000" "failed"    
"Thu, 22 Sep 2011 06:55:26 -0000" "successful"
"Mon, 09 Jan 2012 15:11:28 -0000" "failed"    
"Sun, 27 May 2012 12:11:12 -0000" "failed"    
"Wed, 15 Jun 2011 18:27:42 -0000" "failed"    
"Mon, 02 Jan 2012 03:32:04 -0000" "failed"    
"Thu, 12 Apr 2012 15:32:19 -0000" "successful"
"Mon, 18 Jun 2012 13:02:11 -0000" "live"      
"Wed, 06 Jun 2012 12:55:05 -0000" "live"      
"Fri, 30 Mar 2012 15:02:00 -0000" "successful"
"Thu, 25 Aug 2011 18:57:52 -0000" "successful"
"Mon, 23 Apr 2012 05:59:00 -0000" "failed"    
"Fri, 01 Jun 2012 21:07:55 -0000" "failed"    
"Fri, 31 Dec 2010 17:00:00 -0000" "successful"
"Mon, 14 Jun 2010 23:01:00 -0000" "failed"    
"Sun, 20 May 2012 17:19:34 -0000" "failed"    
"Mon, 11 Apr 2011 15:16:25 -0000" "successful"
"Sat, 07 Jan 2012 02:31:00 -0000" "successful"
"Tue, 01 Nov 2011 04:59:00 -0000" "successful"
"Tue, 13 Mar 2012 03:59:00 -0000" "successful"
"Fri, 16 Dec 2011 09:34:22 -0000" "successful"
"Sun, 03 Jun 2012 02:59:00 -0000" "live"      
"Fri, 19 Nov 2010 19:43:56 -0000" "successful"
"Tue, 21 Jun 2011 06:59:00 -0000" "failed"    
"Wed, 07 Sep 2011 14:00:00 -0000" "successful"
"Thu, 26 May 2011 00:38:00 -0000" "successful"
"Tue, 24 Jan 2012 19:17:46 -0000" "failed"    
"Fri, 22 Jun 2012 23:00:00 -0000" "live"      
"Fri, 27 Jan 2012 00:11:28 -0000" "successful"
"Wed, 21 Mar 2012 15:25:16 -0000" "successful"
"Fri, 22 Jul 2011 19:00:00 -0000" "successful"
"Sun, 26 Feb 2012 04:20:40 -0000" "successful"
"Sun, 01 Jan 2012 06:44:19 -0000" "failed"    
"Wed, 30 May 2012 16:23:57 -0000" "successful"
"Thu, 19 Apr 2012 04:19:00 -0000" "successful"
"Sun, 16 Jan 2011 15:21:46 -0000" "failed"    
"Thu, 23 Jun 2011 17:55:50 -0000" "successful"
"Wed, 06 Jun 2012 21:08:14 -0000" "live"      
"Sat, 01 May 2010 03:59:00 -0000" "failed"    
"Thu, 13 Oct 2011 11:01:28 -0000" "failed"    
"Mon, 24 May 2010 20:59:00 -0000" "successful"
"Sat, 19 May 2012 03:28:15 -0000" "failed"    
"Fri, 09 Dec 2011 08:43:10 -0000" "failed"    
"Sat, 24 Sep 2011 19:12:20 -0000" "failed"    
"Sun, 01 Jan 2012 18:00:00 -0000" "failed"    
"Sun, 01 Jul 2012 15:11:19 -0000" "live"      
end

BJ Data Tech Solution

Home / Data Cleaning / Data management / Data Processing / Extracting just the month as a new variable from a complete date
Extracting just the month as a new variable from a complete date

0 Response to Extracting just the month as a new variable from a complete date

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Extracting just the month as a new variable from a complete date Extracting just the month as a new variable from a complete date

0 Response to Extracting just the month as a new variable from a complete date

Post a Comment

Home / Data Cleaning / Data management / Data Processing / Extracting just the month as a new variable from a complete date
Extracting just the month as a new variable from a complete date