topic total days in SAS Programming https://communities.sas.com/t5/SAS-Programming/total-days/m-p/79138#M256477 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="493"><TBODY><TR><TD class="xl65" height="80" width="64">Obs</TD><TD class="xl65" style="border-left: none;" width="109">TIMESTAMP</TD><TD class="xl65" style="border-left: none;" width="64">WEEK</TD><TD class="xl65" style="border-left: none;" width="64">MONTH</TD><TD class="xl65" style="border-left: none;" width="64">YEAR</TD><TD class="xl65" style="border-left: none;" width="64">DAY</TD><TD class="xl65" style="border-left: none;" width="64">total_days from Jan 01 2013?</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/11/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">11</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/11/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">11</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">3</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/12/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">12</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">4</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/12/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">12</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">5</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/12/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">12</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">6</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">7</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">8</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">9</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">10</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">11</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">12</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">13</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">14</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">15</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/15/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">15</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">16</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/18/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">18</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>How to calculate the total days from first day of 2013 based on the timestamp? Thanks!</P></BODY></HTML> Wed, 11 Sep 2013 20:52:15 GMT peppapig 2013-09-11T20:52:15Z total days https://communities.sas.com/t5/SAS-Programming/total-days/m-p/79138#M256477 <HTML><HEAD></HEAD><BODY><TABLE border="0" cellpadding="0" cellspacing="0" width="493"><TBODY><TR><TD class="xl65" height="80" width="64">Obs</TD><TD class="xl65" style="border-left: none;" width="109">TIMESTAMP</TD><TD class="xl65" style="border-left: none;" width="64">WEEK</TD><TD class="xl65" style="border-left: none;" width="64">MONTH</TD><TD class="xl65" style="border-left: none;" width="64">YEAR</TD><TD class="xl65" style="border-left: none;" width="64">DAY</TD><TD class="xl65" style="border-left: none;" width="64">total_days from Jan 01 2013?</TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">1</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/11/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">11</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/11/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">11</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">3</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/12/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">12</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">4</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/12/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">12</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">5</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/12/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">12</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">6</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">7</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">8</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">9</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">10</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/13/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">13</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">11</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">12</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">13</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">14</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/14/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">14</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">15</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/15/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">6</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">15</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR><TR><TD class="xl65" height="20" style="border-top: none;" width="64">16</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;" width="109">2/18/2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">7</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">2013</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;" width="64">18</TD><TD class="xl68" style="border-top: none; border-left: none;"> </TD></TR></TBODY></TABLE><P></P><P>How to calculate the total days from first day of 2013 based on the timestamp? Thanks!</P></BODY></HTML> Wed, 11 Sep 2013 20:52:15 GMT https://communities.sas.com/t5/SAS-Programming/total-days/m-p/79138#M256477 peppapig 2013-09-11T20:52:15Z Re: total days https://communities.sas.com/t5/SAS-Programming/total-days/m-p/79139#M256478 <HTML><HEAD></HEAD><BODY><P>INTCK, it worked. Thanks!</P></BODY></HTML> Wed, 11 Sep 2013 21:03:41 GMT https://communities.sas.com/t5/SAS-Programming/total-days/m-p/79139#M256478 peppapig 2013-09-11T21:03:41Z