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
- 9705 Views
- I also Faced
- E-Mail Answers
Answer Posted / kondal
i hope this code will work.
data grades;
input ID $3. Grade : convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
proc print data =grades;
run;
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is the work of tranwrd function?
Explain what is SAS informats?
Differentiate between ceil and floor functions.
how does sas handle missing values in procs? : Sas programming
How we can create SAS USER DEFINED CODE?
What do you know about sas data set?
Explain translate function?
Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya
What do the put and input function do?
why is sas data integration studio important? : Sas-di
what is null hypothesis? why do you consider that?
How would you invoke a macro? : sas-macro
If you could design your ideal job, what would it look like?
what is intially documentation in sas?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
