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 / deepak

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


Please Help Members By Posting Answers For Below Questions

In SAS explain which statement does not perform automatic conversions in comparisons?

795

How are numeric and character missing values represented internally?

1132

Explain data_null_?

607

Can you execute a macro within a macro? Describe. : sas-macro

667

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?

1766




What are symget and symput? : sas-macro

727

I need level 2 to 5 sas using companies in india

1926

What is the difference between %local and %global? : sas-macro

664

How do you connect the desktop application to metadata server? : sas-grid-administration

580

How would you define the end of a macro?

698

Are you involved in writing the inferential analysis plan? Tables specfications?

2107

Explain the use of proc gplot? : sas-grid-administration

549

How would you determine the number of missing or nonmissing values in computations?

646

What are the implications?

1179

How can you create a macro variable with in data step? : sas-macro

570