libname deepak 'C:\SAS Files';
proc format;
invalue convert 'A+' = 100
'A' = 96
'A-' = 92
'B+' = 88
'B' = 84
'B-' = 80
'C+' = 76
'C' = 72
'F' = 65;
data deepak.grades;
input ID $3. Grade convert.;
*format Grade convert. ;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;

proc print data = deepak.grades;
run;
I get the following output
Obs ID Grade
1 001 .
2 002 .
3 003 .
4 004 .
5 005 .

I don’t understand why Grade shows up as a missing value.
Everything seems fine, including ID $3.
Now, in case I use ID : $3. Or use column input, I get the
desired output.

Kindly help
Deepak

Answer Posted / kondal

i hope this code will work.
data grades;
input ID $3. Grade : convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
proc print data =grades;
run;

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how merging helps to combine data sets.

764


Describe crosslist option in tables statement?

884


What do the put and input function do?

732


What is the use of %include statement?

771


What is the difference between one to one merge and match merge? Give an example.

750






Explain substr function?

732


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

722


what is the Population you used in your project, is it ITT or PP?

2361


How to read an input file in sas?

825


where are dashboard components are created and maintained? : Sas-bi

735


If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1064


how are numeric and character missing values represented internally? : Sas programming

796


What is the use of PROC gplot?

806


Explain the difference between nodup and nodupkey options?

746


Did you used proc test? when?

1741