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
- 9894 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
Explain what is SAS informats?
How would you identify a macro variable? : sas-macro
what does the run statement do? : Sas programming
What is the role of sas grid administrator? : sas-grid-administration
What are the special input delimiters used in SAS?
Are you sensitive to code walk-throughs peer review or QC review?
What’s the difference between var b1 – b3 and var b1 — b3?
what type of graphs we will create(for 2+years candidates)?
What is the command used to find missing values?
what are informats in sas? : Sas-administrator
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable? : sas-macro
How long can a macro variable be? A token? : sas-macro
what is program data vector? : Sas-administrator
What is the order of application for output data set options, input data set options and SAS statements?
What is the difference between the proc sql and data step?
