topic Re: SAS syntax correct in SAS Programming

SAS syntax correct

ccnky123 — Sun, 23 Sep 2018 11:40:42 GMT

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

Like line1 with the lack of '%' before let statement.Thank you for your attention

proc sql;
create table acct_purc_stat_m nologging as
select acct,sum(txn_amt_rmb) purc_amt
from ccm_base_trans
where plus_minus_flag=1 and txn_type='01' and org='242'
and "1may2015:00:00:00"dt <=eff_date<="31may2015:00:00:00"dt
group by acct
order by acct;
run;

1.%let var=%str(sex age edu_degree mob actv_flag circ_flag credit_limit otb ar);
let var=%str(sex age edu_degree mob actv_flag circ_flag credit_limit otb ar);
2.
proc sort data=ccm_expd(keep &var. where=(circ_flag='1'))
3.
out = acct_act_m;
4.
class acct;
run;

data acct_base_inf;
5.
	merge acct_act_m(in=a) acct_purc_stat_m(in=b);
6.
	if a;
7.
	used_rate=ifc(credit_limit in (0,.),0,ar/credit_limit);
run;

proc freq data=acct_base_inf;
	by sex edu_degree actv_flag circ_flag/missing;
run;

proc univariate data=acct_base_ing missing;
	var age mob credit_limit otb ar used_rate;
run;

Re: SAS syntax correct

Shmuel — Sun, 23 Sep 2018 11:50:38 GMT

Can you run your code and post the log?

Re: SAS syntax correct

Astounding — Sun, 23 Sep 2018 12:42:32 GMT

You already know the answer for %LET.

For #2, when KEEP is used as a data set option inside parentheses, it requires an equal sign: keep=

For #3, nothing wrong.

For #4, there is no such thing as a CLASS statement in PROC SORT. It should become a BY statement instead.

For #5 through #7, it is highly likely that the program should add a BY statement after the MERGE statement: by acct;

PROC FREQ is allowed to use a BY statement. But most likely the intent is to use a TABLES statement instead of a BY statement.

PROC UNIVARIATE does not allow the MISSING option on the PROC statement. If you had a CLASS statement, the MISSING option could be part of that statement.

Re: SAS syntax correct

ccnky123 — Sun, 23 Sep 2018 13:08:14 GMT

thank you for your time.I have already got the answer from syntax only