HOW DO WE CREATE A SAS STORED PROCESS IN SAS EG ?
Answer Posted / praveen kumar
We can Create a Stored Process in EG.
Select a New Program from the EG File menu and add the code whatever u want (Should follow SAS Syntaxes) in that and after that right click and select create New stored Process.
After that in the wizard it will ask to select the stored process server and also add the parameters at Prompts wizard if u need.
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
How would you define the end of a macro? : sas-macro
For what purposes have you used sas macros? : sas-macro
which date functions advances a date time or date/time value by a given interval? : Sas programming
Mention some common errors that are usually committed in sas programming.
Explain translate function?
Which function is used to count the number of intervals between two sas dates?
What is the basic structure of the SAS base program?
What are the data types does SAS contain?
What is the length assigned to the target variable by the scan function?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what is sas enterprise intelligence architecture? : Sas-bi
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.
what is intially documentation in sas?
what is data integration? : Sas-di