DATA JAGAN1.S1; SET JAGAN1.S; X=SCAN(BP,1,'/'); Y=SCAN(BP,2,&#

data jagan1.s;
input bp$;
cards;
100/90
120/89
112/87
run;
in the above code how to convert character data values to numeric data values?

Question Posted / hny135

Answer Posted / hny135

DATA JAGAN1.S1;
SET JAGAN1.S;
X=SCAN(BP,1,'/');
Y=SCAN(BP,2,'/');
A=INPUT(X,3.);
B=INPUT(Y,2.);
DROP BP X Y;
RUN;

Is This Answer Correct ?

7 Yes

1 No

Please Help Members By Posting Answers For Below Questions

what is function of retain statment

2041

How to limit decimal places for variable using proc means?

1113

Differentiate between sas functions and sas procedures.

1243

what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming

1082

What is the difference between %put and symbolgen? : sas-macro

1240

Do you know the features of sas?

1044

What do the put and input function do?

1067

what is hierarchy flattening? : Sas-di

1083

What is SAS?

1059

What are the 3 components in sas programming?

1198

which features do you use to check the data validations and errors? : Sas-administrator

1059

Can you execute a macro within a macro? Describe. : sas-macro

1111

explain about sas business intelligence? : Sas-bi

1146

what is sas application server, database server, sas olap server and sas metadata server? : Sas-di

1018

what is sas metadata repository? : Sas-bi

1119