suppose i’ve got some odd character dates defined as follows:
d1='29-31 DEC 2009,04-05 JAN 2010'; *broken across month, year;
d2='04-05,08-09,11-12 FEB 2010'; *broken within month;
d3='01-03 MAR 2010'; *contiguous within month;
d4=...
Read more »
i’ve been using sas for roughly 5 years now. for the past few years, i’ve been building up my toolbox of what i call ‘utility macros’. these are macros that are generic enough to be used in a wide variety of situations, but perform very specifi...
Read more »
a while ago, i took the hack shortcut of reading character datetime stamps into datetime values. i even went so far as suggesting a regex would be a better solution.
well, here’s that better solution:
data mmddyyyy_hhmmss_xm;
if _n_=1 then do;
...
Read more »
this is a cross posting from this sas discussion forum. assuming you know the min and max of allowable dates (01jan2005 - 30jun2009, for example), you can use random functions. data randates; mindate='01jan2005'd; maxdate='30jun2009'd; range = max...
Read more »
this is summarizes my response to a thread on the SAS Discussion Forums in the original post, the poster wanted “…to calculate the length of time (mean, median, and mode) between when a record was created (“date reported” in my database) and w...
Read more »
for a little over a year now, i’ve been enjoying a little macro i wrote for writing date values in a variety of formats. the macro also integrates the intnx function (hence the ‘dynamic’ part). this allows me to easily use dynamic dates in both o...
Read more »
first step, build encoding tables based on the documentation: data encSimple encEnhanced; s='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789-.'; format raw 8. enc $8.; raw=.; enc='_'; output encSimple; enc='__'; output encEnhanced;...
Read more »
if you’re in the same boat as me, you’ve got sas 9.1.3 sp4 installed under windows. the thing about sas 9.1.3 sp4 running under windows is the lrecl is limited to 32,767 characters. (even though the sas kb says 1mb, that doesn’t appear to be true...
Read more »