How can I have a header span ALL the column in a report.  All the examples I've seen show a blank column in column 1. Thanks, Steve ... View more

I've got several .sas files that I want to copy from one directory on the server to another.  I've got code like below that works fine, but each time it opens up the command window and I have to type 'quit' in each window to get it to go to the next one. %let fromdir = Dev ; %let todir = Test ; %sysexec copy "\\my_server\&FromDir\Program 1.sas"  "\\my_server\&ToDir\Program 1.sas"  /y ; %sysexec copy "\\my_server\&FromDir\Program 2.sas" " \\My_server\&ToDir\Program 2.sas  " /y ; I'd be happy to create a .bat file to do this but I'm not convinced that I could get it to work.  When I type the command at the command prompt it says that it cannot find the file specified.  I've tried this with quotes and without quotes and with files without spaces in their names.  I guess I could map a drive letter to the path that I need and get the copy command to work in a .bat file, but if there's another way to do it using SAS so that the command window doesn't open up and have to be closed each time, I'd appreciate your telling me. Thanks, Steve Steve James Centers for Disease Control and Prevention ... View more

It's taken me a while to figure out what was going on, but I have proc report code that was generating tons of messages that said WARNING: Illegal argument to function Turns out I was using leading_zero='yes' option on my msoffice2k_x tagset and it generates the warning when a variable has a missing value.  Perhaps not for all variables but at least presumably for those which could have a leading zero.  Consider the code. data temp ; input Var1 $2. ; datalines ; 00 01 00   00 ; run ; ods tagsets.msoffice2k_x file="Temp.xls" style = sasweb options(leading_zero="yes") ; proc report data=temp nowd missing ; columns var1 ; run ; ods _all_ close ; It generates one such message.  However when I ran it on the real code I was using it generated enough messages that I had to break out of it.  Any way around it? I'm running SAS 9.3 on a Windows 64 server.  thanks, Steve ... View more

I have a very large dataset (69 million rec) that I need to merge with a relatively small dataset (28k recs).  I found proc sql took too long so I tried to create a merge using a SAS hash object.  I wrote the following code to do that.  I wanted to verify that everything was merging OK so I created a counter to increment every time there was a match.  I expected the counter to match the number of observations in the smaller dataset.  The dataset LiveDoseViolations has 27,542 observations in it but when i run the code the counter has the value 28,428.  I don't know how that could be the case nor do i really know how to figure out why.  Any ideas? data LiveVirusValidatedData (drop=LiveDoseViolations) ; if _N_ = 1 then do;      declare hash h(dataset:'LiveVaxViolations') ;      h.defineKey('cdcid','VaxRecordNum') ;      h.defineData('DoseValidity');      h.defineDone();      length CDCID $30 VaxRecordNum 8 DoseValidity $15 ;      call missing(DoseValidity) ;      end; set FullyDeDupedData end=lastob ; rc = h.find() ; if rc = 0 then LiveDoseViolations + 1 ; if lastob then call symput('LiveDoseViolations',LiveDoseViolations) ; run; The log is below: 4491 + 4492 +data LiveVirusValidatedData (drop=LiveDoseViolations) ; 4493 + 4494 +if _N_ = 1 4495 +then do; 4496 +     declare hash h(dataset:'LiveVaxViolations') ; 4497 +     h.defineKey('cdcid','VaxRecordNum') ; 4498 +     h.defineData('DoseValidity'); 4499 +     h.defineDone(); 4500 +length CDCID $30 VaxRecordNum 8 DoseValidity $15 ; 4501 +     call missing(DoseValidity) ; 4502 +     end; 4503 +set FullyDeDupedData end=lastob ; 4504 +rc = h.find() ; 4505 +if rc = 0 then LiveDoseViolations + 1 ; 4506 +if lastob then call symput('LiveDoseViolations',LiveDoseViolations) ; 4507 +run; NOTE: Numeric values have been converted to character values at the places given by:       (Line):(Column).       4506:49   NOTE: There were 27542 observations read from the data set WORK.LIVEVAXVIOLATIONS. NOTE: There were 69646012 observations read from the data set WORK.FULLYDEDUPEDDATA. NOTE: The data set WORK.LIVEVIRUSVhasALIDATEDDATA has 69646012 observations and 86 variables. NOTE: Compressing data set WORK.LIVEVIRUSVALIDATEDDATA decreased size by 73.23 percent.       Compressed is 932110 pages; un-compressed would require 3482302 pages. NOTE: DATA statement used (Total process time):       real time           6:41.41       cpu time            6:37.80 4508 + 4509 +%put NOTE: there were &LiveDoseViolations Records found with Live Virus Violations ; NOTE: there were        28428 Records found with Live Virus Violations 4510 +%put Note: This should match the # of observations in Work.LiveVaxViolations ; Note: This should match the # of observations in Work.LiveVaxViolations 4511 + ... View more