Without knowing what you are trying to accomplish, you can't get specific suggestions. Here are a few general guidelines:
Arrays don't care where the data came from, whether it is Excel or any other source. They only care about what is in your SAS data set.
Anything you can do with arrays you can do without arrays. Arrays don't add any functionality at all, only a short cut (in some cases) for writing the program.
An array can contain only one type of variable (character or numeric). It looks like you have both (emp_sal would be numeric, and emp_name would be character). So you will need at least two arrays.
For more guidance, you need to supply more information about your objectives.
... View more