BookmarkSubscribeRSS Feed
jc3992
Pyrite | Level 9

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!

 

1 REPLY 1
Kurt_Bremser
Super User

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.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 701 views
  • 0 likes
  • 2 in conversation