Using SAS on UNIX to connect to MS Excel / Access Databases files on the LAN using SAS PC Files Server on your system. In order to connect to MS Access or MS Excel files on the LAN from UNIX BOX you will need to install and have the SAS PC Files Server running on […]
Well…there are many ways of getting the observation count into a macro variable…but there a few pros and cons in those methods… 1. using sql with count(*).. pros: simple to understand and develop cons: you need to read the dataset in its entirety which requires processing power here… 2. datastep pros: simple to understand and […]
Alternative to Interactive SAS discussed @ http://sastechies.blogspot.com/2010/02/running-sas-on-unix-interactively-using.html one can use SAS in batch mode. SAS in batch mode… Create a .sas file and pasted the above code at your desired location on your unix box….if you are using PC then create the file and ftp it to your home drive (i.e. ~/) The batch SAS […]
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.