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
- 9434 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
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What is the differnce between SDTM 3.1.2 to 3.1.1 version
What is interleaving in SAS?
in the flow of data step processing, what is the first action in a typical data step? : Sas programming
what is hierarchy flattening? : Sas-di
what is the purpose of _error_? : Sas programming
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
explain what is data set in sas? : Sas-administrator
what is the Population you used in your project, is it ITT or PP?
Explain the special input delimiters used in sas programming.
Describe a time when you were really stuck on a problem and how you solved it?
what is the use of proc sql? : Sas programming
How do you convert basic cube to transaction cube and transaction cube to basic cube?
What is a method to debug and test your SAS program?
How will you use the WHO Drug Dictionary for Reporting Clinical Trials?
