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

Hi, all:

 

I have the following codes, what is used for nolist?  Does this PROC DATASETS assign lib to work library?  Does this also delete dupicates?  Please help.

Thanks.

 

Y

 

proc datasets lib=work nolist; delete trash dups; quit; run;

1 ACCEPTED SOLUTION

Accepted Solutions
RW9
Diamond | Level 26 RW9
Diamond | Level 26

You would be best off reading the manual, it has a very descriptive passage on proc datasets:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473443.htm

 

As for your code, lib parameter sets the working library for the datasets operation, nolist supresses output, delete command removes datasets named trash and dups which reside in the libarary work.

proc datasets lib=work nolist; 
  delete trash dups; 
quit; 

 

 

View solution in original post

4 REPLIES 4
RW9
Diamond | Level 26 RW9
Diamond | Level 26

You would be best off reading the manual, it has a very descriptive passage on proc datasets:

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a002473443.htm

 

As for your code, lib parameter sets the working library for the datasets operation, nolist supresses output, delete command removes datasets named trash and dups which reside in the libarary work.

proc datasets lib=work nolist; 
  delete trash dups; 
quit; 

 

 

ybz12003
Rhodochrosite | Level 12

The PROC DATASETS statement lists the SAS files in the procedure input library unless the NOLIST option is specified. The NOLIST option prevents the creation of the procedure results that go to the log.

 

Does it mean no result will be shown in the log window? Thanks.

Reeza
Super User

@ybz12003 wrote:

The PROC DATASETS statement lists the SAS files in the procedure input library unless the NOLIST option is specified. The NOLIST option prevents the creation of the procedure results that go to the log.

 

Does it mean no result will be shown in the log window? Thanks.


 

That's exactly what it says. No results go to the log. You're better off testing these things, rather than asking them as questions. 

Reeza
Super User

Definitely a RTM question...

 

 

LIBRARY=libref
names the library that the procedure processes. This library is the procedure input/output library.

 

 

 

 

NOLIST
suppresses the printing of the directory of the SAS files in the SAS log.

http://support.sas.com/documentation/cdl/en/proc/61895/HTML/default/viewer.htm#a000247753.htm

 

There's a good paper on proc datasets via Mike Raithel

https://sasglobalforum2016.lanyonevents.com/connect/sessionDetail.ww?SESSION_ID=3440

 

See Presentation download on right hand side or search at lexjansen.com

 

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 4 replies
  • 21041 views
  • 1 like
  • 3 in conversation