a function to mask strings 21Jul2020 1267 words » sql here’s a handy function to mask strings while retaining some useful metadata....
setlist events in go 07Apr2020 155 words » golang Over the past few months, I’ve been toying around with go. Python has never r...
Wallets 01Aug2017 254 words » review I’ve gone through a number of wallets over the years. a studded Fossil wa...
shifty metadata 18Jul2017 141 words sas » function, excel I’ve got a set of Excel files (.xlsx) containing weekly spend breakouts. Thes...
Simplenote to Vesper 02Mar2015 450 words » app It started with a tweet from @benjaminbrooks: Has anyone written a tool to m...
Current file path 30Oct2014 34 words sas » snippet Sometimes I need to reference the path of the current (saved) file. Thanks to...
finding conventions, establishing standards 27Aug2014 131 words sas » perl I’m creating a perl script that reads through all .sas files in a directory t...
we blew it 22Aug2014 52 words post » twitter Thomas Brand on the hoopla surrounding twitter’s new timeline: As far as ...
getOption 18Aug2014 71 words sas » macro, system options SAS has a number of system options that we can access through dictionary tabl...
benchmarking the sasload statement 17Jul2014 305 words sas » benchmark in the middle of re-writing some macro code where different datasets were bei...
On Interruptions 14Jul2014 141 words post » Last month, Ben Brooks ran a poll on his website asking readers their attitud...
rebuilding wide macros 09Jul2014 413 words sas » macro Recently I needed to pull the values of potentially long macro variables (mor...
last week of quarter 19May2014 428 words sas » A coworker recently asked me how I would identify the last week of a quarter ...
setting %array values through %do_over 03May2014 283 words sas » %array, %do_over I’ve been using Ted Clay’s %array and %do_over macros lately. a lot. Everytim...
the $329 retina iPad mini with Retina display 28Jan2014 257 words post » ios Last night, the Apple store was down for something or other. This morning, I ...
a new home 29Dec2013 72 words post » meta growing displeasure with another stagnant hosting provider prompts yet another move.
transactions.pl: a mint parser 26Dec2013 22 words post » gist, perl i make mint do what i want via a custom perl script.
convert to a [hhmmss-type integer to a] sas time - (SO) 30Apr2013 241 words sas » time values, stack overflow converting time integers like 144500 into sas dates values like 2:45:00.
pretty note blocks 01Apr2013 345 words sas » macro here is how i make sas comment blocks a little less jagged.
setting the price early 29Mar2013 217 words post » apple early disappointment with the ipad mini pricing disappears with hands-on reviews.
in the future, i'll only buy memorex optical media 23Feb2013 140 words post » tips proof that memorex optical media is the best.
writing fractions in html 01Feb2013 25 words sas » html a blip on making fractions more fraction-like.
my sas global forum 2013 abstract 26Nov2012 164 words sas » conference i submitted a proposal for sasgf 2013 – with pictures!
blocks, not lines 30Oct2012 54 words sas » macro, debug someone elightens me on “line” numbering in sas macros and i am grateful.
dates from date times 28Oct2012 64 words sas » date values, function, technical debt input, substring, put or datepart. whichever, really.
Too complex to edit 05Oct2012 145 words post » rant, meta squarespace is dumb.
classical sas 25Sep2012 189 words sas » music his fifth.
The non-letterboxed keyboard 22Sep2012 15 words post » ios, rant Look at this one. A letterboxed app with a non-letterboxed keyboard.
resolve function 17Sep2012 78 words sas » function Stumbled across a nice post on dynamic macro call using the RESOLVE() functio...
The paywall, the backdoor, and twitter 12Sep2012 726 words post » hack Personally, I like Ben Brooks’ writing style–both long form and even though ...
wuss2012: building macros and tracking their use 02Aug2012 160 words sas » conference, macro, tracker I was invited to submit a paper to the Western Users of SAS Software confere...
why i look forward to collection calls 18May2012 553 words post » rant Back in 2004, i was recently married, i was nearly finished with grad school,...
windows environment variables 10May2012 21 words sas » windows a mental not for how to fetch windows environment variables in sas.
my sasgf12 timeline 26Apr2012 3283 words sas » conference Monday, April 23 (7 Sessions) Technology Connection and Keynote Presentation...
self-purging macros? 06Apr2012 44 words sas » macro unfortunately, this doesn’t work: %macro test; proc catalog cat=work.sasmacr...
simulating child's play 02Apr2012 678 words sas » array, do loop, simulation as of late, the kids are enjoying simple, pre-risk board games. of these, i p...
getting feedback on macro parameters 29Mar2012 158 words sas » macro, tip adding the following code inside a macro: %local macro; %let macro=&...
macros and the data step 14Mar2012 196 words sas » macro, data step recently, i had a need to use and update a macro variable within a data step....
clearing out the cruft 27Feb2012 353 words post » apple there’s a new minimalist todo app on the scene called clear by realmac softwa...
api upgrades 19Feb2012 83 words sas » api For the past year (maybe two), I’ve been refining a SOAP web service consumpt...
a small portion of a large number… 24Jan2012 55 words post » rant basic math on the large number that is the Romney’s 2011 tax bill.
vending machine math 23Jan2012 559 words sas » array Last week, Andy from NOTE: introduced me to code katas. Then he posted his fi...
my k'nex iphone stand 20Jan2012 32 words post » diy, ios The kids (and I) made a pretty sweet iPhone 4/4S stand out of random k’nex pi...
the positive side of keeping all your eggs in one basket 05Jan2012 185 words sas » tip in any work environment with multiple SAS users, the are likely common data s...
tweetbot 11Dec2011 96 words post » ios About six months ago, Tweetbot came to my attention–probably via the B&B ...
free app idea 04Dec2011 17 words post » ios an iOS app that, when connected to the home wifi network, could initiate an i...
dates in datetime fields 22Sep2011 103 words sas » date values Got date values intermingled with datetime values? Here’s a brute force way t...
continue-looping 14Sep2011 75 words sas » do loop if you’ve ever needed to stop processing a loop under certain conditions but ...
returning a well-formatted date-time 06Sep2011 30 words post » osx, terminal in OS X, entering this in a terminal window date "+%A, %d%h%Y%t%l:%M%p" wi...
the VVALUE function--like a quick PUT function 25Apr2011 50 words sas » tip for example… data temp; format d yyq6.; d='19Apr2011'd; x=vvalue...
label carryover 07Mar2011 197 words sas » tip a little demo on label carryover. data a; a=1; b=2; label a='from datas...
month of quarter variable 08Feb2011 139 words sas » date values, format quick formula to calculate the month of the quarter (JAN, APR, JUL, OCT=1; FE...
how do i read a file's creation date? 26Jan2011 32 words sas » file system assuming you’re on windows, you could read the output from the dos command di...
the vertical app listing 15Feb2010 415 words post » ios or how apple can fix the iPhone OS home screen mess the iPhone OS home scree...
prxparse(dates) 04Feb2010 163 words sas » prx, date values i’ve got some odd character dates that i need to fix. here’s some examples: ...
the utility of generic macros 09Nov2009 379 words sas » macro i’ve been using sas for roughly 5 years now. for the past few years, i’ve bee...
an mmddyyyy hhmmss informat. kinda. 20Oct2009 131 words sas » date values, informats a while ago, i took the hack shortcut of reading character datetime stamps in...
random dates 15Jul2009 117 words sas » date values, do loop this is a cross posting from this sas discussion forum thread. assuming yo...
calculating average time (duration) 10Jul2009 277 words sas » datetime values this is summarizes my response to a thread on the SAS Discussion Forums. i...
%d: a handy little macro for dynamic dating 08Jul2009 303 words sas » macro, date values, function for a little over a year now, i’ve been enjoying a little macro i wrote for w...
encoding data points for use with google charts api calls 01Jun2009 178 words sas » data visualization, api first step, build encoding tables based on the documentation: data encSimple...
reading overlapping text segments 19May2009 263 words sas » web scraping if you’re in the same boat as me, you’ve got sas 9.1.3 sp4 installed under wi...
reading non-standard datetime values 11May2009 194 words sas » datetime values another datetime posting. this time, i needed to read in datetime values with...
reading iso dates and datetimes 06May2009 136 words sas » datetime values a while ago, i posted a method of converting YYYYMMDD-style integers to sas d...
frustrations with dashboarding in sas 9.1.3 28Apr2009 437 words sas » dashboard I’ve gone through the work of creating a dashboard using SAS/GRAPH and summar...
a sudden spike 23Apr2009 122 words post » meta a couple weeks ago, @swaynette asked me if she could mention my post on scrap...
%expExcel 25Feb2009 77 words sas » macro i’ve uploaded the expExcel macro to the downloads section of the sas-quatch p...
sas variable lists 25Jan2009 551 words sas » tip last week, there was a blog post regarding the use of variable lists on varia...
scraping the sas training pages 14Jan2009 697 words sas » regex i thought it might be fun to see if i couldn’t pull the sas training catalog ...
proc pwdecode 07Dec2008 126 words sas » hack just read a posting about how to encode sas passwords. i’ve been using encode...
the missing format: qyy 06Aug2008 187 words sas » format sas has a lot of date-related formats…roman numerals, julian dates, jewish ca...
wiping usb drives 18Jun2008 138 words sas » tip before you give away that usb drive, you might want to wipe it clean. here’s ...
autosave my day 24Jan2008 48 words sas » tip i was modifying a program for about 4 hours when sas froze. in all that time,...
the ugly truth about call execute 16Jan2008 379 words sas » macro let’s start off with a simple macro that spits out some text and the value of...
let that be a lesson to 'ya! 21Dec2007 130 words sas » tip when i was young and reckless, i would change variable names to something a l...
converting yyyymmdd-type integer to sas date values 21Dec2007 150 words sas » date values converting integer dates like 20071221 to sas dates like 21DEC2007.
what's the point of this? 09Nov2007 357 words sas » array, do loop, rant i’m working on some survey data containing a few select all that apply-type i...
itunes xml parser 08Nov2007 116 words sas » xml wherein i coerce sas into consuming the iTunes library xml file.
sashboards = dashboards in sas? 06Oct2007 81 words sas » dashboard, tutorial sas finally posts some sample code for generating dashboards; this pleases me.
calculating period-to-period changes in sas 06Oct2007 222 words sas » date values calculating period-to-period changes with the lag function.
ZipsNear 14Sep2007 31 words sas » macro, sampling Just browsing through some old contributions I made to SAS Community and noti...
lost? -