Search results for query: *

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.

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.

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.

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

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...

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...

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...

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.

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.

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...

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.

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.

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...

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?

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...

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

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...

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.

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...

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.