topic Re: case when when applying in hash object in New SAS User

case when when applying in hash object

Bharat_P — Mon, 20 Jan 2020 06:27:04 GMT

proc so;
create table sample as 
select make
          ,type
          ,count(case when flag="euro" then MEET end) as Euro
          ,sum(case when flag="euro" then Invoice end) as Done
from help.cars
group by 1,2
;
quit;

need to convert this to hash coding. if someone can help the it will be great( writing sql as so, sashelp as help,msrp as Meet as I am not being able to paste codes which are grammatically incorrect.

Re: case when when applying in hash object

PeterClemmensen — Mon, 20 Jan 2020 06:53:17 GMT

Hi @Bharat_P.

Can you provide some sample data and what your desired result look like?

Re: case when when applying in hash object

Astounding — Mon, 20 Jan 2020 11:00:54 GMT

There are two major reasons why your request is not possible.

First, you ask for hashing. Hashing is a DATA step tool only, and cannot be used within PROC SQL. So you can pick one or the other, but not both.

Second, you tell us that the code you posted doesn't work. But you assume that we know what it is supposed to accomplish. That's your job, to explain what the result is going to be, especially when your code doesn't work.

Taking an educated guess at half of the problem (the INVOICE part), you noted that this doesn't work:

 ,sum(case when flag="euro" then Invoice end) as Done

I'm guessing that this is what is needed instead:

 ,sum((flag="euro") * Invoice) as Done

Perhaps you can test that (without the MEET logic that doesn't work) to see if it does part of what you want. But the logic for MEET is much more obscure and you will need to explain what you want.

Re: case when when applying in hash object

Bharat_P — Mon, 20 Jan 2020 11:05:37 GMT

Actually the msg got misinterpreted.Sorry for that. My task is to convert this code to hash object from SQL. This code is running fine but my job is to look for ways to convert the codes into hash objects

Re: case when when applying in hash object

Kurt_Bremser — Mon, 20 Jan 2020 14:58:45 GMT

Your issue looks like a simple summary operation, which is not the domain of hash objects.

Please supply example data, and the expected result.

Re: case when when applying in hash object

Patrick — Tue, 21 Jan 2020 02:42:55 GMT

@Bharat_P wrote:

Actually the msg got misinterpreted.Sorry for that. My task is to convert this code to hash object from SQL. This code is running fine but my job is to look for ways to convert the codes into hash objects

1. The code you've posted is NOT running fine but returns errors. Please fix the code so we can understand the logic you're after.

2. As @Kurt_Bremser writes this doesn't look like a good application for the SAS data step hash object so why would you want to go for such an approach in first place - unless that's an exercise.