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
- 9713 Views
- I also Faced
- E-Mail Answers
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 the use of divide function?
How to sort in descending order?
For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration
What is data _null_?
What does the RUN statement do?
Can you explain the process of calendar?
Which function is used to count the number of intervals between two sas dates?
Differentiate between proc means and proc summary.
How do you connect the desktop application to metadata server? : sas-grid-administration
what is change analysis in sas di ? : Sas-di
How we can create SAS USER DEFINED CODE?
what is ae onset date n what is RDS
what is snowflake schema? : Sas-di
Tell e how how dealt with..
Explain what is data step?
