This post is dedicated to the lovers of SAS programming language. Flaunt your knowledge in your peer group with the following SAS program ðŸ˜Š It's one of the stupidest and coolest way to make simple things complex. The idea is to show off your creativity and solve easy problems with complicated ways to learn some cool tricks which can be used to solve future real complex problems.

Be Creative with SAS |

*Run the following program and see what i mean -*DATA A(KEEP=WISH);

LENGTH WISH $15 F1 $5 F2 $9;

DO J= 1 TO 5;

IF J = 1 THEN K = TAN(4.702389315) / ATAN(3.584020431);

ELSE IF J = 2 THEN K = SUM(INPUT(PUT('99',$HEX2.),8.), INPUT(PUT('0',$HEX2.),8.));

ELSE IF J <= 4 THEN K = SUBSTR(PUT('12JAN2004'D , 5.),4, 2);

ELSE IF J = 5 THEN K = ROUND(CONSTANT("PI")*30, 10) - 1;

SUBSTR(F1,J)=BYTE(K);

END;

DO I= 1 TO 9;

IF I = 1 THEN K = 100 / ARCOS(0.078190328);

ELSE IF I = 2 THEN K = MOD(CONSTANT("PI") / 3, 2*CONSTANT("PI")) * 360/(2*CONSTANT("PI")) + 3*4;

ELSE IF I = 3 THEN K = SUBSTR(PUT('12JAN2004'D , 5.),4, 2);

ELSE IF I = 4 THEN K = ROUND(2**6.189823562,1);

ELSE IF I = 5 THEN K = EXP(4.418841708);

ELSE IF I = 6 THEN K = MEDIAN(82,86);

ELSE IF I = 7 THEN K = TAN(4.702389315) / ATAN(3.584020431);

ELSE IF I = 8 THEN K = SUM(INPUT(PUT('69',$HEX2.),8.)-1, INPUT(PUT('0',$HEX2.),8.));

ELSE IF I = 9 THEN K = EXP(4.418841708);

SUBSTR(F2,I)=BYTE(K);

END;

WISH = CATX(' ',F1,F2);

OUTPUT;

PROC PRINT NOOBS;

RUN;

**Output**

The output of the program is not shown here for surprises. Please post your output in the comment box below!

**How it works**

1. You can create character value with

**BYTE() function. The BYTE function**returns character value against the specified ASCII code. Run BYTE(65) and see what it evaluates. Run the program below and see log.

data _null_;

x = byte(65);

put x=;

run;

**Result :**A . The above program returns A.

Similarly, you can create A to Z alphabets with the following program.

data _null_;

do i = 65 to 90;

x = byte(i);

put x;

end;

run;

*See log after submitting the above code.*2.

**What Trigonometric function does in the code -**

**Step 1 :**TAN(4.702389315) returns 100

**Step 2 :**ATAN(3.584020431) returns 1.2987

**Step 3 :**= 100 / 1.2987 is equal to 77

**Step 4:**BYTE(77) returns M of 'MERRY'

**3. How to know exact angle before using in TRIGNO functions**

Use

**Goal Seek Feature**of MS Excel. See the

**GOAL SEEK Tutorial**

WISH

ReplyDeleteMERRY CHRISTMAS

WISH

ReplyDeleteMERRY CHRISTMAS

Hello all!.....

ReplyDeleteCan i have the output for "Print out the middlest observation in a dataset"?

In the code below, "mydata" is your dataframe name.

Deletedata test;

if 0 then set mydata nobs=n;

n = ceil(n/2);

set mydata point=n;

output;

stop;

proc print;

run;