Hi All, I need to calculate the posterier probability for the objective response rate>=40 % based on the observed number of  responders. I was looking for the whihc SAS procedure could be used but find the any example for the it. so could you please guide me for the same.   Thank you   ... View more

I have data in .txt file ,where each word is separated by single space like below. mayoflstat mayolc accrual mayolc   Now I would like to read the .txt file and create a single variable having the below values.   Text mayoflstat mayolc accrual mayolc   data test; INFILE '/home/rpv/var.txt' dlm =" " ; INPUT Text  $1000.; RUN;   I there any options need to add the above code to get the required result? or need to update the code.   Thank you in advance.   ... View more

   Below is the script, In which I am trying to execute the "read sub" but unfortunately not able to get the expected result and giving the null  value for "$sub". Example: Below is the prompt massage which I am getting but the expected result should be  in 2) example. 1)  Sub setting condition:check Checking the macro [] 2) Sub setting condition:check Checking the macro [check]   #!/bin/sh { echo '%macro read;' echo '%sysexec ( echo -n "Sub setting condition:");' echo '%sysexec ( read sub) ;' echo '%sysexec ( echo "Checking the macro [$sub]");' echo '%mend;' echo '%read;' } > "/home/read.sas" cd /home sas /home/read.sas   Thank you in advance. ... View more

Hi All, I am using SAS 9.4 to generate a Heatmap plot through SAS GTL code and want to control the size of boxes/tiles. Please let me know options/statement to for the same.   %macro RandBetween(min, max); (&min + floor((1+&max-&min)*rand("uniform"))) %mend; data test (drop=i); do emp = 1 to 7 ; do i = '01JAN2017'd to '31DEC2017'd; date=i; value = %RandBetween(0, 100); day = day (date); weekday = weekday (date); week = week (date); month =month (date); format date Date7.; output ; end;end; run;  proc sort data = test; by emp week month ; run; proc univariate data = test ; by emp week month; var value ; output out=teststat mean=mean1 ; run; data teststat1; set teststat; if mean1 <= 0 then cat = 0; else if 0<mean1 <= 25 then cat = 1; else if 25 < mean1 <=50 then cat = 2; else if 50 < mean1 <= 75 then cat = 3; else if 75 < mean1 <= 100 then cat = 4; run; proc template; define statgraph heatmap; begingraph / designheight=150 designwidth=1000 pad=0; rangeattrmap name="rmap"; range min - max / rangecolormodel=( darkred red yellow green darkgreen); endrangeattrmap; rangeattrvar attrmap="rmap" var=cat attrvar=cat; layout overlay / yaxisopts=(offsetmin=0.02 display=(ticks tickvalues line) tickvalueattrs=(size=8)) xaxisopts =(offsetmin=0.02 display=(ticks tickvalues line) linearopts=( viewmin=1 viewmax=54 tickvaluelist=(1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53)) tickvalueattrs=(size=3)); heatmapparm x=week y=emp colorresponse=cat / name="heatmap" xgap=0 ygap=0 display=(fill outline) outlineattrs=(color=black); continuouslegend "heatmap" / valueattrs=(size=8) ; endlayout; endgraph; end; run; proc sgrender data=teststat1 template=heatmap; run;   I have attached the output.   Thank you in advance ... View more