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
- 9502 Views
- I also Faced
- E-Mail Answers
Answer Posted / d.balavishnu
9
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Mention some common errors that are usually committed in sas programming.
how many types of prompts are there? : Sas-bi
How do you specify the number of iterations and specific condition within a single do loop?
what are input dataset and output dataset options? : Sas programming
what are the benefits of data integration? : Sas-di
what is the primary data source for the wrs? : Sas-bi
Mention sas system options to debug sas macros.
Mention the validation tools used in SAS?
What are the limitations for memory allocation for SAS variables
How do dates work in sas?
do you need to know if there are any missing values? : Sas programming
what are _numeric_ and _character_ and what do they do? : Sas programming
How sas treats the dsd delimiters?
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
describe how to adjust the performance of data integrator? : Sas-di
