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
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.