It is odd that the first proc contents worked while the second did not.  I'm guessing ASPCCR is a stock SAS library while TRIAD is a SAS/Access libname. Why are you using %BQUOTE()? All macro variables are strings, no need to try and "quote" them (which has a different effect in SAS Macro language). Try %syslput rmonth=&month; If for some reason you must use %BQUOTE() then at the rsubmit rsubmit; %let rmonth = %unquote(&rmonth); Richard in Oz ... View more

If you are only interested in readmissions, and there can only be a single readmission per patient, then this will do it in one pass Proc SQL ;     Create table readmit as         Select    adm.ID             ,    adm.Diag             ,    adm.ReadmitID             ,    rad.Diag    As    ReadmitDiag             ,    case (rad.Diag)                     When (adm.Diag)                         Then    'Y'                         Else    'N'                     End                             As    Match         From    admit    adm               ,    admit    rad         Where    rad.ID    =    adm.ReadmitID                 ; Quit ; However, if you want a more general solution where the possibility of multiple readmissions exists then it would be better to recode the readmission ID to match the original admission, then process the resulting dataset for non matches.  If this is the case, I could suggest some code. Richard in Oz ... View more

From the documentation I would not expect you to be able to access a directory using the URL option.  But I do not have access now to a setup I could check this on.  You say you have been able to connect to another host with this syntax;  maybe there are file or directory permissions which differ. Another tack I have used in the past is to use an external ls command with the ouput piped to a named text file.  You can read the filenames into a table and proceed from there.  I have not tried that with a URL but it might be worth examining as an option if other methods fail. Richard in Oz ... View more

Is PATH1 the name of the file you are trying to access?  If so, try filename myfile url "http://host:81/PATH1"; (ie without the final /) or if there is an extension (like .html) include that explicitly. But if not you may need to explicitly name the file.  The SAS UNIX documentation states The URL must be in one of these forms: http://hostname/file http://hostname:portno/file Richard in Oz ... View more

My big concern with the data is that there is no unique key combination.  Initially I thought that missing values for DISTCD (not just a few - most are missing) did not matter because I could find the corresponding value of PERMNO but that did not work because it proved to be a many to many relationship.  It seemed at first from your data that maybe there was an implicit order, PERMNO and then DATE but even that failed in the second data set.  It would worry me that you are trying to calculate a fairly complex result from data that is so shaky.  I urge you to make sure the data is clean before you calculate and use these results. Richard in Oz ... View more