I inherited an xlsx file with one particularly irksome field -> guardians data I have: guardians Smith, Joe Smith, Jane Jones, Bill Jones, Pat Wells, Donna I want to create a first and last name for each person. This is the code I used: data pt3; set pt2; Lguard_1=scan(guardians,1,','); Fguard_1=scan(guardians,2,' '); Lguard_2=scan(guardians,-2,' '); Fguard_2=scan(guardians,-1,' '); run; data I now have: Lguard_1    Fguard_1     Lguard_2    Fguard_2 Smith              Joe            Smith,          Jane Jones              Bill             Jones,          Pat Wells               Donna       Wells,          Donna          2 things: 1) i need to get rid of the pesky comma in Lguard_2 and 2) I don't want to repeat a single parent/guardian name such as obs 3. ... View more

this code came from Chris Hemedinger's blog: https://blogs.sas.com/content/sasdummy/2013/06/12/correlations-matrix-heatmap-with-sas/ I want to include the correlation coefficient in each cell of the heat map. If I hover over the output I see the value of r  but I cannot output it. /* Prepare the correlations coeff matrix: Pearson's r method */ %macro prepCorrData(in=,out=); /* Run corr matrix for input data, all numeric vars */ proc corr data=&in. noprint pearson outp=work._tmpCorr vardef=df ; run; /* prep data for heat map */ data &out.; keep x y r; set work._tmpCorr(where=(_TYPE_="CORR")); array v{*} _numeric_; x = _NAME_; do i = dim(v) to 1 by -1; y = vname(v(i)); r = v(i); /* creates a lower triangular matrix */ if (i<_n_) then r=.; output; end; run; proc datasets lib=work nolist nowarn; delete _tmpcorr; quit; %mend; /* Create a heat map implementation of a correlation matrix */ ods path work.mystore(update) sashelp.tmplmst(read); proc template; define statgraph corrHeatmap; dynamic _Title; begingraph; entrytitle _Title; rangeattrmap name='map'; /* select a series of colors that represent a "diverging" */ /* range of values: stronger on the ends, weaker in middle */ /* Get ideas from http://colorbrewer.org */ range -1 - 1 / rangecolormodel=(cxD8B365 cxF5F5F5 cx5AB4AC); endrangeattrmap; rangeattrvar var=r attrvar=r attrmap='map'; layout overlay / xaxisopts=(display=(line ticks tickvalues)) yaxisopts=(display=(line ticks tickvalues)); heatmapparm x = x y = y colorresponse = r / xbinaxis=false ybinaxis=false name = "heatmap" display=all; continuouslegend "heatmap" / orient = vertical location = outside title="Pearson Correlation"; endlayout; endgraph; end; run; /* Build the graphs */ ods graphics /height=600 width=800 imagemap; %prepCorrData(in=sashelp.cars,out=cars_r); proc sgrender data=cars_r template=corrHeatmap; dynamic _title="Corr matrix for SASHELP.cars"; run; %prepCorrData(in=sashelp.iris,out=iris_r); proc sgrender data=iris_r template=corrHeatmap; dynamic _title= "Corr matrix for SASHELP.iris"; run; /* example of dropping categorical numerics */ %prepCorrData( in=sashelp.pricedata(drop=region date product line), out=pricedata_r); proc sgrender data=pricedata_r template=corrHeatmap; dynamic _title="Corr matrix for SASHELP.pricedata"; run;   ... View more

I get nice colored graphs in the Results Viewer but my outputted pdf file is black and white. (this is an update from last week's post) code: ods pdf file="Desktop\plots of sdoc_sc_top10.pdf"; PROC sort data=dst10_math; by demoid; run; proc sgplot data=dst10_math; by demoid; styleattrs datacontrastcolors=(red green blue); vbar testgrade / response=mathpct34 group=level groupdisplay=cluster datalabel=mathpct34; xaxis display=(nolabel noline noticks); yaxis display=(nolabel) values=(0 to 100 by 10) ; run; ods pdf close; ... View more