topic Re: solve error 180-322 in New SAS User

solve error 180-322

gkpf — Tue, 01 Oct 2019 11:07:47 GMT

Hi, I'm new with SAS and I have a little problem when I merge two data set.

when I run the below code, an error 180-322 occur and I dont know why, I check my semicolon and it seems just fine.

plz help.

DATA mer03;
	proc sort data=PAXBAG.baggage_info_1; by Pax_Key;run;
	proc sort data=PDETAIL.pax_detail_1; by Pax_Key;run;
	merge PAXBAG.baggage_info_1 PDETAIL.pax_detail_1;
	by Pax_Key;
run;

Re: solve error 180-322

gkpf — Tue, 01 Oct 2019 11:13:21 GMT

i forget to put the error message.

29 merge PAXBAG.baggage_info_1,PDETAIL.pax_detail_1;
_____
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

2 SAS 系統 2019年10月 1日星期二下午06時40分50秒

29 by Pax_Key;
__
180

ERROR 180-322: Statement is not valid or it is used out of proper order.

Re: solve error 180-322

andreas_lds — Tue, 01 Oct 2019 11:33:47 GMT

You can't use proc sort in a data-step. Try:

proc sort data=PAXBAG.baggage_info_1; 
  by Pax_Key;
run;

proc sort data=PDETAIL.pax_detail_1; 
  by Pax_Key;
run;

data mer03;
	merge PAXBAG.baggage_info_1 PDETAIL.pax_detail_1;
	by Pax_Key;
run;

Re: solve error 180-322

gkpf — Tue, 01 Oct 2019 11:41:53 GMT

Thanks, I solve it simply by moving the data mer03 to the bottom line. @andreas_lds Thank you so so much

proc sort data=PAXBAG.baggage_info_1; by Pax_Key;
proc sort data=PDETAIL.pax_detail_1; by Pax_Key;
DATA mer03; merge PAXBAG.BAGGAGE_INFO_1 PDETAIL.PAX_DETAIL_1; by Pax_Key; 	
	
run;