Hi:
I see that you have a LOT of nested variables under year. So you're right, you would have to hardcode the year value. If this was my report to do, I would be very tempted to flatten or pre-summarize the dataset and then build the URL so that absolute column numbers were not involved. Also remember, that even NOPRINT variables will get a column number, so you have to include them in your coding.
Also, do keep in mind when you use ODS, that some options, such as LS, PS, WIDTH, SPACING, FLOW are LISTING only options that are are simply ignored by ODS HTML, RTF and PDF. You don't indicate what your destiantion of choice is (no ODS statements) but given that you're coding a URL, I suspect it is ODS HTML.
Good luck!
cynthia
... View more