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 3450whenever 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 1706Post New Accenture SAS Interview Questions
What is the difference between Customizing and Workbench request?
Hi Masters, in Oracle Applications 11i, we hace 2 functions using the same form, i need to create 1 personalization, but that code must afect only one function.... how can i do that?
HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.
What is budget variance analysis?
How can a user be able to access only for Customizing requests even if assigned se01 and se10?.
why we use cascade control and feed forward control in 3 element drum level control measurement of steam drum .what is cascade and feed forward control system ?give example .
what are PEG transfection - parameters?
I’m the CEO of a Fortune 500 company. I make more in an afternoon than you make in a year. I don’t care about this stupid security stuff, it just costs time and money and slows everything down. Why should I care about this junk?
How to find the UNIT and VOLUME of a (a) KEPT (b) UNCATALOGED and (c) CATALOGED dataset - using (i) JCL and using (ii) ISPF ?
what do you mean .ota mobile format
what are the efficient way or solutions to avoid ABEND=S04C.
what will happen if outlet of electric pump is closed though pump is running?
Which environmental variables shows effect on marketing plan?
Why do we use Hadoop?
if i (outside from andhrapradesh) buy granite from a company in andhrapradesh on H form and i fail to give him the H form to the company what will be the tax liability to this company in andhrapradesh
- C (58)
- 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 (6)
- Forms Reports (1)
- Oracle AllOther (4)
- 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 (121)
- QA Concepts (7)
- Test Cases (9)
- Test Documents Reporting (1)
- Testing AllOther (17)
- COBOL (14)
- 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 (5)
- 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)
- USA Student Visa F1 Visa (1)
- L1 Visa (2)
- USA AllOther Visa (4)
- Australia Visa (1)
- C Code (4)
- GATE (1)
- GMAT (3)
- Scripts Errors (1)
