data jagan1.s; input bp$; cards; 100/90 120/89 112/87 run; in the above

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 / manoj.b17

3 Answers
6364 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

Answer / 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

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

Answer / aaaa

data jagan1.s;
infile cards dlm='/' dsd;
input b p;
cards;
100/90
120/89
112/87
run;

Is This Answer Correct ?

0 Yes

0 No

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

Answer / srinivasa rao

Using input function

data jaganl.1;
input bp$;
a=input(bp);
cards;
100/90
120/89
112/87
;
run;

Is This Answer Correct ?

1 Yes

9 No

Post New Answer

More SAS Interview Questions

what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?

1 Answers

What are the analysis datasets created, and what are the new variables created in CLINICAL SAS

1 Answers Accenture, Sciformix,

What is the use of the %include statement?

0 Answers

What can you learn from the SAS log when debugging?

0 Answers Quintiles,

what is sas business intelligence? : Sas-bi

0 Answers

What do you understand by the term Normal Distribution?

0 Answers

Mention the validation tools used in SAS?

0 Answers

I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.

1 Answers

why is sas data integration studio important? : Sas-di

0 Answers

What is SAS informats?

0 Answers

Does anybody have SAS Training manual or documentation or can you refer me any book to have better understanding on SAS. I am fresher to SAS tool. (Ready to pay)

4 Answers

If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?

2 Answers

For more SAS Interview Questions Click Here