What is the difference between an informat and a format?
Name three informats or formats.
Answer Posted / chiranjeevi
Informat:
1)It should appear only datastep.
2)it is used for SAS special instructions to read the
special data values.it can be used either in the input
statements,else by using a separate statement called 'informat'.
syntax:informat<variable name>>type of informat>
or
input<variable name><type of informat>
format:
1)it should appear only proc step.
2)it is used to write or print the special data values in
the output window.
syntax:format<variable name><type of format>.
informats:1)date formats
a)datew.
b)ddmmyyw.
c)commaw.
d)percent(%)
formats and informats both are same only.
| Is This Answer Correct ? | 2 Yes | 10 No |
Post New Answer View All Answers
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?
what are several options for creating reports in web report studio? : Sas-bi
What system options would you use to help debug a macro? : sas-macro
how sas deals with business intelligence? : Sas-bi
what techniques and/or procs do you use for tables? : Sas programming
describe the interaction table in sas di? : Sas-di
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.
In SAS explain which statement does not perform automatic conversions in comparisons?
To what type of programms have you used scratch macros?
Explain how you can debug and test your SAS program?
what is SAS OPTIMIZATION?
What do you know about sas data set?
Give e an example of..
Explain translate function?
Mention some common errors that are usually committed in sas programming.