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
- 9700 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
what is sas application server, database server, sas olap server and sas metadata server? : Sas-di
do you need to know if there are any missing values? : Sas programming
explain about various caches available in data integrator? : Sas-di
Enlist the functions performed by sas.
describe how to adjust the performance of data integrator? : Sas-di
What is a pdv and what are its functions?
what techniques and/or procs do you use for tables? : Sas programming
what is star schema? : Sas-di
what are the categories that sas informats are used to the place the data? : Sas-administrator
Tell e how how dealt with..
What does the RUN statement do?
How does the internal authentication work in sas? : sas-grid-administration
What is the length assigned to the target variable by the scan function?
how would you create multiple observations from a single observation? : Sas programming
What is SAS? What are the functions does it performs?
