To make it simple and be on the safe side, stop sll services which has SAS in the name. ... View more

Hi:   Yes, you are correct. IF c:\wombat exists, that would be an acceptable solution. IF, however, c:\wombat directory did NOT exist, then you would get the same error message. cynthia 1    FILENAME _TEMP_ "c:\wombat\something.html"; 2 3    ODS LISTING CLOSE; 4 5    ODS CHTML FILE =_TEMP_ RS=NONE; NOTE: Writing CHTML Body file: _TEMP_ ERROR: Physical file does not exist, c:\wombat\something.html. WARNING: No body file. CHTML output will not be created. ... View more

Depends on what you mean by "import".  If you just have text files then I would just "input" them and would not bother with using any import functionality. 1) If the file names follow a simple pattern then just us a wildcard in the filename specification. data all ;   infile '*.txt';   input column1 ; run; 2) If you have a static list of filenames then build a FILENAME statement. filename myfiles ('one.txt','two.txt,'three.txt','four.txt','five.txt'); data all;   infile myfiles;   input column1; run; ... View more

I do not think your issue has anything to do with INFILE vs DATALINES (ie CARDS). The name DUMMYF is just a dummy name because the INFILE statement requires a filename even when the actual filename is coming from a dataset variable because of the FILENAME option. Your program is using the variable PN as the name of the file to read. It is getting the value of PN from the variable PROGRAM_NAM that it reads from the dataset SEARCH_HITS. It looks like PROGRAM_NAM does not contain the path to the file, just the part after the last slash and it is trying to find that file in your current working directory.  If you have a path some where (perhaps in PATH or FULL_PATH variable?) then use that when building the variable PN that you are telling the INFILE statement to use.  Perhaps you want: pn = cats('\',path,program_nam); or pn = full_path; ... View more

If after doing a PROC SETINIT you have SAS/ACCESS to Teradata installed - I used to connect to teradata this way where UPPERCASE are required and lowercase are my names. LIBNAME tst TERADATA TDPID="10.2.123.456" USER=myuserid PASSWORD=mypassword SCHEMA=dbschema; ... View more

I had half anticipated what you wanted, and loaded the physical names - then released CODEDIR Either you you remove the last call execute() statement      call execute( 'FILENAME CODEDIR ;' ); * to release the fileref ; or adapt your data step. CODEDIR returns the bare path and filename. The following code works onn WIN and UNIX platforms, but not on zOS and probably not on VMS I would suggest you adapt your process. Parsing the lines returned by CODEDIR  might be easier with the scan() function filename = scan( line, -1, '/\' ) ; * neither / not \ will appear in filenames you are concerned about; filetype = scan( filename, -1, '.' ) ; if filetype = 'sas7bdat' then SAS_ds_name = upcase( scan( filename, 1, '.' )) ; else if lowcase(filetype) = 'sas' then prog_name = filename ;   not sure why you identify sas7bdat and then ignore them.. data ds_and_progs ; set filelist ;    length filename $100 filetype $8 prog_name $40 sas_ds_name $32 filepath $1000;    filename = scan( line, -1, '/\' ) ;             * neither / not \ will appear in filenames you are concerned about;    filetype = scan( filename, -1, '.' ) ;    if filetype = 'sas7bdat' then          SAS_ds_name = upcase( scan( filename, 1, '.' )) ;    else    if lowcase(filetype) = 'sas' then          prog_name   = filename  ;    else delete ;    filepath = substr( line, 1, length(line) - length( filename) -1 ) ; run ; . pick the results you want ... View more