topic Re: SAS syntax correct in SAS Procedures

SAS syntax correct

ccnky123 — Sun, 23 Sep 2018 13:51:16 GMT

Please kindly me help me with SAS syntax correct for each line.

Like line2 with the right option should be "out" but not "outdata"

1.
proc sort data=ccm_base_cust_inf_m(keep becif_custid cert_id_18)
2.
	outdata=ccm_base_cust_inf_m;
	where cert_id_18 <>"";
	by cert_id_18;

3.
proc sort data=prom_cust_inf(rename=(id=cert_id_18));
	by id;

4.
data prom_cust_inf_1;
5.
	merge prom_cust_inf(in=a)
		ccm_base_acct_inf_m(in=b);
6.
	by id;
	if a;
	length base_city=$20.;
	base_city=input(base_city,$city.);

7.
%let city=%str(NY","SH","TK");

8.
proc summary data=prom_cust_inf_1 nway;
9.
	by base_city;
10.
	var response_flag;
	out=stat_city_sum(drop=_type_) sum;
run;

Re: SAS syntax correct

VDD — Sun, 23 Sep 2018 14:18:50 GMT

change :

outdata=ccm_base_cust_inf_m;

to:

out=ccm_base_cust_inf_m;

Re: SAS syntax correct

Jagadishkatam — Sun, 23 Sep 2018 14:29:02 GMT


1.
proc sort data=ccm_base_cust_inf_m(keep becif_custid cert_id_18)
2.
	out=ccm_base_cust_inf_m;
	where cert_id_18 ne "";
	by cert_id_18;

3.
proc sort data=prom_cust_inf out=(rename=(id=cert_id_18));
	by id;

4.
data prom_cust_inf_1;
5.
	merge prom_cust_inf(in=a)
		ccm_base_acct_inf_m(in=b);
6.
	by id;
	if a;
	length base_city $20.;
	base_city=input(base_city,$city.);

7.
%let city=%str(NY,SH,TK);

8.
proc summary data=prom_cust_inf_1 nway;
9.
	by base_city;
10.
	var response_flag;
	out=stat_city_sum(drop=_type_) sum;
run

Re: SAS syntax correct

VDD — Sun, 23 Sep 2018 14:31:16 GMT

That is it, does it work now?

Happy data mining

Re: SAS syntax correct

Cynthia_sas — Sun, 23 Sep 2018 15:56:43 GMT

Hi:
You have the perfect opportunity here to use the SAS error messages in the log to teach you what is incorrect in the code.

You've supplied code, but you have not supplied data. If you took the numbers out of your code and just submitted the code, the SAS log would tell you where your errors were. Then, if you started from the top of the log and resolved each one, you would learn, for yourself, whether anything was wrong in the code.

Cynthia

Re: SAS syntax correct

ccnky123 — Mon, 24 Sep 2018 07:24:45 GMT

there are many mistake in the answer,right?