SAS_ARRAY_Processing

[Suvendu_Lenka]

Hi All, 

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.

Division	_0_12_Mths	_13_36_Mths	_37_72_Mths	_73_plus_Mths
abc	12	231	34	87
def	55	77	909	44
pqr	99	76	48	99
xyz	11	34	76	94
kml	33	99	66	44
snw	1188	55	44	85
ssl	234	675	890	543

[ballardw]

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).