Interested to Buy Any Domain ? << Click Here >> for more details...
what is SAS/Access and SAS/Connect?what are the uses?
- 3 Answers
- 10060 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kishore
sas access is a software which is used to read data stored
in database such as oracle..
sas connect provides the connection between the hosts and
enable to run statement in a remote operating
| Is This Answer Correct ? | 5 Yes | 1 No |
Answer / vijji
Sas Acesss : SAS Acess ,acess the data from different
databases(like oracle,sql etc..)
SAS connecting: system is Connecting to server or client
system
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / dev
sas access : using this software we can read the data without converting data in to data set and sas connect is used when we write a sas code on one computer and submit it on other computer for processing
| Is This Answer Correct ? | 2 Yes | 0 No |
what is star schema? : Sas-di
Name statements that function at both compile and execution time?
Could you please answers for this. 1.Code the tables statement for a single-level (most common) frequency. 2.Code the tables statement to produce a multi-level frequency.
For what purpose(s) would use the RETURN statement?
How would you invoke a macro? : sas-macro
what is the Population you used in your project, is it ITT or PP?
0 Answers Accenture, Quintiles,
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.
How is character variable converted into numeric variable and vice versa?
explain about various caches available in data integrator? : Sas-di
What other SAS features do you use for error trapping and data validation?
How can you put a "trace" in your program?
How do you add a number to a macro variable?
Teradata 
