Help using Base SAS procedures

proc sql Percentage -**resolved**

Reply
Contributor
Posts: 22

proc sql Percentage -**resolved**

Cannot find a delete post feature. so please ignore as problem has been resolved!!

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!!

proc sql;
create table table4 as
select *,
(N_tot / sum(N_tot) * 100) as N_tot_Pct
from table4a where circdist ne 0;
quit;


numbers in sas are outtputted as

0.6 .
0.3 .
1.5 .

or
0.6 --
0.3 --
1.5 --

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
Ask a Question
Discussion stats
  • 0 replies
  • 101 views
  • 0 likes
  • 1 in conversation