topic Importing an xls file into SAS EG v4.1 in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/Importing-an-xls-file-into-SAS-EG-v4-1/m-p/81216#M23419 <HTML><HEAD></HEAD><BODY><P>Dear SAS users.</P><P></P><P>I'm trying to import the attached excel file into my SAS EG hoping to automate some reporting.</P><P>I am having trouble doing so though as I haven't dealt much with the proc import.</P><P>Whatever I try returns errors and I don't fully understand the parameters either.</P><P></P><P><SPAN style="text-decoration: underline;">To specify the formats of the variables I want to give the variables:</SPAN></P><P><STRONG>First variable - String</STRONG></P><P><STRONG>Identification Number - numeric format best12.</STRONG></P><P><STRONG>Incentive - dollar15.2</STRONG></P><P></P><P>and I do not want to keep the "code" variable as I do not need it.</P><P></P><P>Many thanks</P></BODY></HTML> Mon, 26 Nov 2012 22:24:38 GMT willy0625 2012-11-26T22:24:38Z Importing an xls file into SAS EG v4.1 https://communities.sas.com/t5/SAS-Procedures/Importing-an-xls-file-into-SAS-EG-v4-1/m-p/81216#M23419 <HTML><HEAD></HEAD><BODY><P>Dear SAS users.</P><P></P><P>I'm trying to import the attached excel file into my SAS EG hoping to automate some reporting.</P><P>I am having trouble doing so though as I haven't dealt much with the proc import.</P><P>Whatever I try returns errors and I don't fully understand the parameters either.</P><P></P><P><SPAN style="text-decoration: underline;">To specify the formats of the variables I want to give the variables:</SPAN></P><P><STRONG>First variable - String</STRONG></P><P><STRONG>Identification Number - numeric format best12.</STRONG></P><P><STRONG>Incentive - dollar15.2</STRONG></P><P></P><P>and I do not want to keep the "code" variable as I do not need it.</P><P></P><P>Many thanks</P></BODY></HTML> Mon, 26 Nov 2012 22:24:38 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-an-xls-file-into-SAS-EG-v4-1/m-p/81216#M23419 willy0625 2012-11-26T22:24:38Z Re: Importing an xls file into SAS EG v4.1 https://communities.sas.com/t5/SAS-Procedures/Importing-an-xls-file-into-SAS-EG-v4-1/m-p/81217#M23420 <HTML><HEAD></HEAD><BODY><P>What errors are you getting?&nbsp; Can you post the log?</P></BODY></HTML> Tue, 27 Nov 2012 00:45:44 GMT https://communities.sas.com/t5/SAS-Procedures/Importing-an-xls-file-into-SAS-EG-v4-1/m-p/81217#M23420 art297 2012-11-27T00:45:44Z