topic Re: Reading in delimited in-stream data in SAS Programming

Reading in delimited in-stream data

kateb409 — Thu, 10 Dec 2020 15:17:59 GMT

Hi there!

I am working in SAS On Demand version 9.4_m6 on Linux X64 operating system.

I need help reading in some delimited in-stream data into SAS. This is the question on my homework and the provided in-stream data:

I am running into the issue of capturing the full length of the state name 'Washington' in my results. I have tried using the dsd, missover, and truncover options and it did not help. This is the code I used:

data states;
infile datalines;
input state :$10.
population :comma10. ;
datalines;
Washington 7,170,351
Ohio 11,613,423
Florida 21,299,325
;

proc print data = states;
run;

And this is the result I get: the 'n' is cut off from 'Washington'

Please let me know if anyone has had this issue and knows how to fix it. Thanks!

-Kate

Re: Reading in delimited in-stream data

novinosrin — Wed, 23 Sep 2020 02:26:05 GMT

Hi , Can you try expanding the width of the informat from 10 to something like 12?

input state :$12.

Re: Reading in delimited in-stream data

jimbarbour — Wed, 23 Sep 2020 02:34:57 GMT

That's odd. The code works perfectly fine for me. I'm on Windows, so maybe there's some difference there.

Try left justifying your data lines.

Data lines should always be hard up to the left margin. It shouldn't matter with a : modifier with a $10 informat, but let's try it. If that doesn't work, change your definition to $11. Again, it shouldn't matter, but if it's lopping off a character, let's give it more room.

Jim

Re: Reading in delimited in-stream data

kateb409 — Wed, 23 Sep 2020 03:13:09 GMT

Hi there,

I actually did try using :$11 and that works, however, it does not make sense to me because the word 'Washington' only has 10 characters in it. I was wondering if there was another reason this syntax was not working for me.

-Kate

Re: Reading in delimited in-stream data

Tom — Wed, 23 Sep 2020 03:44:36 GMT

The key thing here is something I can tell from your photographs that you don't actually mention in your problem description. You are using SAS/Studio to edit and submit the code.

There is nothing seriously wrong with the syntax of your data step (you don't need to the INFILE statement, you don't want to have leading spaces on your lines of data). So the issue is the content of your datalines. When you have lines of code with TAB characters in them using SAS Display Manager the tabs are not submitted as part of the program. But when you use SAS/Studio they are kept in the datalines and so will cause issues, especially when trying to read numeric values.

There are a number of ways to fix this. The best is to make sure not to include actual tabs in your programs. There are settings in the SAS editors to insert spaces when when you hit the tab key on your keyboard.

You could also use the EXPANDTABS option on an INFILE statement.

Re: Reading in delimited in-stream data

kateb409 — Wed, 23 Sep 2020 14:27:20 GMT

Hey Tom,

Thanks so much for this! Both options worked. I knew it would end up being something extremely simple.

I apologize for not mentioning that I am using SAS Studio to edit and submit data. I will keep that in mind for next time.

-Kate