I have a excel sheet like below which contains values for some division accoridng to age group which I used receive this every month.I have programme where I have to hardcoded the vlaues given from excel sheet to run that programme. Just wanna to automate this so that if we will get excel sheet in future we just need to place in a folder and a sas programme will pick all vlaues fron excel sheet and it in values in variable mentined in another programm. I Just want to do with Array+Macro concepts. Anyone's approch is highly appreciated . Thanks in Advance.
Can we use two dimensional array concepts here ???
Please note :- It is just an example the original excel one contains huge obs with 44 variables.
And what is the desired output for the process to look like?
You mention another program. What kind " it in values in variable mentined in another program" things are you looking to match? You'll likely have to share at least that second program to know what variables might be. And with variable number of input columns I suspect lots of headaches getting this to align properly.
A "macro" may be possible. I'm not sure that arrays are going to help though as arrays are used to process multiple variables in a single row (observation) in a similar manner (usually).