topic Re: Output statement to bucket the data in SAS Programming

Output statement to bucket the data

GN0001 — Mon, 10 Apr 2023 19:19:44 GMT

Hello team,

I have a code like this:

If member in ("A", "B) and code = "T" and payer in ("V") then thisfield = "CCC"

I want to use output statement to bucket it right after the statement is read. I can say:

How can I use output statement? How can I use thisfield along with output statement?

Respectfully,

CloudsInSky

Re: Output statement to bucket the data

PaigeMiller — Mon, 10 Apr 2023 19:27:07 GMT

I don't really understand the question. Bucketing the data and the OUTPUT statement are relatively independent.

I want to use output statement to bucket it right after the statement is read.

So what is stopping you?

Re: Output statement to bucket the data

Quentin — Mon, 10 Apr 2023 19:25:18 GMT

You can use the OUTPUT statement anywhere in a DATA step. So could could do:

data want;
  set have;
  If member in ("A", "B) and code = "T" and payer in ("V") then thisfield = "CCC" ;
  output;
run;

But that step would give you the same output data without the OUTPUT statement, because the DATA step has an implied OUTPUT statement.

Perhaps you could show a bit more of what you are trying to do. You could post code to create a dataset with a few records of example data, and then show the dataset you would like to create from that example data, and the code you have tried.

Re: Output statement to bucket the data

WarrenKuhfeld — Mon, 10 Apr 2023 19:34:08 GMT

If member in ("A", "B) and code = "T" and payer in ("V") then do;
   thisfield = "CCC";
   output;
end;

If you are asking to conditionally output only after setting thisfield, you would do it as above.

Re: Output statement to bucket the data

ChrisHemedinger — Mon, 10 Apr 2023 19:43:22 GMT

One more tip I'll add in addition to the good advice provided so far. You can use DATA step to create multiple output data sets in one step, and use conditional OUTPUT statements to control what goes into each. This example creates one data set (WANT1) with your "CCC" records, and a second data set (WANT2) with all other records.

data want1 want2; set have; If member in ("A", "B) and code = "T" and payer in ("V") then do; thisfield = "CCC"; output want1; end; else output want2; run;

Re: Output statement to bucket the data

GN0001 — Mon, 10 Apr 2023 22:31:27 GMT

Hello team,

I want this output (want1) to be value for a variable such as productName.

productName =want1
prouctName = want2
an so on.

I appreciate your help.

Thanks,

Blue Blue

Re: Output statement to bucket the data

GN0001 — Mon, 10 Apr 2023 23:17:06 GMT

Hello team member,

This is what I want and I got it.

data test1;
set sashelp.class;
format item $8.;
run;

data test2;
set test1;
if Name = "Alfred" then output = "AA";
If Name = "Alice" then output = "BB";
item = Output;
Run;


This gave me what I needed.
Thanks,
blueblue

Re: Output statement to bucket the data

GN0001 — Tue, 11 Apr 2023 04:26:32 GMT

Hello team;

If member in ("A", "B) and code = "T" and payer in ("V") then do;
   thisfield = "CCC";
   output;
end;

This syntax gives errors:

ERROR 117-185: There were 8 unclosed DO blocks.

Thank you for your help.

Blue Blue

Re: Output statement to bucket the data

GN0001 — Tue, 11 Apr 2023 04:35:49 GMT

Hello Chris,

data want1 want2;
set have;
If member in ("A", "B) and code = "T" and payer in ("V") then do;
   thisfield = "CCC";
   output want1;
end;
else output want2;
run;

I have more than two if statements. I have 8 if statements. How can I place them in "if and else statements. Instead of data want1, want2, I have want1, want2, want3, want4, want5, want6, want7, want8.

Regards,

blue & blue

Re: Output statement to bucket the data

Kurt_Bremser — Tue, 11 Apr 2023 06:08:46 GMT

if /* condition */
then do;
  /* action */
end;
else if /* another condition */
then do;
  /* another action */
end;
/* and so on */

Re: Output statement to bucket the data

GN0001 — Tue, 11 Apr 2023 16:43:04 GMT

Hello,
Thank you so very much for the response. What would be the last statement ? Else if or else?
Respectfully
Blue blue

Re: Output statement to bucket the data

Reeza — Tue, 11 Apr 2023 16:51:54 GMT

https://blogs.sas.com/content/sasdummy/2015/01/26/how-to-split-one-data-set-into-many/

Re: Output statement to bucket the data

Quentin — Tue, 11 Apr 2023 17:03:15 GMT

@GN0001 wrote:
Hello,
Thank you so very much for the response. What would be the last statement ? Else if or else?
Respectfully
Blue blue

It's up to you to decide, as the programmer. Personally, if I write IF/ELSE IF blocks, I like to explicitly handle all the expected scenarios with ELSE IF statements. Then I add an ELSE statement which generates an error message if the data have any surprises. e.g.:

if var='A' then do ;
  *...;
end;
else if var='B' then do ;
  *...;
end;
else if var='C' then do ;  /*else if statements for every expected value*/
  *...;
end;
else do;
  put "ER" "ROR: unexpected value " var= ;
end;

that allows your code to detect any records that fall through gaps in the logic.

Re: Output statement to bucket the data

Kurt_Bremser — Tue, 11 Apr 2023 18:47:52 GMT

This depends on the logic you want to implement in your code, so it's up to you.

Re: Output statement to bucket the data

GN0001 — Tue, 11 Apr 2023 22:02:34 GMT

Hello,
I am going to output observations conditionally. I am not creating a dataset output.
Regards.
Blue & blue

Re: Output statement to bucket the data

GN0001 — Tue, 11 Apr 2023 22:03:22 GMT

I am outpouring observations only not a dataset.
Thanks,
Blu blue