Interested to Buy Any Domain ? << Click Here >> for more details...
How could you generate test data with no input data?
- 14 Answers
- 30473 Views
- CTS, I also Faced
- E-Mail Answers
Answer Posted / sirisha
by using loop concept or by importing data frim external file.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
describe how to adjust the performance of data integrator? : Sas-di
Which statement does not perform automatic conversions in comparisons?
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.
Explain substr function?
Explain translate function?
Enlist the syntax rules followed in sas statements.
what is SAS OPTIMIZATION?
Give some examples where proc report’s defaults are different than proc print’s defaults?
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
Which function is used to count the number of intervals between two sas dates?
how can you import .csv file in to sas? : Sas programming
what are sas bi dashboard components? : Sas-bi
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What is the difference between order and group variable in proc report?
