About abdullala

abdullala · ‎08-02-2012

is it ever possible to associate the color to a treatment group but NOT using treatment group as 'group' or 'subgroup' to draw bar chart? in fact the treatment group will appear totally randomly, but I want to use a special color to associate with a treatment group.

abdullala · ‎09-24-2010

weird thing: in a macro I had included several scripts using %include. in these scripts I had codes like %if - %then %do - %end. I got error message like: ERROR: The %IF statement is not valid in open code. I dont understand how this happened. all these %if stuff are still within the macro, right? Help appreciated!!!

abdullala · ‎02-25-2010

I am using call system to do some dos command, e.g. data _null_; call system("del *.log"); run; how do I close the system window via SAS code?

abdullala · ‎02-09-2010

check the options of cbox=(variable) and cboxfill=(variable) from the tech documentations. these will allow you to assign desired color and fill to a variable (years in your situation). you will need to create this color variable in your dataset precip_boxplot1.

abdullala · ‎02-06-2010

thank you all very much. too bad the font I am using doesnt support it. I wanted a 'square' sign, cm^2.

abdullala · ‎02-05-2010

other approaches in addition to using dictionary: 1. right-click on the dataset and choose 'view columns' 2. use proc contents

abdullala · ‎02-05-2010

Using ods rtf as output, how to apply superscript to the axis name? I tried {\super } and seems that axis doesnt recognize it. I am using proc boxplot and proc gplot.

abdullala · ‎02-01-2010

when I used put(value, percent12.1), I got a parenthesis around a negative value, e.g. -37.2% is output as '(37.2%)'. How can I output just '-37.2%'? What is the correct format name? thanks!

abdullala · ‎01-31-2010

thank you all, I should use call symput. yes, I need all those in macro variables to be called in some other places.

abdullala · ‎01-31-2010

data test; input grp1 grp2 count cntvarname; cards 1 1 8 g1_g1 1 2 9 g1_g2 1 3 7 g1_g3 2 1 5 g2_g1 2 2 6 g2_g2 ; How do I assign each of the count values to a macro variable whose name is defined in cntvarname? that is, I want a macro variable g1_g1 has value 8, g1_g2 =9, etc. proc sql select into: needs a resolved macro variable name. I can not get this work. much appreciate for help!

abdullala · ‎01-31-2010

what is the correct method and SAS procedure to calculate the 95% confidence interval of the difference of rates in 2 groups? For example, group A has 28 subjects and 20 improved, group B has 14 subjects and 8 improved. So the improvement rate for group A is 20/28=71.4%, improvement rate for group B is 8/14=57.1%. The difference of rates is 0.14. what is the right way to calculate 95% CI for that?

abdullala · ‎01-22-2010

if the format is always ddd-dddd (d for a digit) and there is no digit in strings in front of it, then you may toggle with anydigit(drugname) and index(drugname, '-'). or you can scan the string with delimitator space and '-' and see what you get from the data.

abdullala · ‎01-22-2010

data one; input type seq id; cards; 900 1 12345 905 2 12345 166 3 12345 900 1 90171 905 2 90171 900 1 11145 905 2 11145 105 3 11145 run; proc sql; create table justtwo as select distinct id from one group by id having count(id) =2 ; quit;

abdullala · ‎01-21-2010

or you may simply create new variables F1 -- F16 in the loop, as array f (*) f1 - f16; ... do i=1 to dim(f); f(i)=field(i); end; then delete the original fields.

abdullala · ‎01-21-2010

1. if there are different data types in these variables array will not work. 2. the do loop in the data step should not use %, i.e. this is not a macro level loop. what messages do you get from the log?

Online Status	Offline
Date Last Visited	‎09-01-2015 07:11 AM

color selection in proc gchart

open code in macro

close system window

Re: boxplot fill color for blocking variable

Re: superscript on axis

Re: How to search variables in SAS?

superscript on axis

format for percentage

Re: proc sql select

proc sql select