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;
- 3 Answers
- 5526 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sasuser
It will have one column with value 8 in table abc.
| Is This Answer Correct ? | 13 Yes | 1 No |
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 |
What report output formats can you generate using SAS?
What are the prime responsibilities of data integration administrator? : Sas-di
Suppose there is a SAS dataset with following values - Parent Child A B B C D E F G G H H I and so on….. This goes onto 1000s of observations/rows. Now how do we identify from this dataset Grandparents and Grandchildrens ?
5 Answers American Express, Barclays,
Explain the message ‘MERGE HAS ONE OR MORE DATASETS WITH REPEATS OF BY VARIABLE’.
it will become easy if uuu provide website linkssss and list of consultanciessssss
Name statements that function at both compile and execution time.
how to extract data from SAP servers? Is like oracle servers or any other methods to extract please reply me.
what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?
What are the features of SAS?
Which are SAS Windows Clients & SAS Java Clients
You need to create an In List that it is to be later used in a Where Clause that includes all the Regions that begin with the letter A from the sashelp.shoes table. Using PROC SQL with an into clause create the following string from the sashelp.shoes table using the variable region “AFRICA”,”ASIA”,…..
What does a PROC TRANSPOSE do?
Teradata 
