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
- 8193 Views
- I also Faced
- E-Mail Answers
Answer Posted / kondal
i hope this code will work.
data grades;
input ID $3. Grade : convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
proc print data =grades;
run;
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
how do you pull data from equifax?tell me the process?
explain what is factor analysis? : Sas-administrator
What is PROC in SAS?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
I am preparing SAS Certified Advanced Programmer for SAS 9 in 2014. If anybody has the latest dumps for this exam, please mail me at dhiman.mukherjee@gmail.com
What system options would you use to help debug a macro? : sas-macro
What is maximum number of rows and cols can be handled in SAS?
explain about data integrator metadata reports? : Sas-di
name some data transformation used in sas di? : Sas-di
what other sas products have you used and consider yourself proficient in using? : Sas programming
Explain the purpose of substr functions in sas programming.
What do the sas log messages “numeric values have been converted to character” mean? What are the implications?
how many display types available in sas bi dashboard? : Sas-bi
What is substr function?
