what are different type of sas servers ? On which server
does the sas code execute ?
Answers were Sorted based on User's Feedback
Answer / dwh_pabba
SAS WORKSPACE SERVER
SAS STORED PROCESS SERVER
SAS OLAP SERVER
SAS METADATA SERVER..
IF I MISSED ANY ... PLS FILL
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / raju
SAS WORKSPACE SERVER
SAS STORED PROCESS SERVER
SAS OLAP SERVER
SAS METADATA SERVER
SAS WORKSPACE SERVER IS USED TO EXECUTE THE SAS CODE.
I feel this is correct answer else pls correct me.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / aravind gadde
SAS Metadata server
==========================
Which performs authentication and lets you to log into the
system.
SAS Object spawner
=============================
Which initiates a new WORK space server if you start doing
any activity.
SAS Workspace server
================================
Which performs code execution
****************
Optional servers
****************
Stored process server-------To create & execute stored
processs
OLAP server-----------------To create and analyze cubes
SPDS------------------------Parallel processing
*********
JAVA servers (This to bring up Web clents like WRS, OLAP
viewer...etc)
**********
Application server (Example Weblogic)
Web server (optional-- Example Apache)
WEBDAV server( Example---Xythos)
| Is This Answer Correct ? | 5 Yes | 4 No |
Answer / dvsr
SPDS server (Scalable performance data server)is one of the
server to Execute the SAS code.
SPDS has different components
1.SPDS services
2.Meta data server
3.ConnectServer
4.ShareServer
5.ObjectSpawners
Feel free To add more if I missed any thing ….:)
| Is This Answer Correct ? | 1 Yes | 3 No |
What is proc sort?
How to read an input file in sas?
Mention what is SAS data set?
Is it possible to do sorting tranformation in charecter variable??if can tell me one eg..
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 would you define the end of a macro?
what is the use of LRECL option.
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What is the purpose of trailing @ and @@? How do you use them?
What are the default statistics that proc means produce?
Can we create datasets by proc step ? (Proc contents, Means)?
what is Difference between PROC SQL JOINS and MERGE?