SAS Proc SQL Group By returns multiple rows per group

Posted by & filed under Coding, SAS, SQL.

Just wanted to note that for traditional SQL implementations (e.g., MySQL, MS-SQL), the Group By statement used to aggregate a variable by certain variable(s) returns 1 row for each group. When a column that is not unique within a group is also selected, then the row that’s returned is determined somehow by the DB software…. Read more »

Execute shell commands with an asterisk in SAS

Posted by & filed under Coding, Linux, SAS.

I wanted to use %sysexec to execute a shell command with an asterisk (shell wildcard for globbing) in a SAS program: %sysexec cp /tmp/foo/*.txt /tmp/bar ; However, it wasn’t giving me the desired results, probably due to the /* characters as they begin a commented section in a SAS program. Also tried escaping the asterisk… Read more »

Learn regular expression by doing with regetron

Posted by & filed under Coding.

When it comes to learning, I buy into the “learning by doing” philosophy. This is especially true when learning a computer tool or programming language. I stumbled upon this regex tutorial that makes use of a set of exercises in conjunction with regetron. Time to hone in on my regex skills.

flags for compiling source code: pkg-config command

Posted by & filed under Coding, Linux, Mac OS X.

so i was trying to compile some C code on my server at school that involves the math and the GNU Scientific Library (gsl) libraries. that is, the source has the following lines: #include <stdio.h> #include <math.h> #include <gsl/gsl_integration.h> those link the header files. however, when compiling, gcc would complain that they can’t see functions… Read more »

stumpwm on mac os x

Posted by & filed under Coding, Emacs, Linux, Mac OS X.

stumpwm is to window managing (tiling?) system what emacs is to text editing and conkeror is to web browsing. very cool. if i was on a linux laptop/desktop like i used to be, i would definitely use this. i’m even debating on quitting my mac os x for this (with emacs and conkeror). however, i… Read more »

emacs key bindings in mac os x (cocoa)

Posted by & filed under Coding, Emacs, Mac OS X.

so im very used to emacs keybindings. i use it for emacs and conkeror so often times i hit M-w etc and these keys don’t work in mac os x. this sucks. i googled it, and found this and this. guess u can have emacs keybindings in mac os x…for programs that use the cocoa… Read more »