- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 08-23-2023 08:36 AM
(543 views)
proc sql; create table vda_mnr as select a.*, b.poa1, b.poa2, b.poa3, b.poa4, b.poa5, b.poa6, b.poa7, b.poa8, b.poa9, b.poa10, b.poa11, b.poa12, b.poa13, b.poa14, b.poa15, b.poa16, b.poa17, b.poa18, b.poa19, b.poa20, c.clm_aud_nbr from sep.current_mnr_vardays a left join sep.ova_clmshdr_inp b on a.case_id=b.case_id left join sep.ip_confinement c on b.membersystemid=c.mbr_sys_id and b.adm_dt=c.fst_srvc_dt where a.Low_Perdiems not in ('Y') and a.Med_Prime not in ('Y') and a.MH_BH_Flag in ('N') and a.Admits=1; quit;
The file is getting damaged and i'm not able to move to further process, tried to split the above piece of code into 3 parts and ran but again same issue, and 50% of sas workspace is available can anyone suggest how to proceed with this piece of code
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can you verify if the issue is with the work location? For instance by using a temporary folder with enough space and run the code using a libname pointing to that temporary location.