topic Re: Proc freq or proc sql which one should I select? in New SAS User

Proc freq or proc sql which one should I select?

Sandeep77 — Tue, 08 Nov 2022 10:53:54 GMT

Hi all,

I am trying to find which previousrepcode has moved to paying accountstatus from the below sample table. I want to get a table which shows the count of how many 122, 168, 157, etc repcodes are in the paying accountstatus. I am confused to use the proc freq to get this information or proc sql. I have used the below code and this gives me information about the previousrepcode and paying_repcode. I want to count how many times 168, 122 etc are in paying. Thanks

AccountNumber	PreviousRepCode	nextstatus	dt_curbal	DateAccountMoved	Sector	accountstatus
321784639	122	005H	145.55	02-Nov-22	Comms	Review
272652868	168	005H	60.72	03-Nov-22	Utilities	Paying
250411519	168	005H	47.09	03-Nov-22	Comms	Review
340751155	122	005H	1186.47	03-Nov-22	Comms	End of cyle
291453173	157	005H	889.12	03-Nov-22	Financial	Paying

proc sql;
create table Paying_info as 
select 
PreviousRepCode,
accountstatus as Paying_repcodes
from out_trace_op_status
where accountstatus like 'Paying';
quit;

Re: Proc freq or proc sql which one should I select?

PaigeMiller — Tue, 08 Nov 2022 12:35:54 GMT

Could you please provide data as working SAS data step code (as you did here)?

Either SQL or FREQ ought to work here. FREQ may require some data step manipulation to get there.

Re: Proc freq or proc sql which one should I select?

Sandeep77 — Tue, 08 Nov 2022 13:41:43 GMT

Hi,

Apologies for that. I have created a test working data and adding it below.

data test;
input PreviousRepCode accountstatus;
datalines;
122	Review
168	Paying
168	Review
122	End of cycle
157	Paying
;
run;

Re: Proc freq or proc sql which one should I select?

PaigeMiller — Tue, 08 Nov 2022 13:59:38 GMT

Please be kind enough to test your code first to make sure it works (and fix it if it doesn't work). This code doesn't work.