Posts Tagged ‘ error message ’

SAS went to a new line when INPUT statement reached past the end of a line

May 6, 2011
By

SAS has powerful features for reading data out of text files (such as CSV, TSV, datalines, and various other formats), but while reading text, you may find your data set is missing rows and the log has this non-intuitive error message (well, “not...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

Import DBF in SAS

September 7, 2010
By

There are several ways to import DBF files in SAS. First, there is PROC DBF: filename dbfin 'employee.dbf'; proc dbf db5=dbfin out=employee; run; But in my environment (SAS 9.1.3 Windows XP; and SAS 9.2 on Windows Server 2008 with Enterprise Guide 4.2 ...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

Passing a range to a SAS stored process via URL

August 16, 2010
By

Stored processes can be called via the SAS Stored Process Web Application using a URL. Though powerful and useful, the advanced usage concerning ranges requires explanation. Background Say you have a program called /path/myprogram on server sasserver, ...
Read more »

Tags: , , ,
Posted in SAS | Comments Off

SAS: “The query requires remerging summary statistics back with the original data”

September 22, 2009
By

Coming from a background writing SQL code directly for “real” RDBMS (Microsoft SQL Server, MySQL, and SQLite), I was initially confused when SAS would give me the following ‘note’ for a simple summary PROC SQL query: 429 proc sq...
Read more »

Tags: , , , ,
Posted in SAS | Comments Off

SAS truncates SQL columns to length 1024

August 11, 2009
By

At first I thought SAS was giving me errors because the input data was malformed. Before I found data entry operators typing invalid dates such as “3/30/33/2009″ : NOTE: Invalid argument to function INPUT at line 1248 column 26 NOTE: Mathem...
Read more »

Tags: , ,
Posted in SAS | Comments Off

Proc-x is looking for sponsors!

Dear readers, proc-x is looking for sponsors who would be willing to support the site in exchange for banner ads in the right sidebar of the site. If you are interested, please e-mail me at: [email protected]

Welcome!

SAS-X.com offers news and tutorials about the various SAS® software packages, contributed by bloggers. You are welcome to subscribe to e-mail updates, or add your SAS-blog to the site.

SAS and all other SAS Institute Inc. product or service names are registered trademarks or trademarks of SAS Institute Inc. in the USA and other countries. ® indicates USA registration.