Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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

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

what is enterprise guide? What is the use of it? : Sas programming

1021


what is operational data and operational system? : Sas-di

1115


What are the statements that are executed only?

1152


What is maximum number of rows and cols can be handled in SAS?

1591


What are the 3 components in sas programming?

1198


where are dashboard components are created and maintained? : Sas-bi

1013


how will you location sas platform applications available from web browser? : Sas-bi

1076


Describe the function and utility of the most difficult SAS macro that you have written?

2569


what r the job openings SAS for fresher graduates !

2458


What system options would you use to help debug a macro? : sas-macro

1098


explain the difference between alternate key, business key, foreign key, generated key, primary key, retained key and surrogate key ? : Sas-di

1077


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

2566


in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1079


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

1199


Describe what are the different levels of administrative users in sas? : sas-grid-administration

1038