topic Re: extension for physical file name does not correspond to a valid member type in SAS Programming

extension for physical file name does not correspond to a valid member type

Midi — Wed, 20 Nov 2019 15:47:29 GMT

Hi Everyone , i'm trying to append multiple files with the proc append and a macro , this is what i wrote :

%Macro Prep_Tbl_Date;
%do iii = 1 %to &num_File_.;
proc append Base=Work.Original_Table Data = %unquote(%str(%'&&_File_&iii..%'));
run;
%end;
%mend prep_table_date;
%pre_tbl_date;

Any Help Would be much appreciated , thank you.

Re: extension for physical file name does not correspond to a valid member type

Kurt_Bremser — Wed, 20 Nov 2019 15:53:03 GMT

From where do you populate the macro variables? I have a strong suspicion that macro coding is not necessary here and actually unhelpful.

Re: extension for physical file name does not correspond to a valid member type

Kurt_Bremser — Wed, 20 Nov 2019 15:54:48 GMT

And post some of the macro variables, ie

_file_1

_file_2

_file_3

Use the {i} button for this, so values are preserved and not mangled by the forum software.

Re: extension for physical file name does not correspond to a valid member type

Tom — Wed, 20 Nov 2019 15:56:53 GMT

You are trying to reference datasets by using a quoted physical name. SAS error message is saying the name does not look like a dataset name. SAS dataset names use sas7bdat as the extension. You do not need to include the extension. Example:

data test;
  set
   '/dir1/member1.sas7bdat'
   '/dir2/member2'
  ;
run;

If you meant to reference the dataset using normal LIBREF.MEMNAME syntax then do not include the quotes.