Snipplr

(SAS) person age function - csrsen

Wed, 27 Feb 2013 07:15:57 GMT

For proper calculation of human age using DOB and an as-of date.

(SAS) Co Word Analysis with SAS - webonomic

Sun, 02 Dec 2012 07:43:07 GMT

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 GMT

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 GMT

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 GMT

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) sas wedit find next and prev - Pavonz

Sat, 14 Jul 2012 22:25:19 GMT

sas wedit find next and prev

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

Fri, 13 Apr 2012 01:02:52 GMT

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.

(SAS) [SAS] ETL Email Noticiation - ccw

Thu, 29 Mar 2012 16:13:29 GMT

An example to notify users with ETL job status

(SAS) [SAS] Applying ACT - ccw

Mon, 26 Mar 2012 15:07:42 GMT

Applying Access Control Template to specific objects

(SAS) [SAS] JSON output - ccw

Mon, 26 Mar 2012 14:44:52 GMT

SAS code to output in JSON format

(SAS) Selecting a Random Sample of Observations - webonomic

Thu, 16 Feb 2012 02:08:13 GMT

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 GMT

This SAS macro will convert a dataset to a text file

(SAS) Create new folder with simple checks - rambles

Wed, 02 Nov 2011 20:57:32 GMT

(SAS) Text to SAS Variable Name - rambles

Tue, 13 Sep 2011 19:10:02 GMT

Useful functions to ensure (99% of the time...) that a piece of text can be used to name a SAS variable. NOTE: This won't work with SAS literals.

(SAS) Simple hash lookup - rambles

Tue, 16 Aug 2011 19:21:14 GMT

Simple, basic syntax for SAS lookup

(SAS) Summary datasets using hashes - rambles

Fri, 27 May 2011 19:45:20 GMT

This snippet comes directly from Paul M. Dorfman's paper on programming with Hash objects. The hash object is useful when summarising huge datasets that aren't sorted and indexed by the variable(s) to be summarised; they can often be quicker than proc summary and are certainly less machine intensive.

(SAS) Output list of files and folders to a dataset - rambles

Thu, 26 May 2011 20:02:18 GMT

This simple, straightforward method should work on multiple platforms (other methods involving OS specific commands and pipes are less flexible).

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

Sat, 19 Mar 2011 07:32:29 GMT

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) Convert character field in to SAS date field - mprabhuram

Wed, 02 Mar 2011 09:52:13 GMT

(SAS) Correcting for unbalanced quotes - Stat_Geek

Wed, 16 Feb 2011 10:39:40 GMT