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 |
What is the role of administrative users? : sas-grid-administration
What are the data types that sas contain?
Below is the table. Required to be output should be the highest number of each student_id. Example. Student_id Subject Marks 1 Hindi 86 2 Hindi 70 3 English 80 . Calculate sum and average marks for each group of student_id Example. Student_id Subject Marks Total Marks Average 1 English 40 181 60.33333 2 English 67 196 65.33333 3 English 80 160 53.33333 PLEASE PROVIDE THE CODE OF ABOVE PROBLEMS
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
what is star schema? : Sas-di
There is a river notoriously known for it?s large crocodile population. With ease, how do you safely cross it?
what is difference in window SAS & Unix SAS.....how do define working environment in both???
in which companies SAS openings are there? List of companies using SAS technology.
/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;
What is the SAS data set?
. Which date advances a date, time or date/time value by a given interval?
What is a pdv and what are its functions?