how can you get the single data set from the library(which
has the number of data sets)?
Answer Posted / shivraj gangu
Using the Libname stetment and select statment..
| Is This Answer Correct ? | 24 Yes | 0 No |
Post New Answer View All Answers
Explain proc univariate?
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What are the default statistics for means procedure?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
what are some differences between proc summary and proc means? : Sas programming
What is SAS?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What are the 3 components in sas programming?
what is the purpose of _error_? : Sas programming
What is PROC in SAS?
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 do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?
Explain what Proc glm does?
what is the difference between floor and ceil functions in sas? : Sas-administrator