What is the difference between a PROC step and a DATA step?
Answer Posted / ravi
data set block:-
1)data set block is to create a 'SAS' file for analysis and Report
2)data set block is used for permanent storage of SAS file
procedure block :-
1)PROC steps can list, sort, and summarize data
2)PROC steps are used to:Create a report that lists the data,
Produce descriptive statistics,Create a summary
report,Produce plots and charts
3)procedure block is used for temporary storage of sas file
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What will calendar procedure do?
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 techniques and/or procs do you use for tables? : Sas programming
In sas, what are the areas that you are most interested in? : sas-grid-administration
what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi
Do you need to know if there are any missing values?
what is slowly changing dimension? : Sas-di
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What do you know about sas data set?
Mention few capabilities of sas framework.
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
What are SAS/ACCESS and SAS/CONNECT?
Can you explain the process of calendar?
What do the PUT and INPUT functions do?
What do the mod and int function do? : Sas programming