What happens in the following code, if u type 8 instead of
*?
proc sql noprint;
create table abc as
select 8 from lib.abc;
quit;

Answers were Sorted based on User's Feedback



What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc..

Answer / sasuser

It will have one column with value 8 in table abc.

Is This Answer Correct ?    13 Yes 1 No

What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc..

Answer / ragg

it will just print '8' many times in output window

Is This Answer Correct ?    6 Yes 0 No

What happens in the following code, if u type 8 instead of *? proc sql noprint; create table abc..

Answer / prr

Hi Friends,
If we write 8 in the place of * then SAS Assigns,
8 for all the observations in the output window.

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SAS Interview Questions

What are the different types of sas functions?

0 Answers  


The Lion King is hosting an animal conference. All the animals in the world attend except one. Which animal does not attend?

6 Answers   Oracle,


Can anyone help to find a statement to get all the predefined formats?

3 Answers   Verinon Technology Solutions,


what is SAS/Access and SAS/Connect?what are the uses?

3 Answers  


what is the Population you used in your project, is it ITT or PP?

0 Answers   Accenture, Quintiles,






Name and describe three SAS functions that you have used, if any?

2 Answers  


What will calendar procedure do?

0 Answers  


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

0 Answers  


How do you debug and test your SAS programs?

0 Answers   Quintiles,


What is the difference between nodup and nodupkey options?

20 Answers   iFlex, Makro, Talwar,


What is the pound sign used for the DATA _NULL_?

14 Answers  


what are the differences between proc report and proc tabulate?

3 Answers  


Categories