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
- 9896 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 star schema? : Sas-di
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
Do you need to compute new variables? If so,should you do this before you execute the report-writing procedure?
What are the difficulties u faced while doing vital signs table or dataset?
If you could design your ideal job, what would it look like?
what are several options for creating reports in web report studio? : Sas-bi
Give e an example of..
What is a pdv and what are its functions?
What is the role of unrestrictive users? : sas-grid-administration
explain the concepts and capabilities of business object? : Sas-bi
What are the data types that sas contain?
explain the proc in sas? : Sas-administrator
Differentiate between format and informat? : sas-grid-administration
what is study design in while working with SAS? what are screening variables in SAS?
How we can call macros with in data step? : sas-macro
