I've solved a problem I had in my previous post "Strip Characters From Between Two Delimiters". At work I was given a strangely formatted data file - example.
I needed to separate out the data chunks to work with it. While my first solution...
Read more »
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='31...
Read more »
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 »
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 »
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; re...
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 »
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. at...
Read more »
hello SAS Tech Report readers! be sure to check out the rest of this blog and accompanying project. you can follow this blog via rss readers and follow me on twitter. now back to the post... UPDATE: it turns out that SAS has changed some things on the...
Read more »