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
- 9421 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
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
what is the use of sas management console? : Sas-di
explain the proc in sas? : Sas-administrator
What are common programming errors committed in sas
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
What are pdv and it functions?
Mention what are the data types does SAS contain?
How do you debug and test your SAS programs?
how do the in= variables improve the capability of a merge? : Sas programming
What is the difference between reading data from an external file and reading data from an existing data set?
How do you connect the desktop application to metadata server? : sas-grid-administration
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
What does P-value signify about the statistical data?
Mention sas system options to debug sas macros.
What is the difference between INPUT and INFILE ?
