https://communities.sas.com/t5/SAS-Enterprise-Guide/using-array-in-an-imported-fields/m-p/755322#M39158 <P>Without knowing what you are trying to accomplish, you can't get specific suggestions.&nbsp; Here are a few general guidelines:</P> <P>&nbsp;</P> <UL> <LI>Arrays don't care where the data came from, whether it is Excel or any other source.&nbsp; They only care about what is in your SAS data set.</LI> <LI>Anything you can do with arrays you can do without arrays.&nbsp; Arrays don't add any functionality at all, only a short cut (in some cases) for writing the program.</LI> <LI>An array can contain only one type of variable (character or numeric).&nbsp; It looks like you have both (emp_sal would be numeric, and emp_name would be character).&nbsp; So you will need at least two arrays.</LI> </UL> <P>For more guidance, you need to supply more information about your objectives.</P> Tue, 20 Jul 2021 12:17:45 GMT Astounding 2021-07-20T12:17:45Z https://communities.sas.com/t5/SAS-Enterprise-Guide/using-array-in-an-imported-fields/m-p/755293#M39157 <P>if we have imported the data from excel and if we want to use arrays. For example, we are having the fields like emp_id, emp_name, emp_sal in the imported data. How to use arrays?</P> Tue, 20 Jul 2021 10:47:32 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/using-array-in-an-imported-fields/m-p/755293#M39157 sas_it 2021-07-20T10:47:32Z https://communities.sas.com/t5/SAS-Enterprise-Guide/using-array-in-an-imported-fields/m-p/755322#M39158 <P>Without knowing what you are trying to accomplish, you can't get specific suggestions.&nbsp; Here are a few general guidelines:</P> <P>&nbsp;</P> <UL> <LI>Arrays don't care where the data came from, whether it is Excel or any other source.&nbsp; They only care about what is in your SAS data set.</LI> <LI>Anything you can do with arrays you can do without arrays.&nbsp; Arrays don't add any functionality at all, only a short cut (in some cases) for writing the program.</LI> <LI>An array can contain only one type of variable (character or numeric).&nbsp; It looks like you have both (emp_sal would be numeric, and emp_name would be character).&nbsp; So you will need at least two arrays.</LI> </UL> <P>For more guidance, you need to supply more information about your objectives.</P> Tue, 20 Jul 2021 12:17:45 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/using-array-in-an-imported-fields/m-p/755322#M39158 Astounding 2021-07-20T12:17:45Z