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 / d.balavishnu
9
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Give some examples where proc report’s defaults are different than proc print’s defaults?
What are the features of SAS?
what is proc Index? and what is proc document?
How are numeric and character missing values represented internally?
What is the difference between nodupkey and nodup options?
what is hash files in sas and why we are using this one in sas?
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what is sas metadata repository? : Sas-bi
How do you test for missing values?
it will become easy if uuu provide website linkssss and list of consultanciessssss
Describe a time when you were really stuck on a problem and how you solved it?
Explain what Proc glm does?
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?
what can you learn from the sas log when debugging? : Sas programming
What are the data types does SAS contain?