Delimited Data Entry

[marianhabesland]

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?

[Reeza]

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;

[ballardw]

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.

[BD1 · Accepted solution]

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.;

[marianhabesland]

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.