If not using trailing sign

Reply
Frequent Contributor
Posts: 112

If not using trailing sign

Hello everyone,

 

there was a question in my assignment, and after I checked the answer,

I still did not understand, so I post it here.

The data set is as below:

Yellowstone           ID/MT/WY 1872    4,065,493
Everglades            FL 1934          1,398,800
Yosemite              CA 1864            760,917
Great Smoky Mountains NC/TN 1926         520,269
Wolf Trap Farm        VA 1966                130

And the question was:

Figure out how to read in the data without using the @40
pointer (or any pointer). Describe what you did, and why, and submit your code
 
The  answer was to use COMMA9. for Acreage (the last column)
 
so the answer was :
Input National Park $ State $ Year Acreage;
Informat Acreage COMMA9.;
run;
There was also another question that,
whether there be any difference between placing the "Informat" before or after the "Input" statement?
I think there would be no difference,
am I correct?
 
Thank you!

 

Super User
Posts: 10,280

Re: If not using trailing sign

[ Edited ]

Your code as posted won't work to your satisfaction, as national_park has blanks in some rows.

See my slight correction:

data want;
Input National_Park $22. State $ Year Acreage;
Informat Acreage COMMA9.;
cards;
Yellowstone           ID/MT/WY 1872    4,065,493
Everglades            FL 1934          1,398,800
Yosemite              CA 1864            760,917
Great Smoky Mountains NC/TN 1926         520,269
Wolf Trap Farm        VA 1966                130
;
run;

As for your second question: just try it.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
How to convert datasets to data steps
How to post code
Ask a Question
Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation