BookmarkSubscribeRSS Feed
BrahmanandaRao
Lapis Lazuli | Level 10

Hi  Good Evening guys,

 

I want to split each observation as a one dataset

using macro do loop 

here is the dataset.

ex:data dsn

set sashelp.class;

run;

 

2 REPLIES 2
PeterClemmensen
Tourmaline | Level 20

This question has been asked a lot lately in here. Is this an interview question?

 

The good answer to the question is: Don't do that. There is no reason to split a data set into data sets containing 1 observation each.

ballardw
Super User

Why??? What can you do better with the multiple sets that cannot be accomplished with a single data set?

 

And why are you specifying use of a Macro do loop?

 

Where do the names of your resulting data sets come from? Or do you know what you want to name them?

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 →

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
  • 2 replies
  • 1757 views
  • 5 likes
  • 3 in conversation