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
- 7662 Views
- I also Faced
- E-Mail Answers
Answer Posted / d.balavishnu
9
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
do you need to know if there are any missing values? : Sas programming
What does the RUN statement do?
For what purposes have you used sas macros? : sas-macro
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
Explain the purpose of substr functions in sas programming.
How do dates work in sas?
Explain append procedure?
name some data transformation used in sas di? : Sas-di
Give an example where SAS fails to convert character value to numeric value automatically?
How necessary is it to be creative in your work?
Describe the function and untility of the most difficult SAS macro that you have written.
What are the functions which are used for character handling functions?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
Which command is used to save logs in the external file?
what techniques and/or procs do you use for tables? : Sas programming
