About EMKBB

EMKBB · ‎03-08-2012

Thanks, PGStats and Reeza. Is there a way of determining which combinations had zero count as part of proc freq?

EMKBB · ‎03-06-2012

Could the expected frequecies have been calculated and extracted similarly?

EMKBB · ‎03-06-2012

Hi PGStats, Thanks!

EMKBB · ‎03-06-2012

I wish to convert a of the form below table Color Style A1 B1 A1 B5 A5 B2 A3 B3 A2 B1 A2 B2 A4 B1 A1 B3 A5 B1 A3 B4 A4 B4 A5 B2 A4 B2 A4 B5 A1 B2 A3 B1 A5 B1 A2 B3 A4 B2 A3 B2 A5 B3 A2 B3 A4 B3 A1 B4 A2 B5 into a contingency table and extract the frequecies into the form of table [ii] below. Could you please direct me to any material that could help me do this? "color" "Style" "Count" "A1" "B1" 4 "A1" "B2" 2 "A1" "B3" 4 "A1" "B4" 1 "A1" "B5" 6 "A2" "B1" 1 "A2" "B2" 3 "A2" "B3" 2 "A2" "B4" 0 "A2" "B5" 4 "A3" "B1" 3 "A3" "B2" 3 "A3" "B3" 1 "A3" "B4" 5

EMKBB · ‎09-19-2011

Dear Art297 Thanks for the lead, I will check the paper up, try it and get back to you.

EMKBB · ‎09-17-2011

Dear All, How can AbAa, AeAi, AmAp, AfAd, AtAc, . . . be converted to the code 01, 02, 03, 04, 05, . . . where the codes 01, 02, . . . are generated by the system? I have two columns (variables) of character values as shown above with some of the values repeating, and I would want to be able to tell which character value was converted to which code. Each variable holds thousands of values. Thank you.

EMKBB · ‎10-12-2010

Sorry Paige, if I was not explanatory enough, here we go: In the table below, Observation 1 and Observation 5 have the same SA value, but the DA value of Observation 1 is greater than that of Observation 5 so in reading the data, Observation 1 will be selected but Observation 5 will be dropped. Again Observation 2 and Observation 13 have the same SA values, and incidentally their AD values are also the same, so here we resort to their RS values (which are not the same). The RS value of Observation 13 is higher, so it will be selected and Observation 2 dropped. Observations with unique SA values will be selected. Observations 4, 7, 8, 12 will not be selected because they have the values Tl, Ng, Yd and Tl respectively. Observation SA AD RS SP 1 15 20 19 Bt 2 18 21 22 Ab 3 16 18 16 Ab 4 10 12 15 Tl 5 15 19 17 Bt 6 20 22 24 Ef 7 13 16 17 Ng 8 26 27 29 Yd 9 22 23 26 Ef 10 24 26 28 Dd 11 23 25 27 Bt 12 27 29 30 Tl 13 18 21 23 Ef 14 21 22 25 Ab 15 12 14 16 Dd

EMKBB · ‎10-12-2010

Thanks Patrick.

EMKBB · ‎10-12-2010

Thanks sbb, I will look it up.

EMKBB · ‎10-11-2010

Paige, Not quite, you compare the observations with each other and select the ones that meet the above criteria. Those with unique SA values will definitely be selected.

EMKBB · ‎10-11-2010

Thanks Paige, What I mean is that if two observations have the same SA value, then select the one with the higher AD value. If it turns out that their AD values are also the same, then select the one with the higher RS value. Any observation whose SP value is equal to Yd or Tl or Ng should not be selected. All observations which have unique SA values will be selected. (I used i and j to identify any two given observations. I hope the situation is clearer now). EMKBB

EMKBB · ‎10-11-2010

Hello, I am new to SAS, and I am looking for material that will enable me to code and do the following: I am trying to select the observations in a data set that meet the following criteria: Variables: SA, AD, RS, SP (there are other variables but these are what is needed to do the selection). When SA(i) equals SA(j) and AD(i) is not equal to AD(j) Select Observation i if AD(i) is greater than AD(j) Select Observation j if AD(i) is less than AD(j), When SA(i) equals SA(j) and AD(i) equals AD(j) Select Observation i if RS(i) is greater than RS(j) Select Observation j if RS(i) is less than RS(j), Ignore Observation i if SP(i) equal to Yd or Tl or Ng. Thank you.

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

Re: Extracting frequencies from contingency table

Extracting frequencies from contingency table

Extracting frequencies from contingency table

Extracting frequencies from contingency table

System generated codes

System generated codes

Re: Conditional Selection

Re: Conditional Selection

Re: Conditional Selection

Re: Conditional Selection

Re: Extracting frequencies from contingency table

Extracting frequencies from contingency table

Extracting frequencies from contingency table

Extracting frequencies from contingency table

System generated codes

System generated codes

Re: Conditional Selection

Re: Conditional Selection

Re: Conditional Selection

Re: Conditional Selection

Re: Conditional Selection

Conditional Selection