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
- 9706 Views
- I also Faced
- E-Mail Answers
Answer Posted / sai ram
Hi,
you must assign position of Grade variable.you gave a length of id is $3. so you must gave a proper position to Grade variable otherwise it will show the missing.
proc format;
invalue convert 'A-' = 100
'A' = 96
'B+' = 88
'C+' = 76
'F' = 65
;
run;
data deepak;
input ID $3. @5 Grade convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
run;
proc print data = deepak;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is the difference between unique key and primary key? : Sas-di
What is PROC in SAS?
What can be the size of largest dataset in SAS?
how will you location sas platform applications available from web browser? : Sas-bi
which date function advances a date, time or datetime value by a given interval? : Sas programming
How to test the debugging in sas?
What are the default statistics that proc means produce?
What is auto call macro and how to create a auto call macro? What is the use of it? How to use it in sas with macros? : sas-macro
Are you involved in writing the inferential analysis plan? Tables specfications?
Of all your work, where have you been the most successful?
Have you used macros? For what purpose you have used? : sas-macro
What do the PUT and INPUT functions do?
What are the difficulties u faced while doing vital signs table or dataset?
Compare sas with other data analytics tools.
What is the use of PROC gplot?
