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

Hello Friends, am new to this forum and am not good at sas progarmming. please can any one of you send me couple of sample large sample SAS Jobs which can you use 200 MB of data and other sas job upto 25GB of data. am doing a performance testing on our legacy systems and new upgraded system. I would really appreciate if you can do me this favor Thank you Priya

0 Answers  


i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?

3 Answers   L&T,


How would you define the end of a macro? : sas-macro

0 Answers  


Which are SAS Windows Clients & SAS Java Clients

3 Answers   TCS,


How many tiers in sas architecture?

2 Answers  


create macros---you have 365 number of data and you need to merge it throw the macros,,,,,, data file1; input a @@; cards; 1 2 3 4 ; run; data file2; input a @@; cards; 5 6 7 8 ; run; data file3; input a @@; cards; 9 10 11 12 ; run;data file4; input a @@; cards; 13 14 15 16 ; run;

6 Answers   WNS,


which stats created by proc means that are not created by proc summary or vice versa?

2 Answers   GSK,


How can you create a macro variable with in data step? : sas-macro

0 Answers  


Can you continue to write code while the rest of the people on the floor where you work have a noisy party to which you were not invited?

2 Answers   Oracle,


Differentiate between format and informat? : sas-grid-administration

0 Answers  


Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com

0 Answers  


what is metadata? : Sas-bi

0 Answers  


Categories