topic Re: proc copy show double identical files in SAS Programming

proc copy show double identical files

Phil_NZ — Wed, 03 Feb 2021 04:11:56 GMT

Hi SAS Users,

While I try to export the output to sas7bdat type to a specific folder, with the code below, I face the double output problems

The code is

 	libname myfolder 'C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\3calculation';
 	proc copy in=work out=myfolder;
 		select argentina_sum;
 	 	run;
 	quit;

The output shows two identical output:

I am wondering if there is any way that I can still export the output argentina_sum as above but it only shows 1 output argentina_sum in the output list?

Many thanks and warm regards!

Re: proc copy show double identical files

Kurt_Bremser — Wed, 03 Feb 2021 07:26:24 GMT

In which user interface do you see the two entries?

Enterprise Guide Library list, SAS Studio Libraries, or the Explorer in Display Manager (Base SAS native interface)?

Re: proc copy show double identical files

Phil_NZ — Wed, 03 Feb 2021 08:05:54 GMT

Hi @Kurt_Bremser

It is Enterprise Guide Library list.

Many thanks!

Re: proc copy show double identical files

Ksharp — Wed, 03 Feb 2021 11:30:33 GMT

Another one is a VIEW . Try just copy dataset.

proc copy in=work out=myfolder memtype=data ;
select argentina_sum;
run;

Re: proc copy show double identical files

Phil_NZ — Wed, 03 Feb 2021 19:32:05 GMT

Hi @Ksharp

When applying the addtional code, the results still shows double results

   	libname myfolder 'C:\Users\pnguyen\OneDrive - Massey University\PhD JOURNEY\3calculation1';
 	proc copy in=work out=myfolder memtype=data;/*add code memtype=data*/
 		select Argentina_;
 	 	run;
 	quit;

Many thanks and warm regards.

Re: proc copy show double identical files

Kurt_Bremser — Wed, 03 Feb 2021 19:47:05 GMT

Please do a directory listing (outside SAS, preferrably from a cmd window with dir) of the folder.

I have a suspicion about the files that you see.

Re: proc copy show double identical files

Ksharp — Thu, 04 Feb 2021 11:36:43 GMT

As Kurt point, check it postfix via OS command like : LS , DIR
Should show something like :

Argentina_.sas7bdat
Argentina_.sas7bview

Re: proc copy show double identical files

Kurt_Bremser — Thu, 04 Feb 2021 11:50:30 GMT

Actually, they should show

argentina_.sas7bdat
argentina_.sas7bview

as SAS file names are always lowercase on Windows and UNIX systems. If you find capital letters in such filenames, they are a cause for trouble.