Interested to Buy Any Domain ? << Click Here >> for more details...
PROC SQL always ends with QUIT statement.Why cant you use
RUN in PROQ SQL ?
- 7 Answers
- 30240 Views
- HP, I also Faced
- E-Mail Answers
Answer Posted / dipak
If PROC SQL is ended with Run statement then there will be
no output generated in output window. however if 'Create
table ... as' command is given in proc sql then it will
create the table.
Quit tells SAS to print output to output window, if to be
printed.
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
Explain how you can debug and test your SAS program?
How to specify variables to be processed by the freq procedure?
Mention what is SAS data set?
Which date function advances a date, time or datetime value by a given interval?
How to create an external dataset with sas code?
what is the Population you used in your project, is it ITT or PP?
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
What are the applications primarily used by business analyst? : Sas-bi
What are types of transport files?
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?
How do you use the do loop if you don’t know how many times you should execute the do loop?
What sas features do you use to check errors and data validation?
