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?
6 15792If reading an external file to produce an external file, what is the shortcut to write that record without coding every single variable on the record?
4 7304If you?re not wanting any SAS output from a data step, how would you code the data statement to prevent SAS from producing a set?
1 5242
What is the use of %include statement?
What is data _null_?
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.
Mention common programming errors committed in sas ?
What is proc sort?
How are numeric and character missing values represented internally?
Which date function advances a date, time or datetime value by a given interval?
How will you generate test data with no input data?
how do the in= variables improve the capability of a merge? : Sas programming
What is run-group processing?
describe the interaction table in sas di? : Sas-di
How would you identify a macro variable? : sas-macro
What are the functions used for character handling?
how are numeric and character missing values represented internally? : Sas programming
describe how to adjust the performance of data integrator? : Sas-di