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 / amaresh
proc format;
invalue convert 'A+' = 100
'A' = 96
'A-' = 92
'B+' = 88
'B' = 84
'B-' = 80
'C+' = 76
'C' = 72
'F' = 65;
run;
data grades;
input ID @5 Grade convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
run;
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
Differentiate between format and informat? : sas-grid-administration
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
How many data types are there in SAS?
What is the role of sas grid administrator? : sas-grid-administration
how do you debug and test your sas programs? : Sas programming
where are dashboard components are created and maintained? : Sas-bi
what can you learn from the sas log when debugging? : Sas programming
How would you determine the number of missing or nonmissing values in computations?
what is treatment emergent events and treatment emregent adverse event
how do you want missing values handled? : Sas programming
what is the basic structure sas administrator? : Sas-administrator
For clinical entire study how many tables will create approx?
How do you connect the desktop application to metadata server? : sas-grid-administration
What is proc sort?
what are the considerations when picking a SAS/STAT procedure?