ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
tip       Ask Questions on ANYTHING, that arise in your Daily Life at     FORUM9.COM
Google
 
Categories  >>  Software  >>  Data Warehouse  >>  SAS
 
 


 

 
 Teradata interview questions  Teradata Interview Questions
 Business Objects interview questions  Business Objects Interview Questions
 Cognos interview questions  Cognos Interview Questions
 Informatica interview questions  Informatica Interview Questions
 Crystal Enterprise Suite interview questions  Crystal Enterprise Suite Interview Questions
 Actuate interview questions  Actuate Interview Questions
 Ab Initio interview questions  Ab Initio Interview Questions
 Data Stage interview questions  Data Stage Interview Questions
 SAS interview questions  SAS Interview Questions
 Micro Strategy interview questions  Micro Strategy Interview Questions
 ETL interview questions  ETL Interview Questions
 Data Warehouse General interview questions  Data Warehouse General Interview Questions
Question
data study;
   input Subj   : $3.
         Group  : $1.
         Dose   : $4.
         Weight : $8.
         Subgroup;
		 x= input(Weight,5.1);
datalines;
001 A Low 220 2
002 A High 90 1
003 B Low 193.6 1
004 B High 165 2
005 A Low 123.4 1
;

Why does X get truncated? X shows up as 22 instead of 220,9
instead of 90 and 19.8 instead of 198? This problem doesnt
happen with the values 193.6 and 123.4.

This does not happen if x is read on the 5. informat instead
of the 5.1 informat
 Question Submitted By :: Deepak
I also faced this Question!!     Rank Answer Posted By  
 
  Re: data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
Answer
# 1
Informat 5.1 or 5.2 tell the SAS processor to allocate 
specified number of decimals from right to left of the 
value and the remaining to the number. 
Informat 5. is good if you have one decimal even this fails 
when you have more than one decimal.
 
Is This Answer Correct ?    3 Yes 0 No
Kumaraswamy Maduri
 
  Re: data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat
Answer
# 2
Informat 5.1 or 5.2 tell the SAS processor to allocate 
specified number of decimals from right to left of the 
value and the remaining to the number. 
Informat 5. is good if you have one decimal even this fails 
when you have more than one decimal.
 
Is This Answer Correct ?    2 Yes 0 No
Kumaraswamy Maduri
 
 
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
There are 200 observations in a dataset, i want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?  5
how to write code for left outer join in SAs using datastep? CitiGroup5
How do you read in the variables that you need? Accenture6
The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend? Oracle4
Name statements that are recognized at compile time only?  4
if x=round(26.3,10)-1 then x= how much and how explain? BoA2
What is difference between sas rename and lable?  1
how many types of MERGE? CitiGroup12
How do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?  2
IS SAS COMPILER OR INTERPRETER? EXPLAIN? HSBC2
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?  2
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If? Cognizent3
what is the main difference between rename and label? (don't say that they both perform the same function). Parexel9
How do you read in the variables that you need?  5
what is pdv? how it is related to input buffer in sas? Satyam4
What SAS statements would you code to read an external raw data file to a DATA step?  7
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question CitiGroup8
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.  3
what is the diff b/w verification validation in sas SAS3
What is the Program Data Vector (PDV)? What are its functions? Accenture5
 
For more SAS Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com