Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7 Answers
- 9435 Views
- I also Faced
- E-Mail Answers
Answer Posted / virat samratt
proc format;
invalue $convert 'A+' = 100
'A' = 96
'A-' = 92
'B+' = 88
'B' = 84
'B-' = 80
'C+' = 76
'C' = 72
'F' = 65;
data grades;
input ID $3. Grade$ convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
add $ before format name in proc format statement
then you will get
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are 5 ways to perform a table lookup in sas? : Sas-administrator
How substr function works in sas?
What commands are used in the case of including or excluding any specific variables in the data set?
what is operational data and operational system? : Sas-di
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
what is sas and what are the functions? : Sas-administrator
How do you define proc in sas? : sas-grid-administration
Differences between where and if statement?
how would you create multiple observations from a single observation? : Sas programming
how does sas handle missing values in functions? : Sas programming
What is proc sort?
Explain the difference between using drop = data set option in set and data statement?
What are the different servers in sas? : sas-grid-administration
What is the role of administrative users? : sas-grid-administration
how do the in= variables improve the capability of a merge? : Sas programming
