BookmarkSubscribeRSS Feed
San_0611
Calcite | Level 5

libname cert 'file  location';

 

data  work.tds  cert.acc1  cert.acc2;

   set sas.emp;

run;

 

In the  above  program how  many  permanent and temporary  data  sets  are  read.

 

 

Please help .

Thanks  in advance. 

3 REPLIES 3
RW9
Diamond | Level 26 RW9
Diamond | Level 26

Well, your question "In the  above  program how  many  permanent and temporary  data  sets  are  read." - there is only one dataset "read", thats on the set line.  The library sas is not shown however, so can't say about that.  I also don't think the question is about "read" unless its a trick question.  The reason is there are 3 datasets "written", one to temporary work area, 2 others are written to the physical library cert.

San_0611
Calcite | Level 5
Sorry , the question is how many temporary and permanent data sets
are there in above program .
RW9
Diamond | Level 26 RW9
Diamond | Level 26

As above:
work - this is a temporary SAS created library

cert - this is created by you in the code and points to the physical location, so anything saved into there is permanent.

sas - this is not shown in the code, so I can't tell you.

 

So 2 permanent, 1 temporary, and 1 unknown.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

Register now

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 1527 views
  • 0 likes
  • 2 in conversation