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
- 9897 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
Explain how merging helps to combine data sets.
What are the parameters of scan function?
what does the run statement do? : Sas programming
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
What are the different operating system platforms in which we can use sas? : sas-grid-administration
how would you determine the number of missing or nonmissing values in computations? : Sas programming
What are the differences between proc means and proc summary?
Mention the difference between ceil and floor functions in sas?
explain the concepts and capabilities of business object? : Sas-bi
What was the last computer book you purchased? Why?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
what is sas application server? : Sas-di
What is your favorite all time computer book? Why?
Explain the purpose of substr functions in sas programming.
