BookmarkSubscribeRSS Feed
jmhill
Calcite | Level 5

I have a data set with 2 columns (NAME and ENTRIES).

I an trying to get the name only to display as many times as there are entries. I thought using a DO UNTIL or WHILE statement would be the most efficient, but I am not sure.

Sample data and results set expected attached.

 

1 REPLY 1
PGStats
Opal | Level 21

Simple iterative DO will suffice

 

Do i = 1 to entries;

output;

end;

keep name;

PG

CFC_SAS_Communities_400x225.jpg

Call for content now open!

It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.

Submit your proposal →

Creating Custom Steps in SAS Studio

Check out this tutorial series to learn how to build your own steps in SAS Studio.

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