Hi SAS community I have heatmap of values (0-1). I have on a BY variable ("disease"). I want to do and I can't work out how: Fix the color range to be 0-1. Currently it is using the minimum value in my dataset to be white, maximum to be black. I want white=0 and Black=1. Fix the color range across BY groups. Obviously with 1. above, when I do BY statement, it changes color map across the BY groups because it not fixed at 1 and 0. I want 'color legend' for all plots to display the full range: 0 (white) to 1 (black) Any help would be appreciate   proc template; define statgraph corrHeatmap; dynamic _Title; begingraph; entrytitle _Title; rangeattrmap name='map'; endrangeattrmap; rangeattrvar var=r attrvar=r attrmap='map'; layout overlay / xaxisopts=(display=(line ticks tickvalues label) label=('Weeks wear')) yaxisopts=(display=(line ticks tickvalues label) label=('Weeks wear')); heatmapparm x = x y = y colorresponse = rsquare / xbinaxis=true ybinaxis=true name = "heatmap" display=all colormodel=(white black); continuouslegend "heatmap" / orient = vertical location = outside title="Pearson Correlation"; endlayout; endgraph; end; run; proc sort data=fit; by disease; run; proc sgrender data=fit template=corrHeatmap; by disease; dynamic _title="Correlation matrix"; run;   ... View more

Hi SAS Forus,   I have a regression line and it only creates this for the x data that I have. How do I get to project beyond the x data?   proc sgplot data=input; reg x=months y=change_height / clm cli; series x=months y=change_height /group=ani markerattrs=(symbol=CircleFilled); scatter x=months y=change_height /group=ani markerattrs=(symbol=CircleFilled); xaxis max=20; yaxis min=-20 max=20; refline -10 10 / axis=y; run; Would this be easier to implement with proc reg? Thanks! ... View more

Hi SAS Communities I have a question. I have a hexidecimal value (for example 20 e9 ef 01), but I need to convert this to little endian format first (byte swapping) before I can get the decimal number. For this examples it would be that hexadecimal 20 e9 ef 01 is converted to little endian of 01 EF E9 20 which can then be converted to integer of 32500000 (UINT32). How do I do this process in SAS? I have following   data test; set indata; format tab hex8.; lit_end=input(tab,$UCS2LEw.); run; I assumed simply applying new informat of little endian would convert hexidecimal to little endian format. But it show: ERROR 48-59: The informat UCS2LEW was not found or could not be loaded.   I wonder if other way to do?   Any help would be very great. ... View more

Hi SAS Community, How do I get SAS to output mean of means as a dataset, without doing two proc means statements? I want calculate means between two study, but I want use the subject means to calculate this first. Currently I am doing by two proc means statements but is this long way the only way to do. Any help would be brilliant proc sort data=ffgorn_v6; by study subject; run; proc means data=ffgorn_v6 nway; class study subject; var abs diff ffhang; output out=means_1 Mean= /autoname; run; proc means data=means_1; by study; var abs_Mean diff_Mean ffhang_Mean; output out=means_2 Mean= /autoname; run; Thank you!! 💖 ... View more

Hi SAS Community, I use proc nlin to fit various models to data. I want to be able to say for example "if the distribution of square errors has these features, then do ..." Does proc nlin output the distribution of squared errors as a dataset, or do I have to go back and use the model parameters to manually get the SE distribution? I am trying make this as efficient as possible as have multiple datasets to process, with each dataset containing ~60,000 rows, and each dataset required  ~1,700 non-linear fits (/calls of proc nlin).   Any tips would much be appreciated! LinLin Jiang ... View more