About mmkr

mmkr · ‎07-16-2024

I don't want in to the table I want text in the body of the report like below !!

mmkr · ‎07-16-2024

data check; input name $ age; cards; abc 10 def 11 ghj 23 kld 45 ; run; ods pdf file="test.pdf" bookmarklist=none ; proc report data=check; columns name age; define name / "Name"; define age / "Age"; /*if age is greater than 19 */ /*then i want body of text says Age is greater than 19 you can enter */ run; ods pdf close;

mmkr · ‎06-27-2024

Iam looking for out put like below if first letter has two words like : abc def output : Abc Def data have; informat text $30.; input text &; cards; abc def xyz mno rptd def ; output : Abc Def Xyz Mno Rptd Def

mmkr · ‎06-25-2024

I do want in by statment but i don't want in to table of contents

mmkr · ‎06-25-2024

How do i remove from table of contents just one variable (not all) I jsut want to remove age from table of contents but show sex as by variable have 2 variables sex and age but table of contents i need only one show up Code : proc sort data=sashelp.class out=output;by sex age;run; proc freq data=output noprint; table age/out=age; run; %macro report(age=); proc report data=output nowd;by sex age; where age=&age.; run; ods pdf startpage=now; proc odstext; p 'Signature: ________________'/style={fontsize=8 just=r}; run; %mend; ods pdf file='c:\temp\temp.pdf' ; options nodate nonumber; title j=r ' PageNo:(*ESC*){thispage} '; data _null_; set age; call execute(catt('%report(age=',age,')')); run; ods pdf close;

mmkr · ‎06-25-2024

Thanks so much , it worked as i needed

mmkr · ‎06-25-2024

Below is the updated code : Iam getting signature page on only last page , but i need it for every by variable proc sort data=sashelp.class out=output;by age;run; ods pdf file='c:\temp\temp.pdf' ; options nodate nonumber; title j=r ' PageNo:(*ESC*){thispage} '; proc report data=output nowd;by age; ods pdf startpage=now; proc odstext; p 'Signature: ________________'/style={fontsize=8 just=r}; run; ods pdf close;

mmkr · ‎06-24-2024

i want completely in to the second page

mmkr · ‎06-24-2024

Iam looking for report like below , 2nd page always should be signature page like below By variable is Age let's say i have 35,40,45 ages so it should be total 6 pages 3 pages of data and 3 pages of signature pages but 2nd page should be always a signature page like below Page No :1 Title "Report Page1" by Age 35 Name Age Sex Tom 35 M Martin 35 M Sophie 35 F Page No : 2 I here by confirm ---------Signature above report is correct Page No : 3 Title "Report Page1" by Age 40 Name Age Sex Stephine 40 M Don 40 M Thomas 40 M Page No : 4 I here by confirm ---------Signature above report is correct

mmkr · ‎06-24-2024

Iam looking for report like below , 2nd page always should be signature page like below By variable is Age let's say i have 35,40,45 ages so it should be total 6 pages 3 pages of data and 3 pages of signature pages but 2nd page should be always a signature page like below Page No :1 Title "Report Page1" by Age 35 Name Age Sex Tom 35 M Martin 35 M Sophie 35 F Page No : 2 I here by confirm ---------Signature above report is correct Page No : 3 Title "Report Page1" by Age 40 Name Age Sex Stephine 40 M Don 40 M Thomas 40 M Page No : 4 I here by confirm ---------Signature above report is correct

mmkr · ‎06-23-2024

Thanks so much it worked as i needed !!

mmkr · ‎06-23-2024

I have ID as unique but above code is not working Input1 ID Col1 Col2 Col3 Col4 Col5 123 laptop Keyboard Mouse1 Screen watch1 123 laptop Keyboard Mouse2 Screen watch2 123 laptop Mouse3 watch3 123 laptop 123 laptop Output1 ID Col1 Col2 Col3 Col4 Col5 123 laptop Keyboard Mouse1 Screen watch1 123 Mouse2 watch2 123 Mouse3 watch3

mmkr · ‎06-22-2024

How i do i remove duplicates and display only once i proc report ? Please see the input and output Input1 Col1 Col2 Col3 Col4 Col5 Input2 Col1 Col2 Col3 Col4 Col5 laptop Keyboard Mouse1 Screen watch1 laptop Keyboard Mouse1 watch1 laptop Keyboard Mouse2 Screen watch2 laptop Keyboard Mouse2 watch2 laptop Mouse3 watch3 laptop Mouse3 watch3 laptop laptop laptop laptop Output1 Col1 Col2 Col3 Col4 Col5 Output2 Col1 Col2 Col3 Col4 Col5 laptop Keyboard Mouse1 Screen watch1 laptop Keyboard Mouse1 watch1 Mouse2 watch2 Mouse2 watch2 Mouse3 watch3 Mouse3 watch3

mmkr · ‎06-22-2024

Thanks so much , it's worked

mmkr · ‎06-22-2024

/*I want to add page number variable into macro variable */ /*I want to reset pagenumber when ever new age starts in new page */ /*Basically I need two pagenumbers one is full in order, other one is by age */

Online Status	Offline
Date Last Visited	‎08-14-2024 02:19 PM

Re: Proc report Conditional body of text

Proc report Conditional body of text

First Letter upcase if first name has two words

Re: How do i remove from table of contents just one variable (not all...

How do i remove from table of contents just one variable (not all)

Re: Create second page always as signature page and by variable

Re: Create second page always as signature page and by variable

Re: Create second page always as signature page and by variable

Report in two pages by variable

Create second page always as signature page and by variable

Re: Duplicate values display only once

Re: Completely turn off the table of contents in ods pdf

Re: Question related to DataMart’s of SAS Environment Manager ( versio...

Re: Two tables check all columns

Re: Two tables check all columns

Re: Completely turn off the table of contents in ods pdf

Re: Proc report Conditional body of text

Proc report Conditional body of text

First Letter upcase if first name has two words

Re: How do i remove from table of contents just one variable (not all...

How do i remove from table of contents just one variable (not all)

Re: Create second page always as signature page and by variable

Re: Create second page always as signature page and by variable

Re: Create second page always as signature page and by variable

Report in two pages by variable

Create second page always as signature page and by variable

Re: Duplicate values display only once

Re: Duplicate values display only once

Duplicate values display only once

Re: Pagenumber assign into macrovariable

Re: Pagenumber assign into macrovariable