Search results for query: *

I have been searching the internet for two days trying to find info on this. I would like to create a report with a table that has parent-child relationship already showing. The parent and child should show row headers just like in Access. I have attached a screeen shot of an Access parent Order...

Does anybody know why SAS would connect 3 points in a plot like a triangle, instead of a straight line. Example in attached doc.

On 2nd review that didn't work. It selected all the records. But MIN(Id) should have the lastest date.

That works if I change MAX(Id) to MIN(Id) since the date field was sorted descending would put the latest date with the minimum ID.

That would only give me the latest 10 records for the query. I need the latest 10 records for each combination of the other two fields.

I am trying to find the latest ten records from a table on 3 fields. There can be a multiple number of combinations of the first two fields with each record having a date. Example: SELECT txtField1, txtField2, dtField3 FROM table ORDER BY 1, 2, 3 DESC This gives me all the records but all I...

I have a form that shows data from one table and uses the table's pk to filter the bindingsource of another table. I am currently geting the pk value from an invisible field on the form. Is there a way to get the value from the bindingsource or tableadapter's current record?

I have an Access Project that opens normally using Windows NT Authenication or User with Password. If I open the Add-in Manager or try to save a macro as a Module (convert macro to vba) it asks for my user name and password which is not the login credentials. It also is not the password I have...

Create a macro. Select Maximize as it's Action. Name it AutoExec.

They can also see the definitions of stored procedures that they have permission to Execute, but they can't modify them. As far as VBA modules go, you can set up a password so they can't see them.

I am trying to run a SAS program from a Windows command prompt that produces ODS HTML output. If I open SAS from the menu and run the program it displays the output in my web browser after the program runs. But if I run it from Windows command prompt it creates the ODS HTML file but does not...

Check out this SUGI tutorial: http://www2.sas.com/proceedings/sugi24/Internet/p189-24.pdf

From 2000BOL: Approximate number data types for use with floating point numeric data. Floating point data is approximate; not all values in the data type range can be precisely represented.

I have a stored procedure that calls another stored procedure depending on certain variables and is supposed to run that called procedure, come back and run another SP. The first call seems to run fine, but the second doesn't seem to work accept in debugger. Here is the SP: ALTER PROCEDURE...

Thanks guys, I appreciate the input. I have both SAS 9.1 and Enterprise guide 3.0 and I believe all the extra add-ins for SAS.

use the TransferText method of DoCmd: expression.TransferText(TransferType, SpecificationName, TableName, FileName, HasFieldNames, HTMLTableName, CodePage) DoCmd.TransferText acImportDelim, ,"tblReport", "C:\Txtfiles\April.csv

Is there a way in SAS to prompt for a file either with some kind of input box or by interfacing with the Windows API?