BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Cathy
Obsidian | Level 7
Thanks a lot for your help and time. I appreciate it.
Astounding
PROC Star

The way I interpret this, you would need two CITY values (one for the smallest GDP, one for the largest).  Here's an approach:

 

proc sort data=have;

by region gdp;

run;

 

data want;

set have;

by region;

if first.region then do;

   type='Smallest';

   output;

end;

if last.region then do;

   type='Largest';

   output;

end;

run;

 

 

Cathy
Obsidian | Level 7
Thanks a lot for your help and time again. I greatly appreciate it.
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
  • 17 replies
  • 4034 views
  • 12 likes
  • 6 in conversation