Hi all, I have a question. I have a data set like below. This is just an example what I have but I have a large sample. The first group has 150,000 people and the second group has 15,000 people. I tested the variance of score of two groups with Levene test and found out that the variance of scores of two groups are different. I would like to select two samples of groups where variances of scores are similar. Also, with that sample I would like to keep the sample ratios similar. What I mean by that for example the first group will have 12000 and the other one have 1200, the sample size is different than the original but the ratio of samples are similar. The point is that I  have similar sample size ratio. I have no idea how can I do that. Any help is appreciated. student_id group score 110 1 430 111 1 622 112 2 530 113 2 532 114 1 410 ... View more

Hi all, I have a graph as shown below. I want to add reference lines' labels  for each line but it is not printed and in the log I get this message ' CURVELABEL='1' is invalid. The option value cannot be a string when a column of reference lines is plotted. The label will not be drawn."   Here is my code. Could you help me what I am missing? %macro try3(m); %do i=1 %to 12; proc sgplot data=all_per_grade_w&i.; where group in ("2" , "4"); /* restrict to two groups */ density writing_scale_score/ type=normal group=group; refline scale_score_n /LABEL= ('1' '2' '3' '4' '5' '6') lineattrs=(color=red) axis=x discreteoffset=0.5 axis=x ; ; xaxis values =(100 to 600 by 50); ; yaxis display=(noline noticks nolabel) grid; run; %end; run; %mend; %try3;                 ... View more

Hi all, I hope I can explain well what I need. I have a data set as provided below. grade ss group 1 130 2 6 124 4 1 156 2 3 234 1 2 256 4 12 300 2 ... I want to draw an overlayed distribution with reference lines for groups 2 and 4 per 12 grades. I can use that code: proc sgplot data=sample; where group in ("2" , "4"); /* restrict to two groups */ density ss/ type=normal group=group; /* overlay density estimates */ refline 116 / LABEL="ref1" lineattrs=(color=red) axis=x discreteoffset=0.5; refline 223 / LABEL="ref2" lineattrs=(color=red) axis=x discreteoffset=0.5;   But the problem is that I have 12 grades and each grade's reference lines are different. For example for grade 1 ref1=116, ref2=223 and for grade2 ref1=118, ref2=245. I have another data set as below that has those reference lines. As you see that the reference line is the first score of each ref variable per grade.  grade score ref 1 116 1 1 118 1 1 223 2 1 224 2 1 245 2 2 118 1  2 131 1  2 245 2 2 246 2   So, it there a way to do this with a macro? Thank you,   ... View more

Hi all, I have about 48 data sets named  pfreq_and_pl_g1_gr1 pfreq_and_pl_g1_gr2 pfreq_and_pl_g1_gr3 pfreq_and_pl_g1_gr4 pfreq_and_pl_g2_gr1 pfreq_and_pl_g2_gr2 ... "g" goes up to 12. and "gr" goes up to 4.   I want to merge them based on the "g". For example one merged data set will include (pfreq_and_pl_g1_gr1, pfreq_and_pl_g1_gr2, pfreq_and_pl_g1_gr3, pfreq_and_pl_g1_gr4), the other data set will include (pfreq_and_pl_g2_gr1, pfreq_and_pl_g2_gr2, pfreq_and_pl_g2_gr3, pfreq_and_pl_g2_gr4).   Merging will be based on the data set's name, not a variable. How can I do that?   Thank you ... View more

Hi All, I have a data set as below: I want to compare the histograms of the scores of two different groups with all possible combinations. For example, comparison of  scores for groups ts=A and tc=B; comparison of  scores for groups ts=B and tc=B; comparison of  scores for  groups ts=B and tc=A; comparison of  scores for groups ts=A and tc=A;   So, there will be 4 different overlaying histograms. Could you help to draw overlaying histograms of these groups' scores?   Thank you,     score ts tc matching 180 A B 0 200 B B 1 360 A B 0 420 A A 1 500 B A 0 234 B B 1 461 B A 0 ... View more

Hi all, Thanks to @ballardw  and @PeterClemmensen for helpful vlookup sql code that you guys provided in one of my former questions.  I have a new question. Let me explain my data first. Data 1 raw_score_s scale_score_s tier domain grade 0 118 A Speaking 1 1 118 A Speaking 1 2 118 A Speaking 1 3 118 A Speaking 1   Data2 raw_score_a scale_score_a tier domain grade 2 118 A Speaking 1 1 118 A Speaking 1 0 118 A Speaking 1 3 118 A Speaking 1   want raw_score_s scale_score_s tier domain grade raw_score_a 0 118 A Speaking 1 0 1 118 A Speaking 1 1 2 118 A Speaking 1 2 3 118 A Speaking 1 3   I want to use vlookup function to pull data2's raw_score_a variable. However, since there are variables that have exactly the same values, the function doesn't match them correctly. I tried to assign ids to both data sets and then match them based on grade, tier, domain, scale score, and id but it is not as easy as I thought. Or any other method?  Could you help me with that? Than you,   ... View more