About chrisgo

chrisgo · ‎05-21-2015

given dataset below, i want to compute the pooled sigma by Group. Already tried Ttest but it is limited to two class variables Group COUNT MEAN SIGMA MEAS_DATE a 501 101.1664 12.62792 14-Apr-15 a 123 103.33 10.545 8-Apr-15 b 164 99.21071 16.14705 8-Apr-15 b 697 86.24266 9.794989 9-Apr-15 c 223 82.22 7.422 7-Apr-15 c 780 84.10039 8.913545 8-Apr-15

chrisgo · ‎05-15-2015

thanks!

chrisgo · ‎05-14-2015

I want to get RMSE of a correlation plot vs. a linear fit with slope=1 / intercept=0. JMP can do it, but its hard if I'm using lots of by groups. Below is the example using JMP Thanks!

chrisgo · ‎04-14-2015

I want to populate the dates for the groups without data with 0%. given: group rate date a 0.10% 1-Mar a 2.00% 2-Mar a 4.00% 3-Mar a 63.00% 4-Mar b 3.00% 1-Mar b 33.00% 2-Mar b 22.00% 3-Mar b 3.00% 4-Mar c 2.00% 1-Mar c 3.00% 2-Mar want: group rate date a 0.10% 1-Mar a 2.00% 2-Mar a 4.00% 3-Mar a 63.00% 4-Mar b 3.00% 1-Mar b 33.00% 2-Mar b 22.00% 3-Mar b 3.00% 4-Mar c 2.00% 1-Mar c 3.00% 2-Mar c 0% 3-Mar c 0% 4-Mar Thanks!

chrisgo · ‎02-24-2015

thanks

chrisgo · ‎02-24-2015

I would want to invert a sequence/order column in a dataset given a max sequence order: example: max sequence order=4 col1 seq A 1 B 2 C 3 D 4 E 2 F 1 change to: col1 seq A 4 B 3 C 2 D 1 E 3 F 4 Thanks,

chrisgo · ‎11-05-2014

I see. Thanks. By the way is there a release date for 9.4m3?

chrisgo · ‎11-04-2014

I've been using the code below to apply our company template to the powerpoint slide created by ODS Powerpoint. Just wondering if its possible to have different image background for layout=titleslide and layout=titleandcontent since we have different powerpoint template for both title and content. proc template; define style styles.imagebackground; parent=styles.powerpointlight; class body / backgroundimage="C:\\Documents\template.jpg"; class SysTitleAndFooterContainer / font = heading_font borderspacing = 0 textalign = right; class SystemTitle / font = heading_font textalign = right; end; run; Thanks and BR,

chrisgo · ‎10-29-2014

Need help on creating a sum column by group. Here's the sample: group name value want_column grp1 name1 1 1 grp1 name2 2 3 grp1 name3 3 6 grp1 name4 4 10 grp2 name5 5 5 grp2 name6 6 11 grp2 name7 7 18 grp2 name8 8 26 Thanks,

chrisgo · ‎07-14-2014

Hi, I attached the data and here's the program for the chart: ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- proc template; define statgraph Graph3; dynamic V1 V2 V3 v4 v5 v6; begingraph / designwidth=1050 designheight=380; entrytitle halign=center "xxxxxxxxxxxxxxxxxxxxxxxxxx" / textattrs=(size=14 ); layout lattice / rowdatarange=data columndatarange=data rows=1 rowgutter=10 columngutter=10; layout overlay / xaxisopts=(discreteopts=( tickvaluefitpolicy=splitrotate tickvaluerotation=vertical) type=discrete griddisplay=on labelattrs=(size=12 style=NORMAL weight=BOLD )) yaxisopts=( griddisplay=on label=('%sDET Yield') labelattrs=(size=12 style=NORMAL weight=BOLD ) linearopts=(viewmax=1.0 viewmin=0.7)) y2axisopts=( label=('VOLUME') labelattrs=(size=12 style=NORMAL weight=BOLD ) linearopts=(viewmin=0)) ; barchart x=V2 y=V5 / group=V1 name='bar' yaxis=Y2 display=(FILL) groupdisplay=Stack dataskin=pressed clusterwidth=1.0 ; scatterplot x=V2 y=V3 / group=V1 name='scatter' MARKERCHARACTERATTRS=(size=11 ) MARKERCHARACTER=toolmark rolename=(tip1=PRODUCT tip2=TOOL tip3=TEST_DATE tip4=DET_YIELD tip5=VOLUME tip6=TARGET) tip=(tip1 tip2 tip3 tip4 tip5 tip6 ); seriesplot x=V2 y=V3 / group=V1 name='series' connectorder=xaxis lineattrs=(pattern=SOLID thickness=2 ); seriesplot x=V2 y=V6 / name='series2' display=(markers) connectorder=xaxis lineattrs=(color=CX639A21 pattern=SOLID thickness=3 ) markerattrs=(color=CX639A21 symbol=CIRCLEFILLED size=14 ); seriesplot x=V2 y=LCL / name='LL' connectorder=xaxis lineattrs=(color=red pattern=DASH thickness=2 ); seriesplot x=V2 y=UCL / name='UL' connectorder=xaxis lineattrs=(color=red pattern=DASH thickness=2 ); seriesplot x=V2 y=TARGET / name='Target' connectorder=xaxis lineattrs=(color=black pattern=solid thickness=4 ); endlayout; sidebar / align=bottom spacefill=false; discretelegend 'scatter' / opaque=true border=true halign=center valign=center displayclipped=true across=7 order=rowmajor; endsidebar; endlayout; endgraph; end; run; proc sgrender data=temp(where=(head_type="DN")) template=Graph3; dynamic V1="TOOL" V2="TEST_DATE" V3="DET_YIELD" v4="TARGET" v5="VOLUME" v6="DET_YIELD_OA"; run; ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Thanks!

chrisgo · ‎07-14-2014

I want to adjust the x-axis tick marks for the first chart below to look like the one on the 2nd chart. (The tick value would only display the datetime of 12am per day) The x-axis is datetime. format. Tried the timeopts option but can't get it to work. Thanks !

chrisgo · ‎11-25-2013

Program works. Thanks!

chrisgo · ‎11-25-2013

Hi guys, hope you could help me out on this problem: I have this data set: COL1 COL2 abc def abc xyz rst xyz what I would want is to have this output: Summary by COL1: COL1 COL2 abc def, xyz rst xyz Summary by COL2: COL1 COL2 abc def abc,rst xyz Thanks and BR,

Online Status	Offline
Date Last Visited	‎02-18-2016 04:46 AM

calculate pooled sigma

Re: get RMSE using linear fit (slope=1 / intercept=0)

get RMSE using linear fit (slope=1 / intercept=0)

fill by group with no data

Re: invert a sequence column in a dataset

invert a sequence column in a dataset

Re: ODS Powerpoint: create different template for title page / body

ODS Powerpoint: create different template for title page / body

add cumulative sum column

Re: SGRender: adjust tick options