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 / 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 is ae onset date n what is RDS
What is maximum number of rows and cols can be handled in SAS?
Did you used proc test? when?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
What is factor analysis?
what do the sas log messages "numeric values have been converted to character" mean? What are the implications? : Sas programming
What is the difference between one to one merge and match merge? Give an example.
How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?
Difference between sum function and using “+” operator?
hi tell be about pfizer? how to compare the work with other companies ? please tell me how to login and work also?
Define run-group processing?
How can you create a macro variable with in data step? : sas-macro
how does sas handle missing values in procs? : Sas programming
What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?