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.
- 2 Answers
- 6333 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
what is program data vector? : Sas-administrator
i have a dataset with 25 obs; 10th obs has like ramu,anji,ramu,azad,ramu like this. i want to know how many times the word repeats in that obs?
why is sas data integration studio important? : Sas-di
explain the use of % includes a statement in sas? : Sas-administrator
I have 2 data sets A & B. Both have a variable called Age in them, each of them specifying a different functionality. In my program I use bot these data sets. How do I specify which Age variable I want to use?
What is run-group processing?
Please write codes to merge two datasets and keep every record in the first dataset.
How would you delete duplicate observations?
What procedure you used to calculate p-value?
2 Answers Accenture, Quintiles,
I need help in merging two different datasets. I am merging by date and I want to propagate observations from one dataset to the corresponding dates. One dataset has a unique date for each day of the month, while the other dataset has same date for different patient visits. For example I want to spread an observation on the 31DEC2008 from one dataset to several observations with the same date on a second dataset for all the patients who visited on that date. I have tried to merge the two and the result is not what I wanted. Instead I get a dataset whereby all the dates have missing values where observations from the first datset should have spread.
Which date functions advances a date time or date/time value by agiven interval?
Can you excute a macro within a macro? Describe.
Teradata 
