How will you react when, while consulting a SAS
documentation manual to get an answer to a problem, someone
says hey, I thought you were supposed to know all that
stuff already, and not have to look it up in a book?
Will it bother you if the guy at the next desk times the
frequency and duration of your bathroom or coffee breaks on
the grounds that ?you are getting paid twice as much as he
is??
can Informatica be used as a cleansing tool? If yes, give
examples of transformations that can implement a data
cleansing routine.
107
What is the complex report you faced in real time?
37
Can the expiration parameter of 365 in the cognos 8
configuration
how to increase common symmetric key lifetime in days
123
Can any one say me how i can integrate 3 or more analytics
like radio bottons,line chart,pie chart while designing a
dash board in xcelsius and i am also facing problem to show
one after another values in the same chat at a time.....
Please help me out for this....
I have 7500 rows. I need all rows in single reports. Which
type of prompt we have used retrieving all rows and show in
a report?
We have dynamical queries q1, q2, q3, q4, q5. If customer
selects the particular, query that only show in execution
report. In case it may more then one, how do you execute the
particular query item in report page?
What are the difference bt OLDP and OLAP?
Hello,
I have PROC SQLs results group by 3 fields and I use SUM and
COUNT functions in SQL. The problem is when I try to display
my result with PROC TABULATE. I am getting very big
numbers. I believe I make a mistake some where in Tabulate.
Here is my Proc Tabulate.
PROC TABULATE DATA=OUT04_05 FORMAT=12.;
CLASS YR CENTRE VISA / PRELOADFMT EXCLUSIVE;
VAR NEWUSER FRAUD TRANSFER AUTUSER REISSUE;
TABLE CENTRE ALL, (YR ALL)*VISA,
(NEWUSER*F=COMMA12. AUTUSER*F=COMMA12.
FRAUD*F=COMMA12. TRANSFER*F=COMMA12.
REISSUE*F=COMMA12.) /
MISSTEXT={LABEL='0'} PRINTMISS RTS=20;
FORMAT VISA VISAFMT.;
KEYLABEL SUM = ' '
ALL = 'TOTAL';
LABEL YR = 'DATE YEAR'
NEWUSER = 'TOTAL NEW ACCT'
TRANSFER = 'TOTAL TRANSFER'
FRAUD = 'TOTAL FRAUD TRANSFER'
AUTUSER = 'TOTAL AUTH USERS'
REISSUE = 'TOTAL REISSUE';
When I code it like : NEWUSER*N*F=COMMA12.
AUTUSER*N*F=COMMA12.
I get same amount numbers but to find a NEWUSER I use
COUNT(*) and to find AUTUSER I use SUM(xxxx) function so
both result shouldn’t be the same my problem is in this
point.
Could you tell me where the problem in code is. How can I
display my result?
TX.
along with your userid / name. ThanQ
Site Map
