topic Re: Proc SQL Null? in SAS Programming

Proc SQL Null?

buechler66 — Mon, 29 Aug 2016 21:02:04 GMT

Hi. I'm trying to create a null numeric variable name Rule_Order in my Proc SQL, but I'm getting this error:

ERROR: The following columns were not found in the contributing tables: null

Can you help me to resolve this error? I'd much appreciate the help.

	proc sql;
	create table QueryData&ZIP5 as
	select  *,
			"A" as source, 
			"-" as rule_nm length = 58, 
			actual_dlvry_date as ad_dt, 
			null as rule_order
	from ods_iv_recon_selected_mp
	union all corresponding
	select  *,
			"B" as source, 
			"-" as rule_nm length = 58, 
			actual_dlvry_date as ad_dt, 
			null as rule_order
	from ods_bi_recon_selected_mp;
	quit;

Re: Proc SQL Null?

ballardw — Mon, 29 Aug 2016 21:19:21 GMT

Is the varaible you want to assign the missing (SAS really doesn't speak NULL) a character or numeric in purpose?

Numeric: . as rule_order

Character: "" as rule_order (best to set a length attribute for the variable if you are updating this later to avoid truncation)

Re: Proc SQL Null?

buechler66 — Mon, 29 Aug 2016 22:05:01 GMT

Thanks for the help!