The below code we are using for creating more than one macro variables in proc sql using into clause. How we can use same code to create macro variables vara, varb, varc instead of var1, var2, var3.? proc sql noprint; select count(distinct(patient)) into :var1 - :var3 from dataset1 group by trtreg1c ; quit;
1 3283whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?
1 1610Post New Accenture SAS Interview Questions
DEAR SIR/MADAM,CLEARLY EXPLAIN ABOUT CRAWLING AND COGGING EFFECTS IN INDUCTION MOTOR.
HOW MANY UNITS ARE CONSUMED DURING 1 HR BY 1.5 TON A/C
what is mean by Performance Related Testing in data base?
Why dissolution test is not performed in all of the products
Write notes on the following: (a) The concept of Know Your Customer (KYC) (b) Endorsement of cheques (c) Pay Order (d) Bank Draft
What is the use of string function index(string,search) in AWK?
How to check vortex flow meter is in good condition while we do not having calibration setup?
Hi iam shankar here, right now iam working on manual testing. i want to switch over automation tool qtp, right now iam taking training class outside on qtp, please let me know the cost of QTP tool for full version, wether it's an annual subscription or monthly subscription.
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
What is an AMI? How do we implement it?
In IGATE, 2 yrs bond for fresher and reverent experience 1 year bond. First z essay writing. “Unforgettable movement ur life” Tiz in ITPL IGATE stopping
What happens if we delay the enabling of Clock signal?
rate analysis for cement pointing 1:4 , for 100 sq m
What are the mandatory information need to enter in summary tab?
now a days essential oils are different from volatile oils.why?
- C (57)
- OOPS (10)
- C++ General (4)
- COM DCOM (1)
- Delphi (1)
- PHP (1)
- Programming Languages AllOther (13)
- JavaScript (1)
- VB Script (7)
- JSP (1)
- Awk (1)
- Scripts AllOther (1)
- SNMP (2)
- TCP IP (1)
- Protocols AllOther (6)
- Networking Administration (5)
- Networking Security (1)
- Networking AllOther (1)
- Visual Basic (1)
- C Sharp (10)
- ASP.NET (74)
- ADO.NET (5)
- Crystal Reports (1)
- BizTalk (5)
- Dot Net Framework (13)
- Dot Net WindowsForms (1)
- Dot Net General (2)
- Dot Net AllOther (2)
- Exchange Server (5)
- Microsoft Related AllOther (2)
- Oracle General (5)
- Forms Reports (1)
- Oracle AllOther (3)
- SQL Server (21)
- MySQL (1)
- DB Administration (2)
- SQL PLSQL (15)
- Databases AllOther (2)
- SDK (1)
- Windows Threads (1)
- Windows General (4)
- Windows AllOther (4)
- Linux System Calls (2)
- Linux AllOther (3)
- Unix Commands (2)
- Unix General (8)
- Unix AllOther (2)
- Solaris Commands (4)
- Solaris System Calls (1)
- Solaris AllOther (2)
- Operating Systems General Concepts (3)
- Data Structures (1)
- WinRunner (24)
- Load Runner (12)
- QTP (64)
- Test Director (1)
- Rational TestSuite (3)
- Selenium (1)
- Automation Testing AllOther (5)
- Manual Testing (120)
- QA Concepts (7)
- Test Cases (9)
- Test Documents Reporting (1)
- Testing AllOther (17)
- COBOL (13)
- JCL (12)
- CICS (10)
- DB2 (13)
- IMS (2)
- IBM MainFrame AllOther (14)
- RPG400 (1)
- COBOL400 (1)
- DB400 (2)
- IBM AS400 AllOther (3)
- Core Java (36)
- Advanced Java (2)
- Swing (1)
- EJB (1)
- Servlets (6)
- Struts (5)
- JDBC (1)
- J2EE (1)
- Weblogic (2)
- Java Networking (2)
- Java J2EE AllOther (1)
- Middleware AllOther (2)
- HTML DHTML (1)
- XML XSLT RSS (1)
- Teradata (4)
- Business Objects (29)
- Cognos (8)
- Informatica (60)
- Ab Initio (4)
- Data Stage (12) SAS (97)
- ETL (6)
- Data Warehouse General (6)
- HR Questions (34)
- Design Patterns (3)
- Project Planning (1)
- VSS (1)
- SAP Basis (25)
- SAP ABAP (155)
- SAPScript (4)
- SAP SD (104)
- SAP MM (32)
- SAP QM (1)
- SAP PP (7)
- SAP PM (1)
- SAP PS (1)
- SAP FI CO (111)
- SAP HR (20)
- SAP CRM (17)
- SAP APO (2)
- SAP Business Warehouse (20)
- SAP Security (28)
- SAP Interfaces (1)
- SAP Netweaver (4)
- SAP ALE IDocs (2)
- SAP B1 (3)
- SAP AllOther (3)
- PeopleSoft Administration (1)
- PeopleSoft Tools (2)
- Siebel (4)
- Oracle Apps Technical (37)
- Oracle Apps Financial (21)
- Oracle Apps Manufacturing (2)
- Oracle Apps HRMS (1)
- Oracle Apps SCM (5)
- Oracle Install Base (1)
- Oracle Service Contracts (2)
- ERP CRM AllOther (1)
- Client Server Architecture (3)
- AI Tools (3)
- WebMethods (7)
- TIBCO (11)
- EAI AllOther (12)
- Change Request Management (1)
- Bio Informatics (1)
- Sciences AllOther (1)
- Electrical Engineering (12)
- Electronics Communications (5)
- Engineering AllOther (4)
- Business Administration (1)
- Marketing Sales (3)
- Banking Finance (7)
- Human Resources (4)
- IT Management (2)
- Non Technical (1)
- Business Management AllOther (1)
- Audit (4)
- CompanyAffairs CS (1)
- Taxation (8)
- Accounting General (90)
- Accounting AllOther (59)
- Call Centre AllOther (32)
- APPSC AllOther (1)
- General Knowledge_Current Affairs (4)
- Government AllOther (2)
- Everything Else AllOther (6)
- English (3)
- General Aptitude (47)
- Puzzles (6)
- Placement Papers (25)
- CCNA (2)
- Microsoft Certifications (2)
- Oracle Certifications (1)
- Certifications AllOther (2)
- L1 Visa (2)
- USA AllOther Visa (4)
- Australia Visa (1)
- C Code (4)
- GATE (1)
- GMAT (3)
- Scripts Errors (1)
