Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. bkclaw113

    MS Access install reference library error name conflicts with existing

    I believe that the mid and replace functions are contained within the "Visual Basic for Applications" dll, but it would be helpful to list what references you do have so that we can try to help resolve the conflict.
  2. bkclaw113

    Create Chart in Form/Report Using VBA

    This may not be a good option if your series are robust, but have you considered pushing the data from your query into excel and using the an excel range to add the series to your Access chart? I have not tried this myself but it may be a different approach to try.
  3. bkclaw113

    How to avoid product join??

    In general when your explain showes that you have a product join you have ommitted the join criteria between 2 tables, go back and examine your Where/On statements and make sure that the join criteria between each table is there.
  4. bkclaw113

    Multiple Counts Issue

    You have hopefully figured this out by now, but if not....try this Select colA , colB From ( Select colA From myTable Group By colA ) A Inner Join ( Select colB From myTable Group By colB ) B On colA = colB
  5. bkclaw113

    What is equivalent of oracle (+)= in Teradata

    I am not real clear on what you are trying to do and since I am not an Oracle user I cannot fully decipher what your original code is attemping, generally speaking a verbal description would have been easy to work with. That being said hopefully what I provided below will at least give you the...
  6. bkclaw113

    How to import data from Excel

    If you only have Excel and no other tools then I would suggest creating an empty table in Teradata and using VBA to establish a connection from Excel to Teradata. You can then use VBA to load the data. Below is some information that you would need to manage the connection (it executes SQL...
  7. bkclaw113

    theoritical question

    Your question is very very vague, if you ask a more direct question about a specific scenario or query people may be better able/willing to help. Teradata has a ton of documentation available on there web site, you may want to read through...
  8. bkclaw113

    How to do join in Teradata

    This may not be helpful, but did you turn on diagnostic stats and run the suggested collect statistics? "Diagnostic Helpstats On for Session;" Then run your explain, and at the bottom it should suggest statistic to collect to help optimize the query.
  9. bkclaw113

    Getting Recent 3 dates

    Thanks joedsilva, obviously there is still more that I need to learn about using the order analytic functions, I have never used a QUALIFY clause before (nor did I realize it was available) but I will definately be using it moving forward.
  10. bkclaw113

    Getting Recent 3 dates

    From my experience one of the most powerful and most underused areas of SQL is ordered analytical functions. The code below uses the order analytical rank function to provide the results that you were looking for. I know it may seem like overkill since you figured out a more basic way to...
  11. bkclaw113

    Set Category (X) axis Lables

    I am not have any problems with the DataLabel, I am able to set these without issue. I am not able to find an object or property in VBA that controls the Category (X) Axis Labels.
  12. bkclaw113

    Set Category (X) axis Lables

    I am not have any problems with the XValues property, I am able to set this without issue. I am not able to find an object or property in VBA that controls the Category (X) Axis Labels.
  13. bkclaw113

    Set Category (X) axis Lables

    Any suggestions on how to use VBA to set the Category (X) Axis Lables on using VBA? When creating a line (xlLineMarkers) chart in Excel using VBA I am not able to program the X axis lables. By default my chart just lables the X axis with 1 - n to represent the number of data points. I tried...
  14. bkclaw113

    Show tables in database

    I do not know of any command that works across all platform, but most platforms that I have worked with (Oracle, Teradata, SQL Server) all have a system database which you can query to get the names of all tables. What platform are you looking to accomplish this with?
  15. bkclaw113

    SQL Type View

    Does SAS have the ability to create a view (or query) like you can create within a typical Database application (SQL Server, Access, Oralce, ...)? I have multiple sas datasets all sorted with the same ID that contain similar data (claim_count, total_spend, etc..), but the fields within each...
  16. bkclaw113

    Identify computer

    Works just like you said it would. Thanks for the quick response.
  17. bkclaw113

    Identify computer

    I am trying to find a way to have SAS identify the computer name where my code is being executed, and then depending on what computer the code is running on I can have conditional statements to setup the correct paths for my libraries. This will allow the same code to be run either on my PC, my...
  18. bkclaw113

    Empty data set

    Maybe a little late to help you Queryman, but maybe someone will need this. %if %sysfunc(exist(work.port&YYMM0.)) %then %put port exists; The exist function checks for the existance of a SAS dataset (fileexist does the same for a fileref) and returns 1 if the file exist and 0 if not.
  19. bkclaw113

    How to submit batch jobs in SAS Programming using task scheduler

    Here is the code that I have adapted. I am still in the testing phases of my end application, but the idea is that I use VBA to check for the existence of certain required files and windows folder structure. If they are not in place then VBA will either warn the user or create the needed...
  20. bkclaw113

    How to submit batch jobs in SAS Programming using task scheduler

    dmksas, please post your method for using vbsrcipt and Windows Scheduler. I have been playing around with using VBA to run SAS with some success, but I am always interested in seeing new methods.

Part and Inventory Search

Back
Top