I corrected my previous post.   But look at this (from the proc upload doc):   INFILE=client-file-identifier specifies the external file that you want to upload to the server from the client. If you use the INFILE= option, you must also use the OUTFILE= option. client-file-identifier can be one of the following: fileref is used if you have defined a fileref on the client that is associated with a single file. You must define the fileref before specifying the PROC UPLOAD statement. fileref(member) is used if you have defined a fileref on the client that is associated with an aggregate storage location, such as a directory. member specifies one or more files in that aggregate storage location. You can use the asterisk character (*) as a wildcard in the member specification to upload multiple files via a single PROC UPLOAD statement. The * matches zero or more characters. You must define the fileref before specifying the PROC UPLOAD statement. Note: The transfer of hidden files is not supported when using the (*) wildcard   So you should be able to use wildcards for files in a directory accessed through a filename reference. If that is not possible, you need to do the transfer one file at a time. Aggregate file references are not allowed. ... View more

After reading your initial post again, I think you want a cartesian product with all the zips? In this case it is an issue for proc sql: proc sql; create table want as select a.company, b.zip as zip, case when b.zip = a.zip then var1 else 0 end as var1, case when b.zip = a.zip then var2 else 0 end as var2 from have a, zips b order by company, zip ; quit; (using my example data from the other post) ... View more