Recent content by Asender

Hi there. I have a spreadsheet which looks roughly like this: Available Location Trigger1 Trigger2 Trigger3 Trigger4 Y File1 MEM1 MEM1 Y File2 MEM2 MEM2 MEM2 Y File3 MEM3 MEM3 N File4...

Here is another option to consider: data skipped; length MyID $ 10; infile 'c:\6411skipped.txt' scanover missover; input @ ':' MyID $10.; run; A.

Hi Zenith. Based on the specific example you have given I came up with this: proc sql; create table RESULTS as select a.week, a.day, price, b.meanp from TEST a...

Chris. Sorry for posting again so soon. I think I understand what is going on. Even though the macro (email020) is being called from within another macro (Report1 or Report2), code within the %inc is being resolved in open code. Try adding this %let to (program2): *** PROBLEM2...

Hiya Chris. Thanks very much for replying. I must confess that I have already considered and dismissed the global declaration solution. True, the code now runs with no compilation error, but if you examine the new log you will see that the macro variable email has the same value ('2' - the...

Hi. Can someone please explain why macro variable email is not resolving? Here is some code the generates the WARNING. *** Program 1 ***; %macro report1; %let email = 1; %inc dev(program2); %mend report1...

Can you not just use modified list input? (I think it's called that) data ThreeDates; input Date1 :mmddyy10. Date2 :mmddyy10. Date3 :date9.; Year12 = yrdif(Date1,Date2,'Actual'); Year23 = round(yrdif(Date2,Date3,'Actual')); format Date1 Date2 Date3 date9...

Hi Chris. Thanks for the reply, I kinda thought as much. Unfortunately where I am contracting at the moment getting any changes to the mainframe set-up would require some sort of Satanic Ritual, possibly with a Virgin Sacrifice. At this time all the virgins are needed for coding. Anyway, as...

Hi everybody. I am FTP'ing a dataset from mainframe to PC (csv) with a literal text strings as headers. Once of the headers contains a £ character. However, this is being converted to a $ during the transfer of the data. I need to keep this £ as a £, can anyone help? Kind Regards, Chris...

Hi Klaz. I'm glad I'm not the only one stumped. I think the order of evaluation must have something to do with it. Check this out: first = second + third + fourth; gives (first, third, second and fourth). however, first = second + (third + fourth); gives (first, fourth, third and second)...

Hi there. This is more a curiosity that a problem. Most experienced SAS programmers will be familiar with the concept of the Program Data Vector (PDV) and how SAS populates it with variables as a SAS Data Step is compiled. This little excerpt from a SUGI paper sums up how I understand it...

Hi. Apologies first for a long post. I am calling a macro from a dataset which contains the locations of several SAS logs. Once the log has been checked I create a macro variable which I want included in the subject field of an email which is created within the macro program. My problem is...

Hi Klaz. Thanks very much for the reply. Yip, remove the %str and Bobs your uncle. I had to initialise the macro variable list1 with a %let list1= in order to get rid of the last error. Believe it or not, I did come up with the proc sql solution myself (I must be getting better at this...

Hi all. Can anyone help me with this problem. I am attempting to create a macro variable that is constructed from the variables names in a target dataset. The code I am using is pulled from the following document. 'Comparing 2 SAS Data Sets: An alternative to Using PROC COMPARE' The...

Hi all. Weird. When I got home from work, the original keyboard worked fine. I think the 'phantom spiller' is looking more likely. Thanks to all for your help. Regards, Chris...