topic Re: excel to dataset in SAS Procedures https://communities.sas.com/t5/SAS-Procedures/excel-to-dataset/m-p/172018#M44356 <HTML><HEAD></HEAD><BODY><P>try to save this excel file as CSV file .</P></BODY></HTML> Sat, 15 Nov 2014 09:02:40 GMT Ksharp 2014-11-15T09:02:40Z excel to dataset https://communities.sas.com/t5/SAS-Procedures/excel-to-dataset/m-p/172017#M44355 <HTML><HEAD></HEAD><BODY><P>I have an excel file and I am planning to convert them SAS dataset using proc import..</P><P></P><P>some of the columns in Excel has special characters like $%@ etc.... As a result I getting the following warning..........</P><P></P><P>'</P><P>some character data was lost during transcoding </P><P>'</P><P></P><P>Any suggestions on this....</P><P></P><P>Thanks</P></BODY></HTML> Fri, 14 Nov 2014 15:52:45 GMT https://communities.sas.com/t5/SAS-Procedures/excel-to-dataset/m-p/172017#M44355 rakeshvvv 2014-11-14T15:52:45Z Re: excel to dataset https://communities.sas.com/t5/SAS-Procedures/excel-to-dataset/m-p/172018#M44356 <HTML><HEAD></HEAD><BODY><P>try to save this excel file as CSV file .</P></BODY></HTML> Sat, 15 Nov 2014 09:02:40 GMT https://communities.sas.com/t5/SAS-Procedures/excel-to-dataset/m-p/172018#M44356 Ksharp 2014-11-15T09:02:40Z