hi here is a problem can anybody solve this?
i want to report the data through third party file.
by using data _null_ or proc report or macro automation
process. but i want to insert the 'titles and footnotes' in
between the data and also starting of 2nd and ending of 2nd
and starting of 3rd and ending of the 3rd page.
tell me how and write the code?
- 1 Answers
- 2193 Views
- Cognizant, I also Faced
- E-Mail Answers
Answer / Kamal Singh
To insert titles, footnotes, and page breaks using SAS, you can use PROC REPORT or MACRO automation. Here's an example using PROC REPORT:
1. Define the data set containing your data.
2. Create a new data set with necessary variables for your title, footnote, and page break indicators.
3. Use PROC REPORT to create a report with your data, including the necessary titles, footnotes, and page breaks.
4. Format the report as needed.nHere's an example code:nDATA my_data;n /* Your data here */;DATA my_titles_and_footnotes;n /* Titles, footnotes, and page break indicators here */nRUN;nPROC REPORT DATA=my_data NOHEADER BORDER;nPAGEBRK PAGE=(N=3);ntitle1 'Title 1';ntitle2 'Title 2';ntitle3 'Title 3';ntitle4 'Title 4';ntitle5 'Title 5';nfootnote1 'Footnote 1';nfootnote2 'Footnote 2';nnCOLUMN my_column;nDEFINE my_column/nmy_data.my_column / GROUP MEAN NUMERIC;nRUN;nFORMATS my_format.my_column $30.;nPROCCFORMATS DATA=my_titles_and_footnotes OUTPUT=my_formats;nRUN;nPROC FORMATS DATA=my_data;nID my_id; my_format.my_column.
| Is This Answer Correct ? | 0 Yes | 0 No |
what do the pad and dim functions do? : Sas programming
Do you need to combine data sets? How should you combine data sets– MERGE or SET statements in DATA steps,PROC APPEND,PROC SQL?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
What is the difference between proportion and average?
How you can read the variables that you need?
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 does sas handle missing values in assignment statements? : Sas programming
What is a macro routine?
How would you code the criteria to restrict the output to be produced?
Explain data_null_?
What is connection profile? : sas-grid-administration
what is enterprise guide? What is the use of it? : Sas programming
Teradata 
