topic Re: How to compare all variables and get the desired output in SAS Studio

How to compare all variables and get the desired output

Abhinash_rout — Sat, 29 Jul 2023 20:24:21 GMT

I have a bank dataset in which i have 3 variables like Account, Month, Status. I need to know which accounts status is remain same as per the previous month.

refer to the following dataset and give a brief explanation about the findings.

Re: How to compare all variables and get the desired output

mkeintz — Sat, 29 Jul 2023 22:16:10 GMT

The only time I have seen the directive "refer to the following dataset and give a brief explanation about the findings" was in a homework assignment.

Please tell us what you have tried, and you will no doubt get good advice. Most respondents here would rather you own the answer than have the answer own you.

Re: How to compare all variables and get the desired output

Ksharp — Sun, 30 Jul 2023 09:15:26 GMT

It would be better to post real data,not a picture. and better some sas code to generate this data .

Here could give you a start:
https://communities.sas.com/t5/SAS-Programming/Help/td-p/886770

Re: How to compare all variables and get the desired output

ballardw — Sun, 30 Jul 2023 19:45:52 GMT

Some things that cannot be told from a picture that you may need to explain in considerable detail.

"same as per the previous month" means that we need to be able to tell just what a "previous month" would be. If your values for "month" are character then the "previous" can have a somewhat slippery meaning as 1 ) there is no YEAR present. So if you have JAN and DEC for the same account we cannot tell which is previous to which.

Second if the value of month are character then "previous" as in "before" typically means the value order. But with character values APR comes before JAN and any comparison is going to be nasty as is.

SAS has several tools to deal with sequential processing once the data is in sequence but we cannot tell if the first step is going to be coding that involves allowing placing the months in order and see the comment above about YEAR that may be involved with that.