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
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 |
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 |
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
what is sas and what are the functions? : Sas-administrator
how does sas handle missing values in procs? : Sas programming
If i doest required Cumilative frequency in my table, generated by using PROC FREQ what i had to do?
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 ...
What is the maximum length of the macro variable? : sas-macro
What are the automatic variables for macro? : sas-macro
How to limit decimal places for variable using proc means?
what is the basic structure sas administrator? : Sas-administrator
What is the difference between INPUT and INFILE ?
how to debug and test the sas program? : Sas-administrator
for report generation which one you used proc report or data_null_?
3 Answers Accenture, Quintiles,