07-14-2022
manoj_pandey
Fluorite | Level 6
Member since
03-28-2012
- 10 Posts
- 2 Likes Given
- 0 Solutions
- 0 Likes Received
-
Latest posts by manoj_pandey
Subject Views Posted 842 07-13-2022 09:48 PM 892 07-13-2022 10:07 AM 961 12-11-2018 02:00 AM 973 12-11-2018 01:15 AM 1641 04-05-2018 06:00 AM 1643 04-05-2018 05:56 AM 1706 04-05-2018 02:08 AM 1901 11-12-2017 03:11 AM 1953 11-11-2017 05:27 PM 50811 03-25-2016 10:15 AM -
Activity Feed for manoj_pandey
- Posted Re: SAS procedure for Posterior probability on Statistical Procedures. 07-13-2022 09:48 PM
- Posted SAS procedure for Posterior probability on Statistical Procedures. 07-13-2022 10:07 AM
- Posted Re: Reading raw data from an external files on SAS Programming. 12-11-2018 02:00 AM
- Liked Re: Reading raw data from an external files for ShiroAmada. 12-11-2018 02:00 AM
- Liked Re: Reading raw data from an external files for learsaas. 12-11-2018 01:59 AM
- Posted Reading raw data from an external files on SAS Programming. 12-11-2018 01:15 AM
- Posted Re: How to use/execute “Read command of unix in sas macro” on SAS Programming. 04-05-2018 06:00 AM
- Posted Re: How to use/execute “Read command of unix in sas macro” on SAS Programming. 04-05-2018 05:56 AM
- Posted How to use/execute “Read command of unix in sas macro” on SAS Programming. 04-05-2018 02:08 AM
- Posted Re: how to control the size of boxes/tiles in HEATMAP Plot on Graphics Programming. 11-12-2017 03:11 AM
- Posted how to control the size of boxes/tiles in HEATMAP Plot on Graphics Programming. 11-11-2017 05:27 PM
- Posted Re: ROC in SAS- obtaining a cut-off value on Statistical Procedures. 03-25-2016 10:15 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1
07-13-2022
09:48 PM
Below are the details. Please let me know if you need more info. There are 200 subject in study with 100 and 100 treated patients in TRT1 and TRT2, respectively, Objective response rate (ORR) can be estimated with a maximum standard error of 0.041 and 0.071, respectively. Assuming a beta (0.5, 0.5) prior: •TRT1: if 44 responders (out of 100 patients, ORR of 44%) are observed, the posterior probability of a true ORR >=40% will be >=0.80 (0.841). •TRT2: if 46 responders (out of 100 patients, ORR of 46%) are observed, the posterior probability of a true ORR >=40% will be >=0.80 (0.807).
... View more
07-13-2022
10:07 AM
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
12-11-2018
01:15 AM
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
04-05-2018
06:00 AM
Now, I am using the SAS procedure within the SAS macro but read command is not working. #!/bin/sh x=$(pwd) { echo "option symbolgen mprint mlogic ;" echo "libname sasdata '$x' access=readonly ;" echo "%macro read;" echo 'x "echo -n 'Enter Name:'; read name; echo Datset name is [$name];" ' echo 'x cd $x;' echo "libname sasdata '$x' access=readonly ;" echo "proc freq data=sasdata.$name ;" echo "tables _character_ / missing;" echo "run;" echo '%mend;' echo '%read;' } > $x/read.sas cd $x sas "$x/read.sas" But here again $name is getting resolved.
... View more
04-05-2018
05:56 AM
Hi Kurt, Thank you for suggestion. Below script is working for my problem. #!/bin/sh
{
echo '%macro read;'
echo 'x "echo -n 'Sub setting condition:'; read sub; echo Checking the macro [$sub];" ' echo '%mend;'
echo '%read;'
} > "/home/read.sas"
cd /home
sas /home/read.sas I have kept all the command in only one X command so that echo and read command will work in a single execution.
... View more
04-05-2018
02:08 AM
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
11-12-2017
03:11 AM
Hi Warren, Thank you for your suggestion. I changed the design height and width in code and it's changing the boxes/tiles but making graph bigger. My aim to keep graph's dimension as it is and at same time want to change the boxes/size without changing the dimension of graph. For example: keep the 53 boxes and just change the box size (horizontal rectangle) with out changing the graph dimension. In attached output,I want to keep the same symbol/rectangle boxes and just want to reduce the size of it.
... View more
11-11-2017
05:27 PM
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
03-25-2016
10:15 AM
Hi Dverbel, Is the above formula for getting the cut-off value is correct.? I am not sure about the formula.
... View more