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
How is character variable converted into numeric variable and vice versa?
How do dates work in sas?
How would you include common or reuse to be processed along with your statements?
Explain translate function?
Mention what is PROC in SAS?
Can you execute macro within another macro? : sas-macro
Do you know the features of sas?
i want for interview question & answer plz it need immediate send t my mail raviprakashmot@gmal.cm
what do the pad and dim functions do? : Sas programming
why a stop statement is needed for the point= option on a set statement?
If you were told to create many records from one record, show how you would do this using array and with proc transpose?
What is the purpose of trailing @ and @@? How do you use them?
Explain data step in SAS
hi all, I need the SAS DI DUMP(A00 260) for attending the certification. if any one have, pls provide it.Please Email to vrpotluri@hotmail.com. Thanks - Ramana
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??