BookmarkSubscribeRSS Feed
qwerty12
Fluorite | Level 6
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;

qwerty12_0-1692792534395.pngqwerty12_1-1692792662069.png

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
JosvanderVelden
SAS Super FREQ
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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 687 views
  • 0 likes
  • 2 in conversation