proc sql;    create table test2 as select           segment, sum(feb) as sum_feb into:seg,          from test group by segment ;   /* 1 means segment by now it is more readable */ quit;   then you can use &seg to get the sum of FEB per SEGment;   I haven't check it, so better run and check. ... View more

ou may find some hints in next link:   http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000220968.htm   you can underline titles on HTML, PDF and probably some other ODS outputs.   otherwise you can add TITLE2 '  ____________ '; ... View more

The input line you demostarted seems to be without a deleimiter. Maybe the variables are fixed length. If it is - you need know at what position each variable starts. ... View more

The rectangle means it is a non printable character and is not in your font set of characters. I would start with searching the origin of data because removing characters means you change the data.   On your capture I saw 0 to 2 rectangles and maybe there are more, even in middle of a variable;  Those can be different characters, not neccessary the same one;   in case you recognize specific hexa characters you can replace then to any character(s) you chose using TRANSLATE function:       ne_var = translate(old_var,  new_chars, old_chars); new_chars and old_chars should fit by order.           ... View more

you can remove 1st character by: var = substr(var,2);   Do you know the origin of your data? how did you get the variable with that extra character ? ... View more