i hope this code will work. data grades; input ID $3. Grade : convert.;

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

Question Posted / kondal

7 Answers
9479 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

Please Help Members By Posting Answers For Below Questions

What is the sas data set? : sas-grid-administration

930

What is the difference between input and infile statement?

1126

what r the job openings SAS for fresher graduates !

2402

Describe the function and untility of the most difficult SAS macro that you have written.

2165

Which date function advances a date, time or datetime value by a given interval?

1099

Difference between SAS STATA & SPSS?

1071

Mention common programming errors committed in sas ?

1078

how do you test for missing values? : Sas programming

1020

What do you know about symput and symget?

1177

Why double trailing @@ is used in input statement?

1173

Give some examples where proc report’s defaults are same as proc print’s defaults?

1066

What are symget and symput? : sas-macro

1261

Explain bmdp procedure?

993

What are the difference between sas functions and procedures?

1086

how to generate the test data in sas without input data? : Sas-administrator

1075