About Vortex

rajeshV89 · ‎03-16-2018

how to get a datepart and timepart from anydtdtm. data without using character functions... data mh17; format edate datetime19.; input edate anydtdtm.; datalines; 12:01:2010:11:33:45 ; run;

Ksharp · ‎05-20-2015

Your DateTime value is not right . data temp; CheckinDate= '04apr2014:17:25:00'dt; CheckoutDate= '30apr2014:23:59:59'dt; i=CheckinDate; do while(i lt CheckoutDate); date=datepart(i); output; i+3600; end; run; proc summary data=temp nway; class date; format date monyy7.; output out=want(drop= _type_ rename=(_freq_=hours)) ; run;

RW9 · ‎04-30-2015

Yes, my program should work on that. I wouldn't go with having dates as columns though. Its a bad idea in the longer term, I mean if you had a time period (not necessarily on one row, but over all data) of several years, you can end up with lots of columns with few data in. Better to keep it normalised as my output will do, or genericise the columns, e.g. COL1-COLx, so you can use arrays and fill up only the ones you need.

Ksharp · ‎05-01-2015

Here is one way: data have; input (effective expiry) (: date9.); format effective expiry date9.; cards; 03MAR2011 21MAR2011 22MAR2011 16JUN2011 17JUN2011 30SEP2011 17DEC2011 10FEB2012 ; run; data temp; set have; n+1; do date=effective to expiry; output; end; format date date9.; keep n date; run; proc summary data=temp nway; class n date; format date monyy7.; output out=temp1; run; proc transpose data=temp1 out=want(drop=_:); by n ; var _FREQ_; id date; run; Xia Keshan

Online Status	Offline
Date Last Visited	‎09-01-2015 07:12 AM

Re: How many hours each month

How many hours each month

Re: Finding number of days each month between dates

Re: Finding number of days each month between dates

Re: Finding number of days each month between dates

Finding number of days each month between dates

Re: Building an array of days in months, based off two dates

Re: How to convert character datetime to numeric datetime?

Re: How to convert character datetime to numeric datetime?

How to convert character datetime to numeric datetime?

Re: Finding number of days each month between dates

Re: How to convert character datetime to numeric datetime?

Re: How many hours each month

Re: Finding number of days each month between dates

Re: Building an array of days in months, based off two dates