Even though we have Maintenance Release 2 installed on our SAS clients, we will still get undo problems in Excel. Here is one more step that needs to be performed: The issue described in SAS Note 36601: Cannot undo changes in Microsoft Excel when the SAS® Add-In for Microsoft Office is installed can be fixed [...]
A strong point of SAS Enterprise Guide is that it interacts seamlessly with many data types using the Microsoft Jet Engine (Excel .xls, Access .mdb, dBase .dbf, Lotus.wk?, Paradox .db, and text files .txt .csv etc). To provide even more flexibility, there are also a few different ways in Enterprise Guide to output data to [...]
SAS recently released Hotfix 41EG14 for Enterprise Guide 4.1. The hotfix resolves issues identified in: Problem Note 39149: The SAS Enterprise Guide editor’s width of caret position panel within the status bar does not accommodate for large row and column number schemes Problem Note 38003: Unable to edit existing parameter in SAS® Enterprise Guide®
You probably have many SAS data sets that you regularly work with where numbers are stored as text for formatting purposes. A great example is the social security number, and many other customer, product, or invoice numbers are formatted similarly. They frequently utilize leading zeros in their storage and display. You probably also frequently receive [...]
SAS OLAP Server names for cubes, dimensions, hierarchies, measures, and member properties follow these general rules: can be up to 32 characters in length can contain embedded blanks If the name has embedded blanks or characters other than letters of the Latin alphabet, numbers, or underscores, then PROC OLAP formats the name as a name [...]
I attended SAS Programming 3: Advanced Techniques and Efficiencies training recently at the SAS’ Austin Training Center. Programming 3 demonstrates many ways to make your SAS code and programs more efficient, but I also picked up one tidbit that makes coding and testing even easier. When using the enhanced editor, to create comments in your [...]
Here is a utility that I have used for a long time. Convert does exactly what the name suggests: converts just abbout any unit of measure in an easy, straightforward way. The program is small and fast. Highly recommended. from joshmadison.com: Convert is a free and easy to use unit conversion program that will convert [...]
You might currently use the local newspaper’s web site to obtain recent elevation data for the reservoir you are fishing or the river you are canoeing. Or if you fish or float on a number of water bodies, you might have to browse a number of controlling authorities sites (including the US Geological Survey) to [...]
I just used this software this morning to merge three tracks together in a .gpx file. Works great! I now want to try the .gpx to .kml conversion features. It supports a HUGE list of formats. from GPSBabel.org: GPSBabel lets you move data between popular GPS systems such as those from Garmin, Magellan or a [...]
This suite of tools, located on a single toolbar, allows environmental, agriculture and other natural resource field workers to make sampling grids, calculate statistics for field data attributes, select which layers should be editable and navigate to specific field locations using ArcPad. The tools download includes a read_me.txt file containing installation instructions and how each [...]
