• New to SAS need date equivelant for script in proc SQL

    I need what the SAS equivalent for this is: to_char (COLLECTION_ENTRY_DATE,'month/yy')as Entry_Month_Y,to_char(COLLECTION_ENTRY_DATE,'DD')asDAY_entry. I have tried putting COLLECTION_ENTRY_DATE,monyy5.) and different variations but without success can you advice? Full script is: proc sql; create...

    cyrus20075 pointsBadges:
  • Knowledge management (KM) system for large organization?

    We are a large non-profit organisation (20,000+) with many individuals producing minutes and summaries from internal and external meetings, parliamentary debates, conferences, etc. We are considering to implement a Knowledge Management system, which should allow local users to enter summaries...

    RBS5 pointsBadges:
  • Installing SAP on Windows Vista Basic

    I have a NP Pavilion D5-1002TU laptop using Windows Vista. Now I want to install Windows XP to install SAP but HP customer care said that Windows Vista isn't supporting any other operating systems. Is it true? If yes, then how can I install other operating systems on Windows Vista? Also, is it...

    2897508940 pointsBadges:
  • Updating an invoice already posted

    If I have an invoices already posted and while using a Supply Chain Finance (SCF) company the SUPPLIER allows a discount for early payment. Is there a way to update the invoice that has already been posted in my system to reflect the agreed changes to DUE DATE and AMOUNT by using an IDoc (in other...

    markvdm5 pointsBadges:
  • Linux kernel upgrade

    How to upgrade kernel in Linux 4.?

    Linux45 pointsBadges:
  • Lower cost business intelligence tool

    I'm running a small business, I need cheap and efficient BI Tool. What should I use?

    Aana125 pointsBadges:
  • Double iDocs are generated

    IBAN maintenance during dialog processing within Tcodes XD02/XK02 /for Customer/Vendor bank details are creating double iDocs.

    iabapuser5 pointsBadges:
  • can not find database dll

    How to fix "can not find database dll"

    AppMgr5 pointsBadges:
  • how to fix ” cannot find database dll”

    how to fix " cannot find database dll"

    Nilanka1355 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • Converting string into number in Crystal Reports

    I have a crystal report that I have pulled a user defined field from Visual (our ERP system) into. The user defined field is a string. I want to subtotal these numbers but since they are string they are not subtotaling. I have tried Tonumber {(workorder_Userdefined field 10)}. It says there no...

    Vickie5320 pointsBadges:
  • AutoCAD 2007 coordinate specification

    Can a object be selected using a relative end point be moved to a absolute coordinate system point

    FredWS5 pointsBadges:
  • Avoid duplicate entry in database through Visual Basic 2005

    I have made a program in VB 2005 with SQL 2005 as back end. In the data base there are three fields which are unique id of a person. I want to display "Already Exist" message box when I enter an already existing id. matching all three fields and not allow duplicate entry.

    Sukas10 pointsBadges:
  • Criteria not appearing in Crystal Reports

    Why records that meet criteria are not appearing in report

    Eastmank5 pointsBadges:
  • Linking in Crystal Reports 8.5 and 11 question.

    I currently have a report written in Crystal Reports 8.5 and I need to left join some tables. When I change the tables to left outer join I get these error messages stating: General SQL Server: Check Message from SQL Server and Error Detected by Database DLL. When I revert them back, the report...

    Metalteck5 pointsBadges:
  • Extra columns on export to EXCEL

    How do I avoid the extra columns upon Crystal export to EXCEL?

    Bozotheclown10 pointsBadges:
  • export to ms excel

    I get extra columns when exporting to MS excel. It appears there is an extra column every time there is a sub report

    Mstang19875 pointsBadges:
  • Stop crystal prompts for parameter value

    Hi, I created a crystal report with SQL Server stored procedure. I passed the parameters using VB 6, all parameters were fine except one of the DateTime data type, when I ran the report it kept coming up with the "Enter Parameter Values" dialog box, is there any way I can get rid of it? Software...

    QM5 pointsBadges:
  • Rretrieve date, time a job held

    Is there a way to programmatically retrieve the date and time a job was held? I've checked RTVJOBA and a variety of job-related API's but find nothing.

    WoodEngineer6,875 pointsBadges:
  • How to convert .WCM video file to any other video format?

    How can I convert .WCM video file to any other video format like mp4, avi, flv?

    zeeshanmalik5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following