My SAS Tutorials

Wednesday 2 October 2013

SAS INTERVIEWS CONCEPTUAL QUESTIONS XV

SWAP THE VALUES OF VARIABLES A AND B:

WE HAVE SAS DATA SET ONE;

DATA ONE;
X=5;
Y=3;
RUN;

CREATE ANOTHER SAS DATA SET TWO BY READING SAS DATA SET ONE:

   TWO
  ----------
  X     Y
  3      5


Now prepare your Base SAS and Advance SAS Certification Exams with Online Mock tests:  http://exam.sankhyana.com


For training related info kindly mail us at info@sankhyana.com
www.sankhyana.com

7 comments:

  1. data two;
    length X 3.;
    set one
    (rename=(X=Y Y=X));
    RUN;
    proc print data=two;
    run;
    IS IT RIGHT??

    ReplyDelete
  2. data two(drop=x y rename=(x1=X y1=Y) );
    set one;
    by x y;
    if first.x then x1=3 ;
    if first.y then y1=5;
    run;
    proc print data=two;
    run;

    ReplyDelete
  3. data two;
    set one;
    temp=x;
    x=y;
    y=temp;
    drop temp;
    run;

    ReplyDelete
  4. data two(rename=(a=y b=x));
    set one(rename= (x=a y=b));
    run;

    ReplyDelete
  5. data two;
    set one;
    a=x;
    b=y;
    x=b;
    y=a;
    drop a b;
    put _all_;
    run;

    ReplyDelete
  6. data two;
    set one;
    X = X+Y;
    Y= X-Y;
    X = X - Y;
    RUN;

    ReplyDelete
  7. data two(drop=X1 Y1);
    set one;
    X1=X;
    Y1=Y;
    X=Y1;
    Y=X1;
    run;
    proc print data=two noobs;
    run;

    ReplyDelete