I have a file that is in CSV format. The time stamps are in the format which I have now successfully imported into sas (thanks to a member named Art).
Once in SAS the formatting looks like
08APR11:04:00:00
16APR11:04:00:00
These corresond to April 8, 2011 @ 4:00 UTC and April 16, 2011 @ 4:00 UTC.
What I am hoping to do is to separate each portion of the date out into its own variable such as Year, Month, Day, Hour, Minute.
I have typically done this in the past when my data is formatted as YYMMDDN8. by simply using newvar = year(date_var) or newvar = month(date_var), etc...
This method does not seem to work with my dates formatted as DATETIME16. and informat E8601DZ16. However, This formatting is required to import the original CSV file where the date are formatted
2011-12-30T05:00:00Z
2012-04-09T04:00:00Z
2014-03-10T04:00:00Z
The import code I use (which was provided by Art) is below
data WORK.ABC ;
infile 'E:\Research\Data\filename.csv' delimiter = ',' MISSOVER DSD lrecl=32767 firstobs=2 ;
informat SOURCE $10. ;
informat SYMBOL $4. ;
informat TIMESTAMP_UTC e8601dz. ;
informat BULLISH_INTENSITY best32. ;
informat BEARISH_INTENSITY best32. ;
informat BULL_MINUS_BEAR best32. ;
informat BULL_SCORED_MESSAGES best32. ;
informat BEAR_SCORED_MESSAGES best32. ;
informat BULL_BEAR_MSG_RATIO best32. ;
informat TOTAL_SCANNED_MESSAGES best32. ;
format SOURCE $10. ;
format SYMBOL $4. ;
format TIMESTAMP_UTC datetime. ;
format BULLISH_INTENSITY best12. ;
format BEARISH_INTENSITY best12. ;
format BULL_MINUS_BEAR best12. ;
format BULL_SCORED_MESSAGES best12. ;
format BEAR_SCORED_MESSAGES best12. ;
format BULL_BEAR_MSG_RATIO best12. ;
format TOTAL_SCANNED_MESSAGES best12. ;
input
SOURCE $
SYMBOL $
TIMESTAMP_UTC
BULLISH_INTENSITY
BEARISH_INTENSITY
BULL_MINUS_BEAR
BULL_SCORED_MESSAGES
BEAR_SCORED_MESSAGES
BULL_BEAR_MSG_RATIO
TOTAL_SCANNED_MESSAGES
;
run;
I am at a loss here so anyhelp would be greatly appreciated!
Thanks
