Search results for query: *

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

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

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 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 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. I'm running XP Home. Tried to log in this morning and discovered that my password was not being accepted at the log in screen. So I logged into my kids logon and booted up Word. Typed in a few keys only to find that gibberish was being generated. e.g. hitting the 'J' key would...

Hi All. I have a problem with that attached code.(see bottom of post) I’m creating a dynamic WHERE statement based on the values I find in the macgen dataset. This works fine in a ‘normal’ SAS data step, however when I attempt the same in my SQL DB2 pass thru it spits out the following –...

Hi everyone. I hope you don't mind me posting a SCL problem here. For the past few weeks I have been working on an SCL application (Mainframe OS390). A 'simple' database with various bells and whistles on. I have now run into a wee problem. One of the programs has a field on it that kicks of...

Hi all. I’m looking for a solution, if one exists, to a problem that I need to solve. The basic premise behind what I am trying to do is the evaluation of how much money has been paid out under a record number. This record will pay an amount out from a start date in the past to the current...

Hi everybody. I'm looking for a bit of code that will concatenate a series of variables that have been generated by a proc transpose. i.e. Col1, Col2, Col3......Colx The catch is that the number of variables to concatenate will change everytime the job is run. I'm trying to remove the need...

Hi all. Can anyone explain why the does not work : data AS.DATE_FILL; set AS.SORTHIST; by POLICY; if not first.POLICY then do; if date6 = . then...

Hi there. Can anyone come up with a bit of code which would achive the following: I have a dataset which contains 44 variables. MRPOLICY KEY COMCOM1 COMCOM2.......COMCOM42 I need to search through all the COMCOM variables (1 to 42) for a certain string say 'SINGLE'; I can code the...

Hi folks. I frequently deal with datasets in the folling format: OBS POLNO UNITS PRICE FUNDNAME VALUE 1 K1 100 5 MANAGED 500 2 K1 200 10 EQUITY 2000 3 K1 10 1 WITH PR 10 I...

Hi. As a relative newbie to SAS programming I'm just getting to grips with some basic sql. We all know that when we use a LEFT or RIGHT join in sql we must use 'ON' rather than 'WHERE'. Does anyone know the reason why? Regards...