webonomic


Member since 02/18/2008

Name: Jared Prins

Location: Canada

Website: http://jaredprins.ca

I\\\'m a SAS and web programmer, internet and tech junkie, computer geek, and Linux fanatic.

33 snippets

937 profile views

3 Comment(s) Posted

View their favorites

Profile

Achievement

first submission:submitting first snipplet

webonomic's Recent Snippets



« Prev 1 2
If a flat file contains embedded carriage return (CR) and linefeed characters (LF) inside double quotes, SAS will interpret them as end of line markers. This may cause your file to be read incorrectly. This example replaces CR/LF characters within...
0 370 posted 6 years ago by webonomic
More details here: https://communities.sas.com/ideas/1084
0 255 posted 7 years ago by webonomic
If you know a libref or fileref, the PATHNAME function can be used to return the physical location. If the libref refers to more than one physical location, all of those locations will be returned, in quotes, separated by spaces, with the whole li...
0 226 posted 7 years ago by webonomic
This sample contains 2 macro techniques for iterating through character values on a macro %DO loop.
0 320 posted 7 years ago by webonomic
Adding alternating row of color to make proc report output easier to read.
0 259 posted 7 years ago by webonomic
If you want to see some of the color names that SAS recognizes, run the following statements, which will print a list of colors to the SAS log:
0 196 posted 7 years ago by webonomic
The program uses the XML LIBNAME engine, FILENAME URL, SGPLOT procedure, and a simple PROC PRINT to create a report of recent Twitter activity around a specified hashtag.
0 229 posted 8 years ago by webonomic
Quickly combine/append ascii type files such as txt or csv.
0 195 posted 8 years ago by webonomic
This SAS macro will convert a dataset to a text file
0 252 posted 8 years ago by webonomic
It's easy to export several data sets to one Excel spreadsheet with each data set in a separate worksheet.This example exports three SAS data sets (work.region, work.county and work.district) to the same spreadsheet (results.xls).
0 248 posted 9 years ago by webonomic
This regular expression used in Ruby will extract the characters between single or multi-character delimiters. It helps when you have strange delimiters such as \":delimeter1: text I want to grab goes here :delimiter2:\"
0 171 posted 9 years ago by webonomic
The PATHNAME function can be used to retrieve the physical location of a file or directory. This can be especially useful when reassigning engines for a libref using the Macro Language. Here we want to write a Version 6 copy of the data set CLASS...
0 254 posted 10 years ago by webonomic
0 193 posted 10 years ago by webonomic
This command will email the contents of emailbody.txt to [email protected] with the subject My subject line.
0 183 posted 10 years ago by webonomic
This creates an array of various linux shell names, loops through the array and ouputs a file called shell_locations.txt showing where the shells are located on the linux system.
0 200 posted 10 years ago by webonomic
About the dd command: dd if=<source> of=<target> bs=<byte>("USUALLY" some power of 2, not less than 512 bytes(ie, 512, 1024, 2048, 4096, 8192, 16384[/b], but can be ANY reasonable number.) skip= seek= conv=<conversion>. Source is the data being...
0 147 posted 11 years ago by webonomic
0 201 posted 11 years ago by webonomic
Use the colon : modifier to build an array. The colon is like a wildcard. In this case, anything that starts with ash. SAS Arrays hold variable names which can be used during tedious procedures such as conditional loops.
0 190 posted 11 years ago by webonomic
Bash shell scripts to control wallpaper backgrounds when switching between Ubuntu workspaces. (Other distributions can use it too). Take the below 2 scripts to make 2 separate files. Use gconf-editor to attach keybindings to run_command_1 and run...
0 181 posted 11 years ago by webonomic
Original Source from http://support.sas.com/kb/24/590.html
0 249 posted 11 years ago by webonomic
If you don't have Adobe Acrobat Pro to export a PDF to multiple images, you can use this ImageMagick code. This command will produce the files 'result-0.jpg' , 'result-1.jpg', etc... for each PDF page.
5 242 posted 11 years ago by webonomic
You can use this code in Bash or Windows CMD / Command prompt (although you'll have the change the comment character from # to :: for the windows prompt)
1 233 posted 11 years ago by webonomic
You can use regular expressions within SQL. This can be quite powerful in selecting data that matches certain conditions. The following example shows a simple regular expression which selects only quarterly periods from a table containing years, quar...
0 247 posted 12 years ago by webonomic
0 374 posted 12 years ago by webonomic
0 195 posted 12 years ago by webonomic
Using Proc SQL summarize the table sashelp.shoes grouping on
0 196 posted 12 years ago by webonomic
Below is some code written for creating one response from survey questions where the respondent checks all that apply.
0 203 posted 12 years ago by webonomic
0 165 posted 12 years ago by webonomic
0 197 posted 12 years ago by webonomic
« Prev 1 2