topic Re: Strange symbol attached to the end of a column in SAS Procedures

Strange symbol attached to the end of a column

KevinC_ — Wed, 10 Apr 2013 19:29:29 GMT

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

;

run;

Re: Strange symbol attached to the end of a column

art297 — Wed, 10 Apr 2013 19:42:26 GMT

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.

Re: Strange symbol attached to the end of a column

KevinC_ — Wed, 10 Apr 2013 20:02:12 GMT

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

;

run;

Re: Strange symbol attached to the end of a column

KevinC_ — Wed, 10 Apr 2013 20:25:06 GMT

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;

Re: Strange symbol attached to the end of a column

art297 — Wed, 10 Apr 2013 21:24:35 GMT

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

Re: Strange symbol attached to the end of a column

jaredp — Fri, 12 Apr 2013 16:38:47 GMT

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