Thanks @LinusH. I have already calculated the WOEs for both categorical and continuous variables. But wondering, how to do the variable transformation for further analysis. Even I am not sure on the next step. ... View more

@Darrell_sas Indeed there is no maps library. ... View more

@Astounding Sincere apologies. It was name of students and not 'no.'   Here's what I am looking for :   THe name of the students featured in the top25 ranks of the schools that have occurred more than 3 times (i.e they have come in the top25 ranking for more than 3 times). ... View more

I tried this:   proc sort; by group descending amount; run; data top3(drop=count); set groups; by group descending amount; if first.group then count=0; count+1; if count le 3 then output; run; proc print; run; Also proc rank. Neither worked. ... View more

Thanks @Astounding.   When I run proc freq, it only gives me the name of the students with the frequencies. But does not show me the rank# against those and also I need only the ones that has occurred more than 3 times. i,e in 2011 - 1         2016 -2         2015 - 5    or 2011 - 1    2013 - 1   2014 -1.   or 2011 - 4   could be anything     ... View more

@Reeza The sample you provided did not work. I used the code to divide the value by 100. But nothing happened.   @ballardw   Actual input: data dm.timeseries_1; input international_students; international_students_fract = international_students/100; format international_students_fract fract8.; run;   I run the code above, and view the table. NO changes applied.   Proc contents:   The CONTENTS Procedure Data Set Name DM.TIMESERIES_1 Observations 2603 Member Type DATA Variables 15 Engine V9 Indexes 0 Created Wednesday, April 13, 2005 12:00:00 AM Observation Length 200 Last Modified Wednesday, April 13, 2005 12:00:00 AM Deleted Observations 0 Protection Compressed NO Data Set Type Sorted NO Label Data Representation WINDOWS_32 Encoding wlatin1 Western (Windows) Engine/Host Dependent Information Data Set Page Size 16384 Number of Data Set Pages 33 First Data Page 1 Max Obs per Page 81 Obs in First Data Page 68 Number of Data Set Repairs 0 File Name C:\Documents and Settings\STD\My Documents\Antara\DM\timeseries_1.sas7bdat Release Created 9.0101M3 Host Created XP_PRO Alphabetic List of Variables and Attributes # Variable Type Len Format Informat 7 citations Num 8 BEST12. BEST32. 3 country Char 24 $24. $24. 13 female_male_ratio Char 9 $9. $9. 8 income Char 7 $7. $7. 5 international Char 5 $5. $5. 12 international_students Num 8 COMMA12. COMMA32. 15 international_students_fract Num 8 FRACT8. 10 num_students Char 8 $8. $8. 6 research Num 8 BEST12. BEST32. 11 student_staff_ratio Num 8 BEST12. BEST32. 4 teaching Num 8 BEST12. BEST32. 9 total_score Num 8 BEST12. BEST32. 2 university_name Char 73 $73. $73.   ==============================   I also tried the folowing codes:   1) data _null_;     internationl_Students = '25%';     internationl_Students2 = input(international_Students,FRACT2.);   2)proc datasets lib=dm nolist;       modify timeseries_1;       format international_Students PERCENT2.; run;   3) proc datasets lib=dm nolist;       modify timeseries_1;       format international_Students PERCENTN.; run;        NOne of these worked either.     ... View more