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 / ramakrishna
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 $3. Grade $ convert.;
*format Grade convert. ;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
proc print data = grades;
run;
Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
what is change analysis in sas di ? : Sas-di
how many display types available in sas bi dashboard? : Sas-bi
What are the automatic variables for macro? : sas-macro
what are informats in sas? : Sas-administrator
How would you determine the number of missing or nonmissing values in computations?
What is a macro routine?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
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 is the difference between INPUT and INFILE ?
How to include or exclude specific variables in a data set?
Describe a time when you were really stuck on a problem and how you solved it?
What is the difference between SAS functions and procedures?
what has been your most common programming mistake? : Sas programming
Mention few capabilities of sas framework.
How do you connect the desktop application to metadata server? : sas-grid-administration