Hello SAS Community,   I am wondering if there is any function, similar to Min and Max function, to identify the second or third highest or lowest value across the column. example: We are given student_Ids with average monthly results. We have to calculate highest, second highest, third highest avg. monthly score. Something similar to the following dataset:   Student_ID Name Class Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Max Min Second_Highest Third_highest A-1101 John 8 34 33 28 27 27 28 38 50 42 44 24 20         A-1102 Peter 7 36 35 30 29 29 30 40 52 44 46 26 22         A-1103 Aslam 8 38 37 32 31 31 32 42 54 46 48 28 24         A-1104 Neeraj 9 40 39 34 33 33 34 44 56 48 50 30 26         A-1105 Kulsoom 7 42 41 36 35 35 36 46 58 50 52 32 28         ... View more

Hi,   I am struggling to pass a numeric value through a sas macro.  Program1 generates two macros, prodname and prodcost. Program2 filters the data by using the character value that we have stored through program1- this program is working fine. Program3 is intended to filter the data by using the numeric value that we have stores through program2- this program is not working. details of the programs are provided below.   Program1   proc sql;  select prodname, prodcost  into: prodname, : prodcost  from procsql.products; quit; %put &prodname and &prodcost;   When I want to use the macro (prodname) that recalls the character value, works perfectly fine. the following program runs perfectly fine:   Program2   proc sql;  select prodname, prodcost  from procsql.products  where prodname = "&prodname"; quit;     Program3   However, when I use the same program to recall the macro that holds the numeric values, it throws me an error.   proc sql;  select prodname, prodcost  from procsql.products  where prodcost > &prodcost; quit;   the log shows the following error:   ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, a numeric constant, a datetime constant, a missing value, BTRIM, INPUT, PUT, SUBSTRING, USER.   Any help would be appreciated.             ... View more

Please see below the data (from a dat file) I am trying to read. I know that I need to use @@ to read the file but for some reason I am unable to do this through my program. please note that   Since the first variable (Name) has two words separated by an space, I used column format to read this variable. However, the way the data is, it is causing other issues.  When I don't put double trailing, I get just the first four rows on the left and when I apply @@ the program would run indefinitely .     Data Robin                  S    28   41 Bald Eagle  R 102 244 Barn Owl    R 50 110 Osprey                R   66 180 Cardinal      S    23   31 Goldfinch   S  11   19 Golden Eagle      R 100 234 Crow           S    53 100 Magpie      S  60    90 Elf Owl                R   15   27 Condor        R 140  300     Program data bird; infile '/folders/myfolders/MyRawData/Birds.dat'; input Name $1-13 Jungle $ Min Max @@; run;     ... View more