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                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
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
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
 Question Submitted By :: Vinod
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 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
Answer
# 1
Any way i got the answer the answer for the 4'th question is

.sas7dbat
for versions7,8 and 9 the file extension is .sas7bdat.
For the version 6 on UNIX it has the file extension .ssd01 
and on windows it has .sd2.
 
Is This Answer Correct ?    0 Yes 0 No
Myself
 
  Re: 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
Answer
# 2
5. Proc datasets procedure and proc copy procedure where 
proc we can copy.

6. double options gives space between coumns

10. symput to store or assigna a value and symget to get a 
value.
 
Is This Answer Correct ?    0 Yes 0 No
Vemula
 
 
 
  Re: 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
Answer
# 3
3. We can create datsets from rawdata files.
manipulate the datasets, merging, appending,concatinatig,
all we can.
 
Is This Answer Correct ?    0 Yes 0 No
No Need
 
  Re: 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
Answer
# 4
ans for 8'th one

by using where statement no need to read all the
observations in data step only we can read the mentioned
variable or observation
 
Is This Answer Correct ?    0 Yes 0 No
Ravikumard
 
  Re: 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
Answer
# 5
9th question ans 


ENDSAS; is used to terminate the SAS program.
 
Is This Answer Correct ?    0 Yes 0 No
Vijayaragunathan.r
 
  Re: 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
Answer
# 6
1a) 9 ways to create macro variables 
1.into clause of proc sql
2.%local
3.%windows
4. %input
5.%let
6.%do 
7.call symput
8.
9.
2a)confidence limit means in statics procedure to get 
confidence limit means for certain degree to get statics to 
analyse the data
3a
4a).sas7dbat
5a)proc copy in= dataset out=output dataset;
select dataset;
run;
6a)double option is used in proc print procedure to leave a 
blank line between two consecutive rows in an listing 
output and does not show any effect on html output
7a)proc report produce summary tables with plenty options 
8a)where statement is used to select the particular records 
from the input tables/data
9a);
10a)sumput is to write a value to macro variable
symget is to read the value is symput into sas
11a)variables created in macrodefintions are identified as 
local variables or use %put _LOCAL_;
    variables created in OPENCODE are identified as GLOBAL 
variables or use %put _GLOBAL_;
 
Is This Answer Correct ?    1 Yes 0 No
Priyanka
 
  Re: 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
Answer
# 7
For 10 :

callsymput: We can create macro variable from the dataset    
            variable during the datastep execution time.for 
            this process the data set variable must be 
             existed.

symget:  using with symget function you can create data set 
         variable from the macro variable. for this process 
          macro variable must be existed.
 
Is This Answer Correct ?    0 Yes 0 No
Mallikarjuna Raju
 
  Re: 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
Answer
# 8
9 ways we create a macro varisbles are
1)%let
2)macro parameter(a,b)
3)%do
4)call symput
5)sql into clause
6)%window
7)%global
8)%local
9)automatic
 
Is This Answer Correct ?    0 Yes 0 No
Ravinder.arakati
 

 
 
 
Other SAS Interview Questions
 
  Question Asked @ Answers
 
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.  2
WHAT IS LAG FUNCTION ? WHERE CAN YOU IMPLEMENT THIS FUNCTION? Zensar2
What is _n_? Accenture18
is there any difference between proc summary and proc means?  2
what is the difference between SET and MERGE? CitiGroup10
how do u test a pros sql(works or not) without executing it? HSBC1
How do you add a number to a macro variable?  2
in ods is there any lib's SAS1
Name and describe three SAS functions that you have used, if any? Accenture3
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 CybAge1
There is a field containing a date. It needs to be displayed in the format "ddmonyy" if it's before 1975, "dd mon ccyy" if it's after 1985, and as 'Disco Years' if it's between 1975 and 1985. How would you accomplish this in data step code? Using only PROC FORMAT D&B1
Why is a STOP statement needed for the point=option on a SET statement?  2
What report output formats can you generate using SAS? Accenture2
If reading a variable length file with fixed input, how would you prevent SAS from reading the next record if the last variable didn’t have a value? Accenture1
How would you delete duplicate observations? Accenture8
how do you validate sas program? Accenture3
what is the SAS/ACCESS and SAS/CONNECT? TCS4
Under what circumstances would you code a SELECT construct instead of IF statements? Accenture4
How would you code a merge that will keep only the observations that have matches from both sets. Accenture5
What is the purpose of using the N=PS option? Oracle1
 
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