https://communities.sas.com/t5/SAS-Procedures/proc-sql-Percentage-resolved/m-p/73141#M21221 Cannot find a delete post feature. so please ignore as problem has been resolved!!<BR /> <BR /> I am creating a percentage via sql. I am transferring it to Excel through a DDE Link. I have successfully done this for a few tables. the problem is for 1 table I keep getting trailing "--" or " ." in the entries. I cannot determine why!!<BR /> <BR /> proc sql;<BR /> create table table4 as<BR /> select *, <BR /> (N_tot / sum(N_tot) * 100) as N_tot_Pct <BR /> from table4a where circdist ne 0;<BR /> quit;<BR /> <BR /> <BR /> numbers in sas are outtputted as <BR /> <BR /> 0.6 . <BR /> 0.3 . <BR /> 1.5 . <BR /> <BR /> or <BR /> 0.6 -- <BR /> 0.3 -- <BR /> 1.5 -- <BR /> <BR /> I removed any formatting options from both the sas data set and excel set to ensure that this was not the issue Message was edited by: Hart Fri, 02 Apr 2010 13:16:54 GMT Hart 2010-04-02T13:16:54Z https://communities.sas.com/t5/SAS-Procedures/proc-sql-Percentage-resolved/m-p/73141#M21221 Cannot find a delete post feature. so please ignore as problem has been resolved!!<BR /> <BR /> I am creating a percentage via sql. I am transferring it to Excel through a DDE Link. I have successfully done this for a few tables. the problem is for 1 table I keep getting trailing "--" or " ." in the entries. I cannot determine why!!<BR /> <BR /> proc sql;<BR /> create table table4 as<BR /> select *, <BR /> (N_tot / sum(N_tot) * 100) as N_tot_Pct <BR /> from table4a where circdist ne 0;<BR /> quit;<BR /> <BR /> <BR /> numbers in sas are outtputted as <BR /> <BR /> 0.6 . <BR /> 0.3 . <BR /> 1.5 . <BR /> <BR /> or <BR /> 0.6 -- <BR /> 0.3 -- <BR /> 1.5 -- <BR /> <BR /> I removed any formatting options from both the sas data set and excel set to ensure that this was not the issue Message was edited by: Hart Fri, 02 Apr 2010 13:16:54 GMT https://communities.sas.com/t5/SAS-Procedures/proc-sql-Percentage-resolved/m-p/73141#M21221 Hart 2010-04-02T13:16:54Z