Search results for query: *

I'm having a little trouble googling around trying to figure out how to create on master SAS program that runs other SAS programs. The best I can find is the following:http://help.pop.psu.edu/help-by-software-package/sas/sas-tips/donald-miller-faq/ What is the best way to do this? I'm looking...

I have SAS 9.1.3, when I browse to a program and double click to open it, it opens in preview mode. Is there a way I can stop this? I'm not sure if it matters but enterprise guide is installed on my machine, I don't use it but I have it installed. Thanks, Austin

One that has me chasing my tail. This is a building block to a more complicated program I'm writing and something I found myself wishing I could do on more than one occasion. I want the data step to pass in a variable value into a macro that runs a query on another dataset, retrieves a value...

If I have two datasets with the same variable names and I want to compare a variable in dataset one to a variable in dataset two is there a way to specify which dataset I'm looking at? The only solution I can think of is changing all the variable names from one set to something else. Something...

Ok, I thought I had the sas date thing licked. I'm importing dates from CSVs into SAS datasets using the input function. So now I have number of seconds from 1960 or whatever. I thought doing comparisons on dates after this would be a breeze but it is not. I thought I would start by...

Writing my first program here. I have a csv file that I'm importing into SAS and then doing subsequent calculations to etc. Thanks to klaz2002 I know how to convert a char date to a SAS date. Now that I have my dataset made I am adding columns to it etc. I figure the best way to do this is...

I have a csv with date and time combined in the following format mm/dd/yyyy hh:mm:ss. I want to import this file into SAS and get it into a format SAS can recognize so I can do some manipulation based on date. My the closest I can get is this: informat timecolumn DATETIME; or this informat...

The following code only works when I activate and select the workbook and sheet it applies to. Workbooks(sWorkbookToSort).Sheets(sSheetToSort).Range("B2:C2").AutoFill Destination:=Range(Cells(2, 2), Cells(iMaxRow, 3)), Type:=xlFillDefault How could I get around that?

previously posted in the wrong forum. Sub BackupByDate() Dim dname As String, strTest As String dname = ThisWorkbook.Path & "\B" & Format(Now(), "yyyy_mmdd") strTest = Dir(dname, vbDirectory) If (strTest = "") Then MkDir (dname) ActiveWorkbook.SaveCopyAs dname & "\BK_" &...

Sub BackupByDate() Dim dname As String, strTest As String dname = ThisWorkbook.Path & "\B" & Format(Now(), "yyyy_mmdd") strTest = Dir(dname, vbDirectory) If (strTest = "") Then MkDir (dname) ActiveWorkbook.SaveCopyAs dname & "\BK_" & Format(Now(),"hh") & "." &...

Hello, I'm trying to move to class modules and start doing more OO programing. I'm missing something big here on my first try. I thought I would make a simple class called list with a method that looked for a some data in a spreadsheet and who's attributes included the first and last row of...

Dim offerTime As Date Dim i As Integer Dim temp As String offerTime = #12:00:00 AM# temp = "" For i = 1 To 24 temp = temp & DateAdd("h", i, offerTime) & " ," Next i Debug.Print temp output 1:00:00 AM ,2:00:00 AM ,3:00:00 AM ,4:00:00 AM ,5:00:00 AM ,6:00:00 AM ,7:00:00 AM ,8:00:00 AM...

Function returnRawCurveSet Set rawCurveSet = New ADODB.Recordset rawCurveSet.Open rawCurveSQL, CurrentProject.Connection, adOpenKeyset returnRawCurveSet = rawCurveSet end function subroutine Dim rawCurveSet2 As ADODB.Recordset rawCurveSet2 =...

Maybe getting too carried away here but can I programatically declare variables that are fields in a recordset? The following code does not work. For k = 0 To minSet.Fields.Count - 1 dim minSet.Fields(k).name Next k

Can't figure out how to call a function that returns an array in the VB within access. Is this possible?

Never coded in php until today. The following code: <?php $to = "recipient@example.com"; $subject = "Hi!"; $body = "Hi,\n\nHow are you?"; if (mail($to, $subject, $body)) { echo("<p>Message successfully sent!</p>"); } else { echo("<p>Message delivery failed...</p>"); } ?> produces the...

I'm moving from asp to php. I have a for profit project that I am going to use as a learning project. What are your top recommended sources for a newbie like me. Syntax etc. is usually pretty easy for me to pick up. What I really am looking for is a good site that has good...

I'm researching hosting for an ASP site for a page a small business wants me to put together. I've never actually had to worry about the hosting etc., and the company I did do ASP work for would never have allowed me to set up something that automatically sent emails out due to security...

I have about 8 months or so worth of experience enhancing a database driven ASP website using vbscript. I inherieted a running site that lives on a company server. I have been approached by a small business to stand up a small database driven website for them. I would love to take on this...

I have another one of my crazy innovative ideas that has probably been done a million times in a million better ways, but I can't find on the net or in my o'reilly books. I have a lot of forms. A loooot of forms. Each form has one subform. The main body of the form is the same, the subform...