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.