topic Re: Replace this special character automatically in SAS Programming

Replace this special character automatically

SASdevAnneMarie — Tue, 16 Nov 2021 09:14:09 GMT

Hello Experts,

My SAS program doesn't work, because I have a flash "->" instead of point "." before the CRLF:

Do you know, pease, how to replace this special character automatically via Notepad++ ?

Thank you very much !

Re: Replace this special character automatically

Ksharp — Tue, 16 Nov 2021 12:09:38 GMT

Just copy this character into REPLACE dialogue window ?

Re: Replace this special character automatically

Tom — Tue, 16 Nov 2021 15:53:48 GMT

Is that character in the source code for your program? Or some data file your program is reading?

Either way try looking at the file using SAS to see what actual hex code it is that is there before the end of line.

Perhaps by running a program like this to get the last byte before the end of line for each line in a file.

data lastch ;
  infile 'myfile.txt' length=linelength truncover;
  row+1;
  input @;
  if linelength > 0;
  input @linelength char $char1. ;
  hex=put(char,$hex2.);
run;

proc freq data=lastch;
  tables hex*char / list;
run;