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                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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
Hi I have list of products in a dataset,
which are classified by other name for eg:- there is a 
product A> Malambo Shiraz Malbec 750ML(0388) which is a Red 
wine.Now i need to generate a report where it shows if this 
product appears then it should b displayed as red 
wine,similarly for other products and other classification. 
I dont wan use proc format.

 Question Submitted By :: Santosh
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
Answer
# 1
Hi.

I don t know any specific reason why yu dont wan to use 
proc format. It would be better if you use that as there 
would be probably some more wines in the market where u can 
apply this format of red wine....
Anyways I think you can try this.
* the content in brackets have to come from your program

proc sql;
update [dataset_name];
set [wine_name_field] = "Red Wine" where [wine_name_field]
="Malambo Shiraz Malbec 750ML(0388)";
exit;

let me know in case u require something else.
 
Is This Answer Correct ?    0 Yes 0 No
Saurabh
 
  Re: Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
Answer
# 2
above answer is correct. Just need to correct syntax 
errors. Following is the corrected code,

proc sql;
update [dataset_name]
set [wine_name_field] = "Red Wine" where [wine_name_field]
="Malambo Shiraz Malbec 750ML(0388)";
quit;
 
Is This Answer Correct ?    0 Yes 0 No
Sheetal
 
 
 
  Re: Hi I have list of products in a dataset, which are classified by other name for eg:- there is a product A> Malambo Shiraz Malbec 750ML(0388) which is a Red wine.Now i need to generate a report where it shows if this product appears then it should b displayed as red wine,similarly for other products and other classification. I dont wan use proc format.
Answer
# 3
You can use HASH lookup for this. Performnace will depend 
on the data size.
 
Is This Answer Correct ?    0 Yes 0 No
Harsh
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;  1
When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc? Accenture2
How would you code the criteria to restrict the output to be produced? Accenture5
Name the option to produce a frequency line items rather that a table.  2
what is the diff b/w verification validation in sas SAS3
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?  3
Describe how you would pass data to macro.  3
where will go the observations that were deleted by delete statement?  1
what other SAS features do you use for error trapping and data validation?  1
Are you familiar with special input delimiters? How are they used? Accenture3
How do you put a giraffe into the refrigerator? Oracle2
How the date 04oct1994 is stored in SAS,not only give the answer explain in brief?  3
How would you include common or reuse code to be processed along with your statements? PSCI5
Can you use a macro within another macro? If so how would SAS know where the current acro ended and the new one began?  1
CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE CybAge2
IS SAS COMPILER OR INTERPRETER? EXPLAIN? HSBC2
How would you code the criteria to restrict the output to be produced?  6
Does SAS ?Translate? (compile) or does it ?Interpret?? Explain.  8
define table lookup and how may ways it can be done...explian  3
how to assign a macro value to a variable? CitiGroup6
 
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