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
Explain how merging helps to combine data sets.
Describe crosslist option in tables statement?
What do the put and input function do?
What is the use of %include statement?
What is the difference between one to one merge and match merge? Give an example.
Explain substr function?
why is sas data integration studio important? : Sas-di
what is the Population you used in your project, is it ITT or PP?
How to read an input file in sas?
where are dashboard components are created and maintained? : Sas-bi
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
how are numeric and character missing values represented internally? : Sas programming
What is the use of PROC gplot?
Explain the difference between nodup and nodupkey options?
Did you used proc test? when?