Insert rows into table on condition

NataljaK — Thu, 20 Oct 2022 09:22:08 GMT

Hi dear friends,

I have been user of SAS EG for a long time but I use very rarely programming language in my work.

Now I need to find solution for task, that I can't solve using just SAS EG features.

I have a table and I would like to add n rows with fields f1 and f2 to it depends on makro-variables:v1,v2,v3

If variable v1 is 0 I have to add 3 row and set the field f2 in each row as 'v1', 'v2', 'v3' ;

If variable v2 is 0 I have to add 2 row and set the field f2 in each row as 'v2', 'v3';

If variable v3 is 0 I have to add 1 row and set the field f2 in it as 'v3';

Thanks in advance ,

Natalja

Re: Insert rows into table on condition

LinusH — Thu, 20 Oct 2022 12:13:27 GMT

You can solve this in many ways, programmatically.

One way is to have data step that evaluates the macro variable, and does explcit OUTPUT. And the PROC APPEND to you target table.

I imagine that you build macro logic to dynamically generate PROC SQL INSERT statments directly into the target table.