Hi I have two data sets that i want to merge. The first is called Common and the second is Link and they both have a common key "Index". Common is sorted by index but there are multiple rows in Common with the same index whereas the each row in Link has a unique index. I only want the information in Link to merge onto the first unique index and blank for other rows in Common where the index is repeated. Example below: Common Index Field2 Field3 1 1 1 Link Index Field3 1 100 2 200 3 100 Merged File I Want Index Field1 Field2 Field3 1 100 1 0 1 0 ... View more

Hi Quick question I have a small sas program that runs 'proc sql; create table' procedure which runs perfectly when I open the program and run it but when I try to call it using %include call(Reconciliation), I get an error message saying "Truncated Record" and "Syntax Error" Since it works fine when I open up the program and run it rather than calling it from another program I assume it is something to do with my %Include... code. Any ideas? Many thanks ... View more

I want to set a variable called purpose, e.g.: %LET PURPOSE = CHANGE ; /* PURPOSE can only take the words CHANGE or PROFIT */ If it is set as CHANGE I want it to skip a bit of code and run a bit of code after it. If it is set as PROFIT I want it to skip the last bit of code and run the code before it. How do I do this within the same Sas Program without having it call a separate SAS program using a call function? ... View more

I'm trying to create a macro that creates a table showing the last Friday of every month. The table will look like this: So, if i select a range of years, say 2001 to 2013 it will create a table like this: YEAR MONTH LASTFRIDAY 2013 02 22 2013 03 29 2013 04 26 2013 05 ... 2013 06 ... 2013 07 ... 2013 08 ... ... ... ... ... including all the years in the range I specify. ... View more

For some reason, I can't paste sas code in the discussion forum - others seem to be able to do this. It's very tedious typing the code in each time I have a query. Same with excel tables. ... View more

I want to name a dataset as today's date. I know you can name a variable within a dataset as today's date useing the today() function but how can you name a file using today's date. My dataset is called Reconciliation I want something like this: Reconciliation20140709 or Reconciliation_20140709 Many thans ... View more