InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What is the difference between UNION and UNIONALL Operator in SAS? |
|
Answer» CONNECTING to teradata using pass through Procsql; Connect to Teradata( USER= “ &user_id.” PASSWORD =” &dbpass” tdpid =rchgrp2 MODE= ‘teardata’); CREATE table work. Account_details as(SELECT Account_ Number, Enroll_ Date, Sales, City From Master_ acct_ details Where Account_ Number is not null and Sales gt 40000 ); Disconnect from Teradata; Quit; Connecting to db2 using pass through: Procsql; Connect to db2( DATABASE=CRD_ PROD USER= “ &user_id.” PASSWORD=” &dbpass”); Create table work. Account_details as(Select Account_ Number, Enroll_ Date, Sales, City From Master_ acct_ details Where Account_ Number is not null and Sales gt 40000 ); Disconnect from db2; Quit;Other way using the library assignments: Libname AM DB2 DATABASE= CARD_USA Schema=DDKAUTO USER=”&user_ id.” PASSWORD= “&dbpass”; Procsql;Create table work. Account_details as(Select Account_ Number, Enroll_ Date, Sales, City From AM.Master_ acct_ details Where Account_ Number is not null and Sales gt 40000); |
|