Snipplr

(SAS) Remove carriage return and linefeed characters within quoted strings - webonomic

Sat, 02 Nov 2013 04:53:46 UTC

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 double quotes with other printable characters. CR/LF characters outside of double quotes are untouched. In this sample, the external file is updated in place. You cannot separate the input and output because the code uses shared buffers. You should make a copy of your file before running this sample on it.

(SAS) Counting the number of observations in a BY-Group - webonomic

Sat, 07 Sep 2013 02:17:26 UTC

Determine how many observations there are in each BY-Group by using BY-Group processing.

(SAS) Allow a list of non-numeric values for an iterative macro %DO loop - webonomic

Wed, 24 Jul 2013 00:51:16 UTC

More details here: https://communities.sas.com/ideas/1084

(SAS) Using PATHNAME to Retrieve a Physical Path - webonomic

Fri, 12 Jul 2013 01:11:57 UTC

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 list in parentheses:

(SAS) Using character values on a macro %DO loop - webonomic

Tue, 11 Jun 2013 09:01:40 UTC

This sample contains 2 macro techniques for iterating through character values on a macro %DO loop.

(SAS) Co Word Analysis with SAS - webonomic

Sun, 02 Dec 2012 07:43:07 UTC

Text Miner uses a compressed representation of the term-by-doc frequency matrix. You will find an OUT data set in the project data directory of your text miner run. Its label will include the string "OUT" in it. Since a 30,000 document collection will have as many as 500,000 to a million distinct terms, be sure to restrict your terms of interest with a start list. I give an example of creating the cooccurrence matrix with the following code which expands the compressed version to an uncompressed version and then computes the co-occurrence count with proc corr and the sscp option.

(SAS) Using Alternating Background Color with PROC REPORT - webonomic

Fri, 02 Nov 2012 02:33:20 UTC

Adding alternating row of color to make proc report output easier to read.

(SAS) Specify colors in SAS statistical graphics procedures - webonomic

Wed, 24 Oct 2012 06:53:06 UTC

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:

(SAS) Default Macro Values - webonomic

Sat, 13 Oct 2012 00:28:05 UTC

Quite often it is necessary to set a default value for a macro parameter that is passed to a program. If the program is a macro, the %IF statement can be used to check if the value is provided and provide a default value if not. Since %IF statements are not allowed outside of macros, that technique won't work for a non-macro program (e.g., a file/program that is %INCLUDEd). The following code snippet demonstrates the use of the COALESCEC function to assign a default value. since macro is a text manipulation facility, the coalesceC function is used regardless of whether the expected value for the parameter is numeric (i.e., everything in macro is interpretted as a character string).

(SAS) Creating a report of Twitter hashtag activity - webonomic

Fri, 13 Apr 2012 01:02:52 UTC

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.

(DOS Batch) Combine/append ASCII files using DOS - webonomic

Fri, 13 Apr 2012 00:53:33 UTC

Quickly combine/append ascii type files such as txt or csv.

(SAS) Selecting a Random Sample of Observations - webonomic

Thu, 16 Feb 2012 02:08:13 UTC

You can use the POINT option of the SET statement to efficiently select a random sample of observations from a SAS data set. In addiiton to any statistical reasons for drawing a random sample, the technique is also useful to create test data from a large file. The program shown here efficiently samples a large data set. It reads only the observations that have been selected using the POINT option. You assign a variable that is the desired sample size. The example here selects a 10% sample. You can also assign a fixed value (e.g., 100). The DO loop is iterated for each observation The uniform function is compared to the percent of observations still to be selected If the observation is selected, it is read and output and the number needed is decremented by 1 Regardless the number of observations left is reduced by 1 The STOP statement is very important as without it, the DATA step will enter an infinite loop. This technique works by modifying the threshold as observations are read and selected. Every observation has the same probability of being selected so the technique is statistically valid (If you are a statistician, you probably know this. If not, the analogy of drawing straws is the logic behind this.)

(SAS) Convert SAS dataset to Text file - webonomic

Tue, 15 Nov 2011 14:20:12 UTC

This SAS macro will convert a dataset to a text file

(SAS) Exporting Multiple Data Sets to One Spreadsheet - webonomic

Sat, 19 Mar 2011 07:32:29 UTC

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).

(SAS) Store a zero value in place of missing when reporting numeric values - webonomic

Sat, 22 Jan 2011 10:20:23 UTC

(Ruby) Strip characters from between two delimiters - webonomic

Tue, 26 Oct 2010 04:00:58 UTC

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:\"

(SAS) Create a new variable based on the first non missing value from a list of variables - webonomic

Wed, 29 Sep 2010 02:55:10 UTC

(SAS) Retrieve the physical location of a dynamic dataset, file or folder in SAS - webonomic

Fri, 26 Feb 2010 16:04:44 UTC

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 to the same location as the MYDATA library, however in order to issue a new LIBNAME statement we need to know the location of the MYDATA library. The PATHNAME function returns this location and the new libref (MYDAT6) can be created.

(Bash) Create ISO files in Linux - webonomic

Sun, 17 Jan 2010 16:22:30 UTC

(Ruby) Ruby vcard maker - webonomic

Sun, 10 Jan 2010 13:27:32 UTC

Requires vPim package.

(Ruby) Ruby script to save a string to a file. - webonomic

Sun, 10 Jan 2010 13:23:39 UTC

