BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Phil_NZ
Barite | Level 11

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:

My97_0-1612325434122.png

 

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!

 

 

 

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
1 ACCEPTED SOLUTION
7 REPLIES 7
Kurt_Bremser
Super User

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)?

Phil_NZ
Barite | Level 11

Hi @Kurt_Bremser 

It is Enterprise Guide Library list.

 

Many thanks!

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
Ksharp
Super User
Another one is a VIEW . Try just copy dataset.

proc copy in=work out=myfolder memtype=data ;
select argentina_sum;
run;
Phil_NZ
Barite | Level 11

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;

My97_0-1612380715820.png

 

Many thanks and warm regards.

Thank you for your help, have a fabulous and productive day! I am a novice today, but someday when I accumulate enough knowledge, I can help others in my capacity.
Ksharp
Super User
As Kurt point, check it postfix via OS command like : LS , DIR
Should show something like :

Argentina_.sas7bdat
Argentina_.sas7bview
Kurt_Bremser
Super User

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.

 

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 7 replies
  • 1259 views
  • 7 likes
  • 3 in conversation