94.INPUT STATEMENT | CHARACTER TO NUMERIC | RENAME | SIMPLE EXAMPLES

INPUT STATEMENT | CHARACTER TO NUMERIC | RENAME | SIMPLE EXAMPLES

NOTE:CHARACTER OBSERVATIONS ARE ALIGN TO LEFT AND NUMERIC TO RIGHT..

DATA NEW;

 CHAR_VAR = '12345678';

 NUMERIC_VAR = INPUT(CHAR_VAR, 8.);

RUN;

PROC PRINT;RUN;

OUTPUT:

The SAS System

Obs	CHAR_VAR	NUMERIC_VAR
1	12345678	12345678

DATA NEW1;

 OLD = '12345678';

 NEW = INPUT(OLD, 8.);

 DROP OLD;

 RENAME NEW = OLD;

RUN;

PROC PRINT;RUN;

OUTPUT:

The SAS System

Obs	OLD
1	12345678

DATA AA;

INPUT  AAA$ BBB$ CCC;

CARDS;

1 A 5 

1 F 6

5 E 6

7 G 5

;

RUN;

PROC PRINT;

RUN;

OUTPUT:

 

The SAS System

Obs	AAA	BBB	CCC
1	1	A	5
2	1	F	6
3	5	E	6
4	7	G	5

DATA N1;

SET AA;

  NUM=INPUT(AAA, COMMA9.);

RUN;

PROC PRINT;

RUN;

OUTPUT:

The SAS System

Obs	AAA	BBB	CCC	NUM
1	1	A	5	1
2	1	F	6	1
3	5	E	6	5
4	7	G	5	7

TRY THIS AND COMMENT...

-->PLEASE READ AND COMMENT THE BLOG...

--PLEASE FOLLOW THE BLOG FOR MORE UPDATES...

--FOLLOW US IN FACEBOOK SASALL4YOU AND JOIN ...

--JOIN US IN FACEBOOK AND TELEGRAM  CHANNEL FOR MORE UPDATES

   CLICK HERE : https://t.me/SasAll4You