(Bash) Send email using mail command on linux - webonomic

Thu, 03 Dec 2009 23:56:13 UTC

This command will email the contents of emailbody.txt to somebody@domain.com with the subject My subject line.

(Bash) Loop through Array in Bash - webonomic

Thu, 03 Dec 2009 20:45:39 UTC

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.

(SAS) Show all possible values in table regardless of whether or not the value exists - webonomic

Tue, 25 Aug 2009 13:19:46 UTC

Here are two solutions when creating a table to show responses to a questionnaire where respondents rate items in various categories. In this case, the responses range from 0 to 5 (N/A, Very Poor, Poor, Average, Good, Very Good).

(Bash) Backup your MBR on Linux - webonomic

Tue, 17 Mar 2009 00:11:55 UTC

About the dd command: dd if= of= bs=("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=. Source is the data being read. Target is where the data gets written. Warning!! If you reverse the source and target, you can wipe out a lot of data. This feature has inspired the nickname "dd" Data Destroyer. Warning!! Caution should be observed when using dd to duplicate encrypted partitions.

(SAS) Create Access Database from SAS - webonomic

Thu, 19 Feb 2009 12:08:21 UTC

(SAS) Reorder Variables in SAS - webonomic

Wed, 04 Feb 2009 17:44:56 UTC

Use the Retain Statement to reorder variables. No data is lost and the variable attributes are kept. Works for SAS 8.2 and up.

(SAS) SAS Array Colon Modifier - webonomic

Tue, 27 Jan 2009 17:05:01 UTC

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.

(SAS) Delete observations containing characters and keep numeric values only - webonomic

Tue, 27 Jan 2009 12:28:57 UTC

How to delete observations containing characters (e.g. 92z89 or abcd) and only keep the ones with numeric values.

(Bash) Unique Background Wallpapers for Workspaces on Linux - webonomic

Tue, 20 Jan 2009 11:50:37 UTC

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_command_2. Set command_1 and command_2 to point to the appropriate files. See the URL for more details.

(SAS) Get SAS Version - webonomic

Mon, 22 Dec 2008 13:32:25 UTC

Print the version of SAS to your logs using any of these 3 macros

(SAS) Convert values from character to numeric or from numeric to character - webonomic

Wed, 10 Dec 2008 15:46:11 UTC

Original Source from http://support.sas.com/kb/24/590.html

(Bash) ImageMagick: Convert PDF to Images - webonomic

Tue, 09 Dec 2008 12:54:25 UTC

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.

(Bash) ImageMagick: Append many images into one - webonomic

Tue, 09 Dec 2008 12:45:30 UTC

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)

(SAS) Proc FCMP Creating a Function and Calling the Function from a DATA Step - webonomic

Thu, 02 Oct 2008 13:44:26 UTC

(SAS) Proc FCMP Creating a Call Routine and Function - webonomic

Thu, 02 Oct 2008 13:42:49 UTC

(SAS) Proc FCMP Example - webonomic

Thu, 02 Oct 2008 13:37:04 UTC

(SAS) Count up the number of characters in a string - webonomic

Thu, 02 Oct 2008 13:19:06 UTC

(SAS) Count up the number of substrings in a string - webonomic

Thu, 02 Oct 2008 13:18:06 UTC

(SAS) Use Regular Expressions in Proc SQL - webonomic

Thu, 02 Oct 2008 13:16:09 UTC

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, quarters & months.

(SAS) Access SQLite Database from SAS - webonomic

Tue, 30 Sep 2008 18:23:07 UTC

(SAS) Needle Plot with SGPLOT - webonomic

Wed, 11 Jun 2008 12:44:04 UTC

(SAS) Match Merge using Proc SQL - webonomic

Sat, 24 May 2008 18:44:21 UTC

(SAS) SAS goto statement - webonomic

Sat, 17 May 2008 13:40:57 UTC

You can use the goto statement to have SAS process statements in some other part of your program, by providing a label followed by a colon before the statements you wish to jump to. Label names follow the same rules as variable names, but have a different name space. When a labeled statement is encountered in normal processing, it is ignored.

(SAS) Create a new data set for each BY-Group in a data set - webonomic

Tue, 13 May 2008 17:23:08 UTC

This sample uses macro logic to determine the number of unique values of a variable (the BY variable) and creates a new data set for each. The resulting data set names will be the BY variable value. Limitations: The sample code does not allow for BY values of longer than 32 positions, numeric BY values or BY values that contain characters that are not permitted in SAS data set names. If your data contains any of the above, you must add program statements to convert your BY values into valid SAS data set names.

(SAS) SAS String Parsing - webonomic

Sat, 03 May 2008 15:52:36 UTC

Need to construct and ID of the first 5 letters and the last 7 digits

(SAS) Merge datasets with unlike variable names - webonomic

Sat, 03 May 2008 15:26:35 UTC

(SAS) Using Proc SQL to summarize tables into groupings - webonomic

Sat, 03 May 2008 15:19:18 UTC

Using Proc SQL summarize the table sashelp.shoes grouping on

(SAS) Create one response from "check all that apply" variables - webonomic

Tue, 08 Apr 2008 03:33:17 UTC

Below is some code written for creating one response from survey questions where the respondent checks all that apply.

(SAS) Paired Bar Chart - webonomic

Tue, 01 Apr 2008 14:03:20 UTC