1. Categories >> Software >> Data Warehouse >> SAS
  2. Suggest New Category

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 / sai ram

Answer Posted / sai ram

Hi,
you must assign position of Grade variable.you gave a length of id is $3. so you must gave a proper position to Grade variable otherwise it will show the missing.

proc format;
invalue convert 'A-' = 100
'A' = 96
'B+' = 88
'C+' = 76
'F' = 65
;
run;

data deepak;
input ID $3. @5 Grade convert.;
datalines;
001 A-
002 B+
003 F
004 C+
005 A
;
run;
proc print data = deepak;
run;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do dates work in sas?

639

Given an unsorted data set, how to read the last observation to a new data set?

832

what is sas database server? : Sas-di

611

What would you change about your job?

1920

Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro

694




What is the maximum length of the macro variable? : sas-macro

617

Explain what is SAS informats?

619

What does proc print, and proc contents are used for?

609

Which function is used to count the number of intervals between two sas dates?

566

What are symget and symput? : sas-macro

727

Differentiate between format and informat? : sas-grid-administration

575

what are the best practices to process the large data sets in sas programming? : Sas-administrator

533

How to read an input file in sas?

652

What is the length assigned to the target variable by the scan function?

670

what is study design in while working with SAS? what are screening variables in SAS?

1679