Strange symbol attached to the end of a column

[KevinC_]

Hello Everyone,

I have a simple data step that reads in a dataline.  However, the output has a weird symbol at the end of every row.  It looks like a very narrow and tall rectangle.  This causes problems when I try to merge this dataset with another one.  Does anyone know how to get rid of this weird symbol?   My code and the output dataset are listed below.  Not sure if this makes a difference - I run this code directly from Unix.

Thank you for any input anyone may have

data inv_group;

input inv_group $13.;

datalines;

ASC

FHA

FHLMC

FNMA

HCS

PRIVATE

VA

WO

;

run;

[art297]

Kevin,

Was to code possibly written on a PC?  One can't tell from the picture you attached, but it is likely a CR or LF character.  See if adding an 'infile cards termstr=CRLF;' statement gets rid of the extra character.

[KevinC_]

Thank you, Arthur.  The code was entered from PC (PC SAS).

Where should I fit your suggestions into my code?

This is the code i have and its syntax is not correct.  Thank you again!

data inv_list;

infile cards termstr=CRLF;

datalines;

ASC

FHA

FHLMC

FNMA

HCS

PRIVATE

VA

WO

;

run;

[KevinC_ · Accepted solution]

To everyone who cares to know,

I tried this code and it worked:

data inv_list1;

set inv_list;

inv_g = compress(inv_group,compress(lowcase(inv_group),'qwertyuiopasdfghjklzxcvbnm1234567890')));

drop inv_group;

rename inv_g = inv_group;

run;

[jaredp]

I'm curious how "the code that worked" has been set as the Correct Answer to your original question?

[art297]

termstr was added to the infile statement as of SAS 9.2  Which version are you using?