i am importing large data from oracle to work library.
in log there is a error message worklibrary space is not enough.
then how to import the data safely to sas environment.

Answers were Sorted based on User's Feedback



i am importing large data from oracle to work library. in log there is a error message worklibrary ..

Answer / raghavendrareddy

defaultly every dataset is saved into work library,
there is no space in work library,delete some datasets in
work library.

Is This Answer Correct ?    2 Yes 0 No

i am importing large data from oracle to work library. in log there is a error message worklibrary ..

Answer / aruna

You can use either or both of these options:
1.Delete temporary dataset that u no longer need
2.Direct temporary datasets to a different SAS data library

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More SAS Interview Questions

data study; input Subj : $3. Group : $1. Dose : $4. Weight : $8. Subgroup; x= input(Weight,5.1); datalines; 001 A Low 220 2 002 A High 90 1 003 B Low 193.6 1 004 B High 165 2 005 A Low 123.4 1 ; Why does X get truncated? X shows up as 22 instead of 220,9 instead of 90 and 19.8 instead of 198? This problem doesnt happen with the values 193.6 and 123.4. This does not happen if x is read on the 5. informat instead of the 5.1 informat

2 Answers  


what is sas and what are the functions? : Sas-administrator

0 Answers  


how does sas handle missing values in procs? : Sas programming

0 Answers  


If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?

8 Answers   HCL,


if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...

0 Answers   Accenture,


What is the maximum length of the macro variable? : sas-macro

0 Answers  


What are the automatic variables for macro? : sas-macro

0 Answers  


How to limit decimal places for variable using proc means?

0 Answers  


what is the basic structure sas administrator? : Sas-administrator

0 Answers  


What is the difference between INPUT and INFILE ?

0 Answers  


how to debug and test the sas program? : Sas-administrator

0 Answers  


for report generation which one you used proc report or data_null_?

3 Answers   Accenture, Quintiles,


Categories