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
- 9725 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 we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
How do you control the number of observations and/or variables read or written?
What is SAS informats?
how does sas handle missing values in functions? : Sas programming
what is ae onset date n what is RDS
Mention how to limit decimal places for the variable using proc means?
how to generate the test data in sas without input data? : Sas-administrator
Mention what are the data types does SAS contain?
How would you identify a macro variable?
What is SAS?
Name types of category in which SAS Informats are placed?
Explain data_null_?
what does the run statement do? : Sas programming
How do you specify the number of iterations and specific condition within a single do loop?
What are the prime responsibilities of data integration administrator? : Sas-di
