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;
Answer Posted / sasuser
It will have one column with value 8 in table abc.
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
Explain what is data step?
Describe a time when you were really stuck on a problem and how you solved it?
what are several options for creating reports in web report studio? : Sas-bi
How do you test for missing values?
I have a SCD Type 2 Dimention for Location In which A Sales Office in Having two Surrogate Keys just because of the change in it's Sales Group. SKey SalesGroup Sales Office BeginDate EndDate 280 SG1 SO1 01APR2000 01APR2010 281 SG2 SO1 02APR2010 31MAR2999 Now while loading the Fact, the Lookup ir returning SKey 280 for records before and after 01APR2010. I am not able to give WHERE condition in the Lookup Properties (TranDate between BeginDate and EndDate). Please help.
how will you location sas platform applications available from web browser? : Sas-bi
what is SAS OPTIMIZATION?
how do you debug and test your sas programs? : Sas programming
Mention what is the difference between nodupkey and nodup options?
What is the maximum length of the macro variable?
Which command is used to perform sorting in sas program?
What is the difference between order and group variable in proc report?
Why and when do you use proc sql?
what can you learn from the sas log when debugging? : Sas programming
How necessary is it to be creative in your work?