topic Re: Need help in SAS Programming

Need help

Praveenit0808 — Sun, 07 May 2017 09:46:12 GMT

Can anyone help how to move values from one observation to another?

aa 11 101
bb 14 201
cc 13 303
dd 12 404
dd 17 505
;
run;
O/P like this
aa 12 101
aa 17 505
bb 14 201
cc 11 303
dd 13 404
;
run;

Can it be possible?

Re: Need help

ChrisBrooks — Sun, 07 May 2017 10:10:18 GMT

Hi Praveen

I think you'll have to give us some more detail about the logic you want to use in order to get an answer to this

Re: Need help

PeterClemmensen — Sun, 07 May 2017 14:26:31 GMT

I dont see the logic here, please provide more information.

Re: Need help

art297 — Sun, 07 May 2017 15:12:48 GMT

Is it possible? Almost anything is possible.

Do I know what you're trying to do? No!

Can one write code that produces what you want? Of course!

data have;
  input x $ y z;
  cards;
aa 11 101
bb 14 201
cc 13 303
dd 12 404
dd 17 505
;

data x(keep=x) y(keep=y y1) z(keep=z z1);
  set have;
  select (_n_);
    when (1) do;
      y1=4;
      z1=1;
    end;
    when (2) do;
      y1=3;
      z1=3;
    end;
    when (3) do;
      y1=5;
      z1=4;
    end;
    when (4) do;
      x='aa';
      y1=1;
      z1=5;
    end;
    otherwise do;
      y1=2;
      z1=2;
    end;
  end;
run;

proc sort data=x;
  by x;
run;

proc sort data=y;
  by y1;
run;

proc sort data=z;
  by z1;
run;

data want (keep=x y z);
  set x;
  set y;
  set z;
run;

Art, CEO, AnalystFinder.com

Re: Need help

novinosrin — Sun, 07 May 2017 15:47:46 GMT

Is it possible? Almost anything is possible.

Do I know what you're trying to do? No!

Can one write code that produces what you want? Of course!

@art297 I love your sense of humor. I hope you are having a great weekend!

Re: Need help

mkeintz — Sun, 07 May 2017 19:56:13 GMT

This is an excellent response, and should be marked as the solution.

it's so good, we don't need to know what the problem is. ... and we don't.

Re: Need help

Praveenit0808 — Mon, 08 May 2017 09:33:55 GMT

Yes thank so you much for your prompt response ....I'll definitely implement those steps in my program ...

Re: Need help

Praveenit0808 — Tue, 09 May 2017 11:10:29 GMT

Thank you so much for helping me. However what exactly I need is. Here is
the problem:

Input name $ status ;
Cards;
Aa active
Aa active
Aa active
Aa active
Aa active
Bb deactivated
Bb deactivated
Bb deactivated
Dd deactivated
Dd deactivated
Ee active
Ee active
Ee active
Cc active
Cc active
;
Run;

O/p should be like this

Aa active
Aa active
Aa active
Aa active
Aa active
Cc active
Cc active
Cc active
Ee active
Ee active
Ee active
Ee active
Ee active
Cc active
Cc active

How do we do that?

##- Please type your reply above this line. Simple formatting, no
attachments. -##