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
- 9481 Views
- I also Faced
- E-Mail Answers
Answer Posted / amaresh
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 @5 Grade convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
run;
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
how can you create zero observation dataset? : Sas programming
Tell e how how dealt with..
How do you define proc in sas? : sas-grid-administration
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
what do you mean by data staging area? : Sas-di
How do you test for missing values?
where are dashboard components are created and maintained? : Sas-bi
Explain how merging helps to combine data sets.
what is proc Index? and what is proc document?
What is PDV?
Mention what is the difference between nodupkey and nodup options?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
Mention the category in which sas informats are placed?
What are the data types that sas contain?
do you prefer proc report or proc tabulate? Why? : Sas programming
