Got a SAS programming problem? Submit your
quandary to
Please specify the SAS module or modules
related to your problem.
Solutions will be posted here.
Decision about posting information is the discretion of
Kevin M. Kelly.
12-Jun-2007
I have written an application that creates a large data set for
producing graphs of several hundred servers. Unfortunately it takes
awhile for the graphs to display so I have attempted to brake them
up by specifying a range (A-F, H-O, P-Z) using the first character
of the server name. The problem I am having is that the data set is
not properly handling the ranges and will only return the first
range (A-H) in each case.
The following is a sample of the code that I have included:
data work.pcsglb_r1; set work.pcsglb_report_temp; if alpha gt 'O' then delete; if alpha lt 'H' then delete; output;
%let USERCAT=galcat.&sites.rp4b;
%let USERDIR=&WEBPATH.&sites.rp4b;
%let CPRPTNM=distotc;
%cpsrcrpt(
work.pcsglb_r1
,tmpdata
,work.temp.distotc.source
,begin = seldate
,end= latest
,BY= date alpha machine
,OUTMODE=WEB
,OUTDESC=Detail Daily CPU Utilization-B
,OUTLOC=&usercat
,HTMLDIR=&userdir
,IMAGEDIR=&userdir
,REDLVL=OTHER
,WEBSTYLE=&cpwstyle, LARGEDEV=&lrgstyle) ;
run;
If anyone could offer some assistance I would greatly appreciate it.
Please contact:
25-May-2007
I have a dilemma - I pull nearly a billion rows of data from Oracle
to SAS each month. I do this because my extraction one time, and the
ensuing combinations and transformations I perform prevent the rest
of the user community from having to execute the same process every
time they extract. Basically I take the 40 most used tables and
create 3. Problem is, IT is tired of my footprint on the Oracle box
every month, yet fail to provide me any alternative. I run Pass-thru
queries to do the extract, build a local dataset, perform the
necessary translations, build a Prod dataset, drop the original
tables.
I am looking for any/all advice on ways the ETL process can become
more efficient.
I am on a 8-way box with 16 gig RAM and 10 TB disk space - it is an
AIX platform. SAS 9.1.3 using Enterprise Guide as the GUI. Oracle is
of course on what Oracle likes.
Please contact:
23-Jan-2007
The problem goes like this:
There is one table called orders which has orders from different
locations. There is a column location which has one of two values,
US and EUR. The rows with US mean they are US orders and the rows
with EUR mean they are Europe orders. There are two users of SAS
called US_user and EUR_user.
What is expected is, when US_user logs in to SAS and views the
orders table, he sees only the rows where the location column has
values = US. Likewise, when EUR_user logs in and views the orders
table, he sees only the rows where the location column has values =
EUR.
What I want is if from SAS perspective how this can be achieved
using the SAS Management Console. And if it cannot be, then what are
the different ways to do this and which is the best way performance
wise and space wise.
Does SAS has capabilities to do column level restriction for users
and how it can be done. Also, SAS has row level restrictions too.
And how this can be done?
Let me know if something is not clear.
If you have an answer, please contact:
¤
¤
The information on this page is presented as is.
No warranty as to the accuracy of any of the presented information
is implied.
SAS® and all other SAS Institute Inc. product or
service names are registered trademarks or trademarks of SAS
Institute Inc. in the USA and other countries. All other
trademarks are the property of their respective owners.
