topic Delimited Data Entry in SAS Studio

Delimited Data Entry

marianhabesland — Thu, 21 Sep 2017 16:28:58 GMT

I am trying to use deminited raw data to create a table with two variables with their populations. I wrote this code:

data WORK.Illus;
infile datalines delimiter= " ";

input State :$10.

Population :comma10.;

datalines;

Washington 7,170,351

Ohio 11,613,423

;

I do not get any error statements, but my table looks like this. What do I do to get the entire state name and population values in the table?

Re: Delimited Data Entry

Reeza — Thu, 21 Sep 2017 16:40:23 GMT

THis works for me.

I find it easier to set the INFORMAT first.

data WORK.Illus;
	infile datalines delimiter=" ";
	informat state $20. population comma20.;
	format population comma20.;
	input State Population;
	datalines;
Washington 7,170,351
Ohio 11,613,423
;
run;

Re: Delimited Data Entry

ballardw — Thu, 21 Sep 2017 16:41:04 GMT

Try either widening the column for state or use Proc Print. I suspect the table viewer just isn't making the column wide enough to see the whole state name.

If you mean that you also want to display the population with commas then you need to explicitly assign a comma format for display.

Format population comma11.;

Since formats only control display not values SAS will unless otherwise instructed default to a BEST format to display numeric values.

Note that you may need a different delimiter to deal with New York, New Mexico, North and South Dakota, North and South Carolina if they are in your future data to read this way.

Re: Delimited Data Entry

BD1 — Thu, 21 Sep 2017 16:45:44 GMT

Have you tried dragging the state column width when you view the output table to see the whole state name?

For the values do you mean how do you get the commas appearing in your output table, just like your input datalines?

try adding the following line under your input statement:

format Population comma10.;

Re: Delimited Data Entry

marianhabesland — Thu, 21 Sep 2017 16:55:34 GMT

Thanks, I didn't realize it was just the formatting of the table that did not let me see the whole variable. I thought it might be cutting it off for a reason. And yes, I wanted to display the commas, so that helps.