not the best at macros - having a basic question - here is my code %macro groupperms(basedir);     filename dirperm pipe "nfs4_getfacl &basedir"; run; %mend; data work.temp;   set work.tempdir;   %groupperms(path); run; the table work.tempdir has a character variable called path path has a value of: /u02/projects just not able to get the right value passed to the filename statement ... View more

Starting to research into the capbaility of using Hadoop as a preprocessor for ITRM ... View more

The SAS Log Error Checking Tool allows users to easily examine and check any SAS log file (for any SAS release) for Error and Warning messages (and other messages) and to view any SAS Usage Notes that are related to any of the messages that were found. The tool does this automatically; you just select a log file and click a button. (English) ... View more

welcome to the group - I've been at SAS as a consultant for 4 years, prior to that I was a Capacity Manager at DHL, prior to that a Capacity Manager at Airborne Express. I've beed writing SAS code for over 20 years ... View more

Would like to hear the pros can cons to the different types of metrics to use in forecasting. For example: Taking daily or weekly trends Weekday, complete week or specific day (Monday) Only Prime shift, specific hours Mean, Max, 90th percentile,,etc ... View more

IT Resource Management (ITRM) aggregation tables are a collection of accumulated statistics that are organized as summary or simple as specified in aggregation transformations.    The ITRM aggregation transformation creates and updates the majority of all ITRM metadata objects and physical SAS tables and does so with each and every run of the Aggregation jobs that contain these transformations.  As such, this document proposes a best practice of which the physical tables created by the aggregation transformation be backed up prior to running the aggregation job such that they are available for restoration to quickly recover from the failure of any run of an Aggregation transformation; thus avoiding a more time consuming restoration of an IT data mart.  The document introduces a tool for backing up and restoring physical aggregation tables named the ITRM Backup And Restore Facility for Physical Aggregation Tables. ... View more

Many customers have existing SAS code for data preparation/staging they would like to incorporate in Jobs managed by the new ITRM Client/DI. The new Import SAS Code wizard lets you import SAS code into ITRM Client and convert it into a job flow.  This can help you visually understand what is happening in the code because in the job flow, you can see the steps in the program and what tables are created by that SAS code.  You can also examine the metadata for these tables to see properties of each variable in the table.  ... View more

Beginning with SAS IT Resource Management 3.2, SAS High-Performance Forecasting (HPF) is included in the solution.  SAS High-Performance Forecasting software provides a large-scale system that automatically selects time series models for forecasting time-series data.    This paper will demonstrate use of the HPFENGINE procedure.  The HPFENGINE procedure provides an automatic way to generate forecasts for many time series or transactional data in one step. The procedure can automatically choose the best forecast model from a user-defined model list or a default model list.  ... View more

New with SAS IT Resource Management 3.2 is the User Written Staging Transformation (UWST) that creates staging tables ready for aggregation. At first glance the UWST appears to be nothing more than a User Written Code transformation but it really has much more to offer. It provides facilities to: Control input and output tables through the ITRM Client job flow Set physical table attributes from meta data Compute the date and time variables used for aggregations Check for duplicate data to prevent the same data from being processed twice Check for and prevent future data from being processed Modify processing using parameters set in the ITRM Client GUI ... View more

SAS IT Resource Management provides facilities for the creation of User Written Adapters (known as Generic Collectors in prior releases of the solution.)    In many cases, the data for which a User Written Adapter is created resides in a relational database.    This help aid was written to facilitate ITRM users  as they create User Written Adapters where the native data source for which an ITRM Staging Job is being created is stored in a relational database management system. VMware Vsphere is used as the example in this document. The information presented is not meant for production ITRM use and is incomplete.  In fact, a  production ready version of a total VMware adapter and reporting is supplied with the  SAS IT Resource Management  solution  beginning with version 3.2. ... View more

Deployments of SAS IT Resource Management 3.x implemented with duplicate data checking use special duplicate data control files as part of each staging job. In the event that there is a need to rerun the staging job, these special datasets will need to be “reset.”. This article further explains the issue and offers a means to address this situation.   The reasons for rerunning the staging job vary, but when the situation occurs, it can be immensely helpful to have a simple process ready to execute to “reset” the staging process.  With duplicate data checking enabled, rerunning the staging job (with the same input file) will result in filtering out all of the data.  The paper shows how the user can “reset” the duplicate data control files to the previous update. ... View more