Every value in the macro language is a string.
So you should not use quotes for the variable values, unless of course the value contains quotes.
... View more
One statement would be something like
%put rc = %sysfunc(rename( &FILENAME
, %substr(&FILENAME, 1, %index(&FILENAME,_)-1)
, file));
when the filename is stored in a macro variable.
... View more
Windows manages files in a more basic manner than Unix does, and normally locks files being written. It's very likely that Windows denies any access requests by processes other than the one writing.
... View more
Something like this?
*Test needed because some people take surveys 30 days after last one, since windows are 30 days apart;
if 25 <=INTERVIEW_DIF <= 45 then CORRECTION=1;
else if 45 < INTERVIEW_DIF <= 75 then CORRECTION=2;
else if 75 < INTERVIEW_DIF <= 105 then CORRECTION=3;
etc..
if CORRECTION then do;
if VRID_3MO ne "" then INTERVIEW_AGE = (AGE*12 + CORRECTION );
else if VRID_6MO ne "" then INTERVIEW_AGE = (AGE*12 + CORRECTION + 3);
else if VRID_9MO ne "" then INTERVIEW_AGE = (AGE*12 + CORRECTION + 6);
end;
... View more
> I cannot access the logs produced by that job until it is complete What message do you get? Please describe what happens. You should be able to see the log.
... View more
There are various menu entries iirc. Have you tried them? I don't remember the exact phrase, but something like Sent to or Open with or View with.
... View more
If you want to transfer the files, you can compare the data inside using proc compare. If you want to compare before transferring, or if you want to just use the OS on exactly identical files, you can compare the files' checksum (the SHA-256 hash values).
... View more
@Kurt SPDE is also great to speed up IO thanks to its much better compression algorithms and better indexing, even if just one directory is used.
... View more
If all files are in the same directory, list all the files in that directory (see the pinned topic https://communities.sas.com/t5/SAS-Programming/How-to-List-all-the-files-in-a-folder/m-p/674065#M202918) and get the size of all component files. Don't forget index files if applicable. Note that you can use the PARTSIZE option of LIBNAME SPDE to avoid splitting the data into multiple files.
... View more
