BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
venkatnaveen
Obsidian | Level 7

Data a;
Infile cards;
Input subid name$;
Cards;
101 ashu
102 navee
103 uday
;

Data b;
Infile cards;
Input subid name$;
Cards;
201ashok
202 nav
203 ram
;

Data c;
Infile cards;
Input subid name$;
Cards;
301 rathna
302 vijju
303 abhi
;

i want output like this

101 ashu
201ashok
301 rathna
102 navee
202 nav
302 vijju
103 uday
203 ram
303 abhi

1 ACCEPTED SOLUTION

Accepted Solutions
Loko
Barite | Level 11

Hello,

You don't need first.variable. The following should do it:

data want;

set a;

output;

set b;

output;

set c;

output;

run;

View solution in original post

4 REPLIES 4
Loko
Barite | Level 11

Hello,

You don't need first.variable. The following should do it:

data want;

set a;

output;

set b;

output;

set c;

output;

run;

venkatnaveen
Obsidian | Level 7

Thanks a ton.

CAN U JUST EXPLAIN?

RaviKommuri
Fluorite | Level 6

The SET statement reads the current observation from the dataset.

The OUTPUT statement tells SAS to write the current observation to a SAS data set immediately, not at the end of the DATA step.

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 1423 views
  • 3 likes
  • 3 in conversation