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
- 9428 Views
- I also Faced
- E-Mail Answers
Answer Posted / deepak
Thanks Kondal,
But why does it not work? If u see there, ID has only 3
columns, and technically it must work without a colon (ID :
$3.). I get a perfct output with a semicolon, but without it
I dont.
Is this something specific about user defined Informats?
Appreciate any help
Deepak
| Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
what is the purpose of _error_? : Sas programming
please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??
How do you use the do loop if you don’t know how many times you should execute the do loop?
What are the 3 components in sas programming?
how the sas basic syntax style described? : Sas-administrator
How do you delete duplicate observations in sas?
What are the differences between sum function and using “+” operator?
what is the function of catx syntax? : Sas-administrator
What are the advantages of using sas?
What are the features of SAS?
What is the maximum length of the macro variable?
how would you determine the number of missing or nonmissing values in computations? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
what are the benefits of data integration? : Sas-di
How to limit decimal places for variable using proc means?
