Snipplr

(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

(SAS) Delete all labels - Stat_Geek

Wed, 16 Feb 2011 10:35:12 GMT

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

Sat, 22 Jan 2011 10:20:23 GMT

(SAS) Substring function - mprabhuram

Wed, 05 Jan 2011 07:24:35 GMT

SUBSTRN(String,Start,count)

(SAS) SAS Oracle Bulk Load - mprabhuram

Tue, 30 Nov 2010 06:14:29 GMT

use bulk load to save a large SAS dataset into oracle/DB2/SQL Server/ Teradata for joining with other tables etc.. Alternate link : http://www2.sas.com/proceedings/sugi29/106-29.pdf

(SAS) Macro to create an ordering (for PROC REPORT) - sandman7OR

Wed, 27 Oct 2010 09:07:56 GMT

(SAS) SAS Macro to FTP files between PC and Unix or among Unix server Locations... - sastechies

Thu, 21 Oct 2010 12:34:08 GMT

(SAS) SAS Macros to Search and Report Errors and Warnings from your SAS Logs - sastechies

Tue, 12 Oct 2010 21:59:47 GMT

(SAS) SAS Macros to Read data from MS Excel using DDE - sastechies

Thu, 07 Oct 2010 23:03:59 GMT

(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 GMT

(SAS) DS-PhotoTemplate: Step 1 - secondfret

Wed, 22 Sep 2010 03:31:29 GMT

(SAS) ERROR: The format XXXX was not found or could not be loaded. - sarathannapareddy

Tue, 18 May 2010 13:24:04 GMT

Whenever you try to open a SAS data set which has permanent formats, you will get the error message in the log file saying “ERROR: The format XXXX was not found or could not be loaded.” This happens generally when you don't have the format library where the SAS dataset located. What happens here is, SAS will not permit you to open the data set without the format library. But, if you use options nofmterr; at the top of your program, SAS will opens the dataset for you despite the fact that it does not have the format library.