why is sas data integration studio important? : Sas-di
No Answer is Posted For this Question
Be the First to Post Answer
What are the features of base sas system?
What is your weekness? I am confuse what to say about this question. so can u give some answer which can be yur strenght.
what is difference in window SAS & Unix SAS.....how do define working environment in both???
if you have 365 no of data set and each one having different variable from each other. how will you read by creating macros and create a single data set.
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.
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn?t have a value?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO
How do you read in the variables that you need?
Differentiate between sas functions and sas procedures.
Explain input and put function?
How could you generate test data with no input data?