topic Re: format issue in SAS Programming

format issue

HeatherNewton — Tue, 03 May 2022 04:46:06 GMT

I have a file called pmam.static.txt.

normally it was read into sas program with the following lines:

INFILE "&G_IFC_RAW_PENDING_PATH./pmam.static.txt" REFM=N;

if I read it in note pad, it is showing as strange symbols.. which look like this picture showing above and attached...

now my questions is how can I see the content ?

how can I read this in sas? how can I see the content in sas... Could the file actually be a sas data set??

please help thanks.

Re: format issue

Kurt_Bremser — Tue, 03 May 2022 05:07:46 GMT

I suggest you ask the person from whom the file is coming. They should know.

Re: format issue

Tom — Tue, 03 May 2022 05:10:54 GMT

Where did you get the file?

Why do you think it is a text file? What text did you expect to see in it?

Try looking at the file and see what bytes are actually there. The easiest way is to use the LIST statement in a data step.

This step will dump the first 500 bytes to the SAS log for you to look at.

data _null_;
   INFILE "&G_IFC_RAW_PENDING_PATH./pmam.static.txt" recfm=f lrecl=100 obs=5;
  input;
  list;
run;

Since you have a lot of @ characters which hex code of 40 perhaps the text is actually in EBCDIC instead of ASCII. 40 is a space in EBCDIC. Try reading it with $EBCDIC informat and see if it looks more like text.

This will try to read the first 100 bytes from each of the first 5 lines and create a SAS dataset.

data test;
   INFILE "&G_IFC_RAW_PENDING_PATH./pmam.static.txt" obs=5 truncover;
   line+1;
   input text $ebcdic100.;
run;

Re: format issue

HeatherNewton — Tue, 03 May 2022 06:21:21 GMT

is the code in the pic above helping to show what format and how I can read it?

Re: format issue

HeatherNewton — Tue, 03 May 2022 06:33:58 GMT

seem it says it extract IBM EBCDIC File PMAM STATIC into SAS dataset

Re: format issue

HeatherNewton — Tue, 03 May 2022 07:13:23 GMT

data test;
   INFILE "&G_IFC_RAW_PENDING_PATH./pmam.static.txt" obs=5 truncover;
   line+1;
   input text $ebcdic100.;
run;

so if I want to see the first 20 row fully , how do I write? like below?

data test;

INFILE "&G_IFC_RAW_PENDING_PATH./pmam.static.txt" obs=20 truncover;

line+1;

input text $ebcdic100.;

run;

do I need to increase the 100 byte to a higher number?

please advise, thanks.

Re: format issue

Ksharp — Tue, 03 May 2022 09:52:51 GMT

Check the following three options .

data test;
   INFILE "&G_IFC_RAW_PENDING_PATH./pmam.static.txt" truncover encoding='EDBIC'  recfm=s370  termstr=nl   ;

Re: format issue

Tom — Tue, 03 May 2022 13:58:28 GMT

Did the code posted the photograph of not work?

What errors did you get?

Re: format issue

SASKiwi — Tue, 03 May 2022 20:11:22 GMT

Why not just run the program you have to read the data file and then review your SAS log? This will indicate whether you have any processing problems or not.