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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 630 views
  • 0 likes
  • 2 in conversation