Search results for query: *

Now i've discovered %include, for some reason that was hard to harvest from the interwebs.

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

Thanks Klaz, sorry for the late thanks. My wife and I had a baby and then some huge multi week fires at work. Just now booting up SAS for the first time in months. So far Enterprise has done nothing but cause problems for me, some code that works in 9.1 won't work in Enterprise, debug won't...

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

I don't follow. I'm not too familiar with macros or macro variables so that is problem number 1 with me not following. If i'm on a datastep and want to write a value to the vector that is based on a lookup to another dataset that is dependent on a variable in my current vector I'm not sure...

Well you could be right, using kdt82 suggestion gets me the exact same results.

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

Thanks for the response, I'm using a similar method I found googling around. I still don't have this macro language down. Thanks again. %macro rename(lib,dsn,suff); proc sql noprint; select nvar into :num_vars from dictionary.tables where libname="&LIB" and memname="&DSN"; select...

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

I'll keep that in mind, when you need to do a comparison against the whole timestamp how do you bring the two together?

My solution to the first problem was using (format=datetime20.) the solution to my second problem was I was using a macro variable and didn't have the &. Thanks

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

Thanks Chris, so obvious I didn't even know.

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

That seems to do the trick. Thanks. Any good resources you could recommend that explains all the behind the scenes and in front of the scenes dates stuff?

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

ahhh shoot, that was it. I should've figured that out.

Skip, thanks for the response. I thought I responded to your response but must have clicked the wrong button or something. I'm still having a problem. This works: Workbooks(sWorkbookToSort).Sheets(sSheetToSort).Activate Workbooks(sWorkbookToSort).Sheets(sSheetToSort).Select With...

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?

I didn't think about that, good point, thanks.