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

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 4 replies
  • 18356 views
  • 1 like
  • 3 in conversation