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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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
  • 774 views
  • 0 likes
  • 2 in conversation