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 3215whenever 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 1538Post New Accenture SAS Interview Questions
all c language question
What is Difference between Auto Copy Journal and recurring journal?
1) What are your personal strength? 2) What are your personal areas of improvement? 3) What are your expectations from from a particular job? 4) what are your carrier objectives?
Explain real scenario your faced in the implimentation project?
You have 3 snd sample of different FM=0.21,FM=0.95,FM=2.90 which one is suitable for a)plastering on R.C.C b)plastering on masonary wall c)concreting column d)concreting of bored pile.also justify your answer.
What is Hardware Drivers?
In Over time scenarios we have TW15 subschema,my doubt is it's work for positive time or negetive time,if it is negetive ,In pa30 how to maintain hours in 2002 with attendence type ,my doubt is few hours like 14 or my dws is 8 hours(S) and 6 hrs in 2002 how and how the pcr's work please explain me anybody......
the TDS rates and Income rates are equal in calculation of the salary and please send the IT slab rates for the employees and comapnies.
Tell about yourself and job ?
What are the major responsibility's of an accountant? what are the qualities he /she requires?
one server is down it doen't display anything what you do?
Hi, If any body having any idea about "Riliance infocom Business Management papers ..... " I got a call for the same....
Which kind of agent architecture should an agent an use? a) Relaxed b) Logic c) Relational d) All of the mentioned
What are the causes of dirty lubricating oil?
Content show on same page with navigation clicking. What is the jQuery code for the same.
- 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 (119)
- 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 (110)
- 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)
