I want to create three pfos for each year. my variable using to cut the observation is index1. i want to use the mean and construct pfo1: from the lowest number to mean - 1 std dev. pfo 2: mean - 1 std dev to   mean - 1 std dev. pfo 3: mean + 1 std dev to highest number for each year. i know how to obtain 1st and 99th percentile of the observations of each year proc univariate data=pfo.merged_A1 noprint; var index1; by pfoyr; output out=mean pctlpts=1 99 pctlpre=p; run; i feel like i have to use something in that sort.... Many thx, aaron ... View more

hi i have a column name count a          1 b          0 c          0 d          1 e          1 i want to arrive at sum= 3, which counts the 1s. thank you! ... View more

I have an index from 1991-2013. Because they are all over the place, I have manually looked into them to assign portfolios for them each year. I have divided the pfo into 3 pfos each year and want to write a code for it but don’t know how to. For example I want to write something like the below for 1991-2013., data f2; set f1; pfo=.; if pfoyr=1991, and index<-1.22 then pfo=1, -1.22=<index<=2.48 then pfo=2, and index >2.48 then pfo=3; run; Could you kindly let me know how to write such a code? ... View more

apologies for the hassle I have just two simple questions. 1)  I want to delete siccd that is equal to 131, 170, 195, 204..and its not working. data r8; set r7; if siccd in (131,170, 195, 204); run; 2) I want to delete siccd from 2100-2199 data r8; set r7; if siccd ne (2100-2199); run; could u plz help?? ... View more

Hi I have dataset: year name one_str_a one_str_b one_str_c one_con_a one_con_b one_con_c two_str_a two_str_b two_str_c two_con_a two_con_b two_con_c 1991 john 2 1 1 1 1 2 1 1 1 1 2 1 1991 amy 1 0 0 0 0 1 0 0 0 0 1 0 1991 ted 2 0 1 0 1 2 1 0 1 1 2 1 1991 tom 1 2 0 2 0 1 0 2 0 0 1 0 1992 john 0 1 0 1 0 0 0 1 0 0 0 0 1992 amy 0 2 2 2 2 0 2 2 2 2 0 2 1992 ted 2 1 1 1 1 2 1 1 1 1 2 1 1992 tom 1 2 2 2 2 1 2 2 2 2 1 2 my years are from 1991 to 2012 and i have more observations than the above but i just wanted to give you a picture. my scores range from 0~2. I want it in this form: varname Score 1991 john one_str_a 2 1991 john one_str_b 1 1991 john one_str_c 1 1991 john one_con_a 1 1991 john one_con_b 1 1991 john one_con_c 2 1991 john two_str_a 1 1991 john two_str_b 1 1991 john two_str_c 1 1991 john two_con_a 1 1991 john two_con_b 2 1991 john two_con_c 1 Could you kindly provde me of your guidance? ... View more

thank you very much for reading this. my data looks like this yr name      strength_a strength_b    strength_c     strength_d class 1991 john            2 1 0 0 a 1991 amy           1 0 2 1 a   1991 ted             0 2 1 1 b 1991 tom           2 2 0 0 b 1992 john            2 1 0 0 a 1992 amy           1 0 2 1 a   1992 ted             0 2 1 1 b 1992 tom           2 2 0 0 b my years are from 1991 to 2012 and i have more observations than the above but i just wanted to give you a picture. my scores range from 0~2. I want to arrive at the format below: Yr         name    varname            score    class 1991     john      strength_a 2          a 1991     john      strength_b 1          a 1991     john      strength_c 0          a 1991     john      strength_d 0          a 1991     amy      strength_a 1          a 1991     amy      strength_b 0          a 1991     amy      strength_c 2          a 1991     amy      strength_d 1          a Could you kindly provde me of your guidance? ... View more