I found that. data Want; set have; Week_start=intnx('Week.7',date,0,'b'); format Week_start mmddyy10.; run; ... View more

Here the week_start starts on Sunday. How can I modify the code, so the week_start starts on Saturday? ... View more

I am using SAS EG (Version: 8.3 (8.3.0.103) (64-bit))   How can I bold only the first word (In the following ods pdf text=  statement, "Introduction") in my text in a report? Please see the code below. ods _all_ close; ods escapechar='^'; ods pdf style=pearl file="\\--------------abc.pdf" notoc startpage=no NOGTITLE NOGFOOTNOTE style=htmlblue; options nodate number leftmargin=.5in rightmargin=.5in; ods pdf text= "^S={ font_size= 9pt}Introduction: For example, in Word or Excel, you would type a sentence and then highlight the word you wanted to have bold and then click the B (bold icon) on the toolbar. SAS data values are different from what you see in Word or Excel. SAS data values do not have colors or fonts applied to them as they are stored in the SAS data set."; ods pdf close;   ... View more

I have created example of such code from SASHELP.CARS data set and posted as you suggested. ... View more

Here is a SAS program for example. I would like to print a PDF of four pages. Page-1 will contain report titles and intro paras. Page-2 will contain two figures with their titles page-3 will contain table-1 with title page-4 will contain table-2, and -3 with their titles All pages will have footer. data Title1; Text="SAS Help Cars report"; output; run; data Title3; Text="All cars"; output; run; data Title4; Text="&SYSDATE9"; output; run; data Title5; Text="Bextran Road Transport authority"; output; run; data Intro1; Text="Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blahBlah blah blah Blah blah blah Blah blah blah"; output; run; data Intro2; Text="Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blah Blah blah blahBlah blah blahBlah blah blah Blah blah blah Blah blah blah "; output; run; ods _all_ close; ods pdf file="\\accounts..................pdf" notoc startpage=no NOGTITLE NOGFOOTNOTE ; ODS Graphics / reset=all width=7.5in height=4in scale=on border=off imagefmt=png; options nodate number ; footnote2 height=7pt justify=left "Blah blah blah blah"; footnote3 height=7pt justify=left "Blah blah blah blah"; footnote4 height=7pt justify=left "Blah blah blah blah"; footnote5 height=7pt justify=left " "; footnote6 height=8pt justify=left "Blah blah blah blah"; footnote7 height=8pt justify=right "&SYSDATE"; /*Start: Title and Introduction in the output*/ proc report data=title1 nowd noheader style(report)={outputwidth=72% rules=none frame=void} style(column)={fontsize=18pt fontweight=Bold}; column Text; define Text / style={just=c}; run; proc report data=title3 nowd noheader style(report)={outputwidth=100% rules=none frame=void} style(column)={fontsize=16pt fontweight=Bold}; column Text; define Text / style={just=c}; run; proc report data=title4 nowd noheader style(report)={outputwidth=100% rules=none frame=void} style(column)={fontsize=14pt fontweight=Bold}; column Text; define Text / style={just=c}; run; proc report data=title5 nowd noheader style(report)={outputwidth=100% rules=none frame=void} style(column)={fontsize=14pt fontweight=Bold}; column Text; define Text / style={just=c}; run; proc report data=Intro1 nowd noheader style(report)={outputwidth=100% rules=none frame=void} style(column)={fontsize=8pt}; column Text; define Text / style={just=l}; run; proc report data=Intro2 nowd noheader style(report)={outputwidth=100% rules=none frame=void} style(column)={fontsize=8pt}; column Text; define Text / style={just=l}; run; title height=10pt justify=left "Fig 1: Blah blah blah blah"; proc sgplot data=sashelp.cars ; series x=Type y=MSRP /datalabel=MSRP lineattrs=( thickness=3 pattern=shortdash ) markers legendlabel="ASP" ; series x=Type y=Invoice /datalabel=Invoice lineattrs=( thickness=3 pattern=longdash) markers legendlabel="PVSP"; format MSRP Invoice ; yaxis label='blah blah' LABELATTRS=(Family=Arial Size=10 Style=Italic Weight=Bold) valueattrs=(Family=Arial color=gray size=10pt); xaxis valueattrs=(Family=Arial color=gray size=10pt) display= (nolabel) NOTIMESPLIT VALUESROTATE= VERTICAL; run; title; title height=10pt justify=left "Figure 2. blah blah blah blah"; proc sgplot data=sashelp.cars ; series x=Type y=MSRP /datalabel=MSRP lineattrs=( thickness=3 pattern=shortdash ) markers legendlabel="ASP" ; series x=Type y=Invoice /datalabel=Invoice lineattrs=( thickness=3 pattern=longdash) markers legendlabel="PVSP"; format MSRP Invoice ; yaxis label='blah blah' LABELATTRS=(Family=Arial Size=10 Style=Italic Weight=Bold) valueattrs=(Family=Arial color=gray size=10pt); xaxis valueattrs=(Family=Arial color=gray size=10pt) display= (nolabel) NOTIMESPLIT VALUESROTATE= VERTICAL; run; title height=10pt justify=left "Table 1. table table table table"; proc report data=sashelp.cars; Where make in ("Honda" "Kia" "GMC"); column Make Model Type; define Make / group "Make" ; define Model / display "Model"; define Type / display "Type"; run; title height=10pt justify=left "Table 2. table table table table"; proc report data=sashelp.cars; Where Make = "Honda"; column Make Type; define Make / group "Make"; define Type / display "Type"; run; title height=10pt justify=left "Table 3. table table table kia" ; proc report data=sashelp.cars; Where Make = "Kia"; column Make Type; define Make / group "Make"; define Type / display "Type"; run; title; footnote; ods pdf close; ... View more

This is an example data. I am using Surveyfreq to get confidence limit. data have; input ID Country $ Gender $ Result $; datalines; 1 A Male Positive 2 B Male Negative 3 C Female Negative 4 A Female Negative 5 B Male Positive 6 C Male Positive 7 A Female Positive 8 B Female Negative 9 B Male Positive ; Data have; set have; if Country="A" then Prob=0.0617; if Country="B" then Prob=0.0300; if Country="C" then Prob=0.0780; Wt=1/Prob; run; ... View more

Example of a starting data and SAS code are mentioned below. Actually, I am curious, what formula was used to calculate the "Std Err of Percent" in the back end?   data have; input ID Gender $ Result $; datalines; 1 Male Positive 2 Male Negative 3 Female Negative 4 Female Negative 5 Male Positive 6 Male Positive 7 Female Positive 8 Female Negative 9 Male Positive ; Data have; set have; if Gender="Male" then Prob=0.0617; if Gender="Female" then Prob=0.0300; Wt=1/Prob; run; proc surveyfreq data=have; table Gender*Result / cl; Weight wt; run; ... View more

I like your idea, but I was wondering, WEIGHT of which variable? Would you please give me an example? ... View more