These books coupled with SUGI Papers will give you the impetus/basics to learn and explore more on the Internet. 1. Professional SAS Programmer’s Pocket Reference – Rick Aster This book would be a must for any SAS Professional I guess…..It’s a quick handy book for Syntax and options…… 2. SAS Certification Prep Guide: Base Programming […]
SAS Technical Screening Problem asked at CDC, Atlanta… The following 3 datasets exist in a hypothetical system: COUNTY COUNTY_ID STATE_NAME COUNTY_NAME 1 Texas Collin 2 Texas Dallas 3 Georgia DeKalb AGE_DISTRIBUTION COUNTY_ID AGE_0_10 AGE_10_20 AGE_20_40 AGE_40_PLUS 1 100 20 40 60 2 10 10 40 50 3 45 100 56 67 AGE_DISTRIBUTION_DESC CATEGORY_NAME CATEGORY_DESCRIPTION AGE_0_10 […]
This SAS Screening Problem was asked at Gap Inc… The following shows 6 sample records of a large SAS data set. The data set name is trans CustomerID transactiondate amount category 9801234 10/01/1998 123.98 toys 9802234 12/10/1997 80.34 books 9802234 12/10/1997 100.00 apparel 9805556 08/01/1996 22.90 toys 9805556 09/10/1996 25.50 apparel 9805556 10/11/1996 18.90 books […]
Another small SAS Screening Problem asked at Amgen Inc For the data below… Dose Patient Dose Date 001 01Jan2003 001 02Jan2003 002 15Mar2003 002 01Mar2003 003 01Apr2003 004 19Mar2003 AE Patient AE Start Date AE Text 001 31Dec2002 Headache 001 02Jan2003 Blurry Vision 001 02Jan2003 Anxiety 002 02Mar2003 Migraine 002 01Mar2003 Constipation 002 15Mar2004 Athlete’s […]
Here’s a simple SAS Problem to work with… This was presented at a technical interview screening at Gap Inc…. For the following 7 questions we are working with a temporary database called PRODUCT Each record is a product transaction along with the following information: Store $1 Store number 0-9 Product $20 Product Number Date mmddyy10. […]
Video tutorial for SAS BI SAS Add-in for Microsoft Office with an example explained for Automated reporting for Small Businesses….
Deliver SAS Reports and Data to Mobile Users User Friendly Interface for Parameter Selection without Programming Capture Real Time Data from SAS Directly from your iPhone Intuitive Web Interface for Administrators and Power Users Deliver Powerful Business Intelligence to iPhone® Any SAS macros, programs or data can be delivered to iPhone. By simply registering the […]
SAS Data Integration Studio is a visual design tool that simplifies the construction, execution and maintenance of enterprise data integration processes. Powerful, in-depth data transformation logic is provided in an easy-to-use, wizard-driven interface, enabling one or more developers to rapidly build, schedule, run and monitor a myriad of data integration activities. An easy-to-use interface and built-in impact analysis capabilities lower the cost of building and maintaining data integration workflows, simple or complex.
Watch the video for Building OLAP cubes with SAS Enterprise Guide…
SAS Web Report Studio is a Web application that anyone can use to view, interact, create, and distribute both public and private reports. You can interactively get the information you need without having to understand a programming language. In addition, SAS predictive analytical results can be used by business professionals across the enterprise via their […]