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 new features included in the new version of SAS i.e., SAS9.1.3?

5 Answers   College School Exams Tests, Wockhardt,


Tell e how how dealt with..

0 Answers   Wipro,


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 Answers  


how to delete the duplicates by using proc sql?

3 Answers   Genpact,


How would you create multiple observations from a single observation?

1 Answers   Quintiles,






Can you excute a macro within a macro? Describe.

2 Answers   Genta,


how does sas handle missing values in procs? : Sas programming

0 Answers  


how to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too

5 Answers   CTS,


% let A=3+4 what is result

4 Answers   Satyam,


how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming

0 Answers  


name the scheduler for scheduling job and explain the scheduler? : Sas-di

0 Answers  


Mention common programming errors committed in sas ?

0 Answers  


Categories