Opportunities

PDF Documents

Value Add(SAS Abbrevs)

 

This page is dedicated to provide free tools and quick general tips for developers, analysts, consultants and managers.

Tools Tips

Category
Tool
Description
SAS Deciles Compile Macro Program Decile program. Also it shows how to make a compile macro.
SAS Sample data & Deciles Compile Macro Sample dataset to for decile program and deciles compile macro. The compile macro is ready to be used down load it and follow the instructions in the Deciles Compile Macro Program DO NOT OPEN IN BROWSER SAVE IT TO THE HARD DRIVE
Excel Interactive Projects Charts Create Timeline Charts of your project plan.DO NOT OPEN IN BROWSER SAVE IT TO THE HARD DRIVE
Excel Excel Deciles Application Excel application that computes volumetric deciles in a sheet of data. DO NOT OPEN IN BROWSER SAVE IT TO THE HARD DRIVE

Any one interested in posting a tip complete the Tips of the Warrior Template and email it to info@datameans.com Tips must be limited to a maximum of two pages. Coding tips must include code, results and contact info if desired.Tips can not be proprietary and are free of charge. This does not include the Data Means logo.

Tips are added in a weekly basis.

Tools Tips

Category
Tip
Description
SAS Character functions 1 Use of character functions: Index, Indexc, find, findc, len, Translate and Substr
SAS Character functions 2 Use of character functions:TRANWRD & TRANSLATE
SAS Dates Functions and format 1 Date Functions & Formats
SAS Group by processing 1 Group by & Retain to increment or have the first value be the same for all the group
SAS Arrays & Group by Processing Example of a SAS array and creation of a counter variable within a group of observation
SAS Merging two data sets without a Merge statement or proc sql join Shows how to merge two data sets without using a merge statement or SQL join
SAS Mix Model Example of a mix model syntax
SAS Html SAS output and Frame creation Outputting SAS output to an html file and creating a web page with frame dividers
SAS Differences within group and SLQ coalesce and union Calculating difference between observations within group and proc sql to append data sets and full merge with the coalesce function
Project Management Automation Automation Power point Presentation
Project Management Continuous Improvement 2 Power Point Slides Presenting Continuous Improvement Concept from a Graphical perspective

Tools Tips

*SAS is a trademark of the SAS Institute

*VBA is a trademark of the Microsoft Corporation