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
- 9480 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
If a variable contains letters or special characters, can it be numeric data type?
what are several options for creating reports in web report studio? : Sas-bi
How can you create a macro variable with in data step? : sas-macro
What do you know about sas data set?
what are informats in sas? : Sas-administrator
What are types of transport files?
what is program data vector? : Sas-administrator
How would you define the end of a macro?
What do you know about symput and symget?
What is the role of sas grid administrator? : sas-grid-administration
What is the general format of function in sas? : sas-grid-administration
Hi, If anyone has base SAS certification dumps, please share.
What system options would you use to help debug a macro? : sas-macro
What are the default statistics that proc means produce?
What is program data vector (pdv) and what are its functions?
