topic Re: Base SAS Scenario in All Things Community

Base SAS Scenario

Sharad_Pujari — Fri, 28 Jul 2017 14:16:05 GMT

i have dataset like

fname lname

john kilber

and i want output like this

fname lname

john kilber

kilber

how to do this please help me out...

RW9 — Fri, 28 Jul 2017 14:39:39 GMT

Do loops?

data want (drop=i);
  set have;
  do i=1 to 5;
    output;
  end;
run;

ballardw — Fri, 28 Jul 2017 15:08:39 GMT

Is there some logic that the fifth version does not have the fname? is it always to create exactly 5 records?

Sharad_Pujari — Fri, 28 Jul 2017 17:10:30 GMT

no suppose you are working in comany and client want output as i shown above

Astounding — Fri, 28 Jul 2017 17:12:04 GMT

How about:

data want;

set have;

output;

fname=' ';

output;

run;

Sharad_Pujari — Fri, 28 Jul 2017 17:12:41 GMT

yeah it will work but it will show both fname and lname record at same no of observation but i want fname 4 times and lname 5 times

RW9 — Fri, 28 Jul 2017 19:47:21 GMT

Really not the most difficuly update:

data want (drop=i);
  set have;
  do i=1 to 5;
    if i=5 then fname="";
    output;
  end;
run;

Sharad_Pujari — Mon, 31 Jul 2017 08:24:49 GMT

thanks