Shell Programming and Scripting

1) Depends what "create a variable" means.
2) Depends what "ranking" means.

How does your ranking work?

Why do the values "AAA BBB 10", "AAA BBB 11", and "AAA BBB 12" have a rank of 1?

Why do the values "CCC DDD 16", "CCC DDD 14", and "CCC DDD 15" have a rank of 3?

Why do the values "EEE FFF 20", "EEE FFF 19", and "EEE FFF 19" have a rank of 3?

Either your output is unrelated to your input, or there is a deeper pattern you must explain before we can do anything with it.

Please show relevant input, and related output, and explain how one becomes the other.

There is an input file with the following format

Main Input File

Code:

 24.5625  -81.8125    27.47
 24.5625  -81.7708    27.16
 24.5625  -81.7292    27.49

I need to rank the third column of that input file when compared to 100 other files with the same format. The first 2 columns need to be used as identifiers or data points. So when you search through the other 100 files, you only compare these unique data points. Each value with be ranked based on the original input file.

One of the 100 other files to compare to:

Code:

 24.5625  -81.8125    27.37
 24.5625  -81.7708    27.26
 24.5625  -81.7292    27.29

One of the 100 other files to compare to:

Code:

 24.5625  -81.8125    27.57
 24.5625  -81.7708    27.66
 24.5625  -81.7292    27.19

Expected Output:

Code:

 24.5625  -81.8125    27.47  2  
 24.5625  -81.7708    27.46  1
 24.5625  -81.7292    27.49  3

Ranked how?

You have 27.47, 27.37, and 27.57 as input. How does the output value of 27.47 get chosen? Is it an average, or some other method?

And where does the two come from?

27.47 comes from the original input file which is named YYYYMM.pnt. I was hoping that can be chosen from a variable.

Code:

set month = `date +"%m"`
set year = `date +"%Y"`

$year$month.pnt

All the other files to compare to are the same month in previous years.

201505.pnt
201405.pnt
201305.pnt
etc

The two is the rank of the data value in the original file when compared to the other files.

Compared how? Why is it two, and not three, zero, or nine? Why is the result 27.47 and not 27.37 or 27.57? What criteria makes this decision?

Why isn't 24.5625 -81.7708 27.16 chosen from the original input file?

The ranking is compared based on the 3rd column.

Its two because 27.47 is the second highest value when compared to 27.37 and 27.57.

27.47 comes from the original input file. The original input file needs to be the one that is ranked, thus its values (27.47) are preserved.