Search results for query: *

Hi, I'm having a problem with a query and was hoping someone could help me out. I have 3 tables each with the same key. Table 1 - List of Customers (500 rows) Table 2 - Usage (500 rows) Table 3 - Status (400 rows) I attempted to do this: Select a.* from customers a left join usage b on...

Hi All, I have a problem, I need to select the max value of a row and get the field(s) that its associated to. Example: ID MONTH1 MONTH2 MONTH3 MONTH4 MONTH5 MONTH6 1 22 33 32 56 234 234 I need to be able to select and retrieve ID, MONTH5 and MONTH6 (not the values but...

Hi, I am attempting to set up an environment where users can update the same table concurrently. I know that in order to do this I have to use SAS/Share if they are SAS datasets. But we also connect to an oracle library which then does not need SAS/Share. Is it possible to use Proc SQL to do...

I have a table where the date column has some data that is not formatted correctly. How can I update this column? I tried: proc sql; update customer set datefield = datefield format=mmddyy10.; quit;

Hi I want to take a datetime field and reformt it so it looks like 'YYYYMM'. Is this possible in SAS?

I need to know if it is possible to share datasets between users. I know that SAS/SHARE exists, but can't find much information regarding it. Can SAS/SHARE run on a regular desktop with Windows XP or does it require a server? Is there any other method of sharing a dataset besides SAS/SHARE?

I have a PROC SQL query that goes like the following: PROC SQL; SELECT * FROM TABLE1 WHERE START_DATE BETWEEN (beginning of last month) TO (end of last month); QUIT; How do I do this? The base date I want to manipulate is sysdate. Thanks

I have a macro that reads a filename and then I wish to use substr and index to grab specific parts of the filename. %macro test %let campaign_code = %substr(&filename,1,8); %let campaign_cycle = %substr(&filename,10,1); %let month = %substr(&filename,12,3); %let year =...

I have a file that requires importing. The filename is relevant to the program so I would like to take that filename and extract parts of it and place them in variables. The filename changes so it cannot be hardcoded, is there a way to bring the filename in dynamically?

%macro test; /* %let to_day = input(%substr("07feb07",1,2),2.); %let to_month = %substr("07feb07",3,3); %let to_year = %substr("07feb07",6,2); */ proc sql; select ccdate, ccend_date, DM_EXCLUDE_UNTIL_DATE INTO : cstart separated by ' ', : cend separated by ' ', : cexclude...

Please correct me if I am wrong, data steps/proc statements are unique to SAS, Macros are equivalent to functions in other languages. Now, besides surrounding code statements with data steps/proc/macro is there a way of just coding if statements and other functions in SAS?

Ok, so I come from a VB/VBA background and am wondering how to manipulate dates. For example, if I wanted the week of the current month, I would write format(now(),"WW") in vba. Is there similar functionalities in SAS?

Please help me! this is the last part I need to figure out for this program(crossing fingers) When I import the csv file there are dates in the format of "ddmmmyy" What i'm planning on doing is an import of the csv file into dataset that exactly mimics another table. Then to do a merge so...

Here's what I need to do. I need to create a temporary dataset taking data from a csv file which I have done. Next, I need to loop through this dataset and insert some values into a table. I cannot seem to figure out how to loop through a dataset nor to get the values from the dataset into...