I have the following data: number location 1 a 2 b 3 c I would like to create a single html file (test.html) where (for example) test.html/#2 would should: number=2 location b Is this possible to do with ods html and proc print;by number;var location;run; Or is there another procedure that I need to use to get these results? Thank you. ... View more

I have a variable called url1 (eg www.abc.com, www.sas.com). How do I include the variable url1 in the code below? Also, I have a macro variable &path (where &path is %let path=%str(http://xyz.com/); How would I combine &path and url2 (where url2 is place1, place2, etc) in the code below to create links like http://xyz.com/place1, http://xyz.com/place2, etc? proc report data=reports nowd style(report)={width=100pct} style(header)={background=cx494068 color=white}; columns date title new; define new / computed " "; compute title; call define(_col_, "style", "style=[color=blue textdecoration=underline url='" url1 "']"); endcomp; run; Thank you. ... View more

How do I increase the font-size of the datalabels (ie inj_yr)? Thank you. proc sgplot data=nu2s description="Plot"; band x=cnt upper=emp_upper lower=emp_lower / transparency=.655 group=category name="bmi"; xaxis min=5 max=50 label='Injury' grid; yaxis min=50 max=250 label='# Employees' grid; keylegend "bmi" / position=bottomright location=outside across=4 title='Rate: '; series x=inj_non y=emp_non / datalabel=inj_yr lineattrs=(pattern=solid thickness=2px) markerattrs=(symbol=circlefilled ) markers group=job_class name="pts"; ... View more

I have three variables: job, count, hours. There are more than 100 observations. The data looks like this: job count hours welder1 10 100 plumber 11 110 lineman 9 120 construction 5 90 welder2 11 200 I would like to create two new variables count1 and hours1. For each job I would like to sum count (ie count1) and sum hours (ie hours1) without including that particular job. For example, for welder1 I would have count1=11+9+5+11 and hours1=110+120+90+200. Thank you for your help. ... View more

How do I specify the color of the bars when using proc gbarline (ie bar inj)? Thank you. proc gbarline data=test; bar inj / sumvar=emp_avg discrete; plot / sumvar=rate; run;quit ... View more

I want the bookmark created by contents="Summary Table" (2nd level), but I don't want the 3rd level bookmark called "Table 1". How do I remove this bookmark (ie "Table 1")? ods proclabel="Region"; proc report data=field nowd contents="Summary Table" Thank you. ... View more

In my HTML output I don't see the keylegend "bmi" (with title='Rate'). How do I fix this? Thank you. goptions device=png; ods listing close; ods html file='Band_Plots.html' path='C:\Documents and Settings\SASCode\Field_Office' style=styles.bmi; ods graphics / reset width=900px height=700px imagename="Band_Plots" imagefmt=png; title1 'Small'; proc sgplot data=mus; band x=injury_cnt upper=upper_hours lower=lower_hours / transparency=.5 group=category name="rate"; xaxis min=0 max=20 label='Injury' grid; yaxis min=0 max=200000 label='Hours' grid; keylegend "bmi" / position=bottom location=outside across=4 title='Rate: '; series x=inj_u y=hour_u1 / datalabel=inj_yr lineattrs=(pattern=solid thickness=2px) markerattrs=(symbol=circlefilled ) markers group=job_class name="pts"; keylegend "pts" / position=bottomleft location=outside across=1 title='Job:'; inset "Rate=Injury / Hours" " " / position=bottomright textattrs=graphfootnotetext; run; ... View more