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
describe the interaction table in sas di? : Sas-di
What is the use of PROC gplot?
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
for report generation which one you used proc report or data_null_?
What are the data types in sas?
For clinical entire study how many tables will create approx?
Which command is used to perform sorting in sas program?
How long can a macro variable be? A token? : sas-macro
How to create list output for cross-tabulations in proc freq?
What is SAS?
Explain how merging helps to combine data sets.
How many data types are there in SAS?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
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? : sas-macro
What are the five ways to do a table lookup in sas? : sas-grid-administration