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
- 9905 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
How would you define the end of a macro? : sas-macro
Do you know the features of sas?
What are pdv and it functions?
Give some examples where proc report’s defaults are same as proc print’s defaults?
Do you need to know if there are any missing values?
What are the 3 components in sas programming?
How you can read the variables that you need?
What is program data vector (pdv)?
explain about sas business intelligence? : Sas-bi
explain the use of % includes a statement in sas? : Sas-administrator
explain about data integrator metadata reports? : Sas-di
What do the put and input function do?
What is the sas data set? : sas-grid-administration
What is the use of divide function?
what is hierarchy flattening? : Sas-di
