topic Re: DS2 + sql query in SAS Programming

DS2 + sql query

pablas29 — Tue, 08 Oct 2019 15:36:33 GMT

I am new to DS2 and want to test a few things. In the below example, hoe can I create a package for proc sql step (table3) and use it further in the program?

data table1;
input id name $;
cards;
1 name1
2 name2
3 name3
4 name4
;
run;
data table2;
input id city $;
cards;
1 city1
2 city2
3 city3
5 city5
;
run;

proc sql;
create table table3 as
select a.id, a.name, b.city
from table1 a
left join table2 as b
on a.id = b.id

order by 1;
quit;

Re: DS2 + sql query

ChrisNZ — Thu, 10 Oct 2019 03:15:09 GMT

1. Have see seen this page (SAS® 9.4 DS2 Language Reference, Sixth Edition - Example: SQL in a DS2 Program)?

2. Any reason you want to do this? DS2 is only useful if you have distributed data.

Re: DS2 + sql query

pablas29 — Thu, 10 Oct 2019 18:08:52 GMT

Yes, I have been to that page.

But what I need is to create a package of that sql step and then send that package to someone to use. I need the package so that I can hide the code.

Thanks.

Re: DS2 + sql query

ChrisNZ — Thu, 10 Oct 2019 22:18:03 GMT

> so that I can hide the code

You could use a secure macro.

Be sure to read this discussion: Compile already existing Macros SECURE

Re: DS2 + sql query

pablas29 — Mon, 21 Oct 2019 19:06:16 GMT

I apologise for late response. I was aware of the SECURE option but the problem is that stored compiled macro can't be moved to another operating system or to a different release of SAS.

Re: DS2 + sql query

pablas29 — Mon, 11 Nov 2019 18:30:10 GMT

Any solution?

Re: DS2 + sql query

Tom — Mon, 11 Nov 2019 19:31:48 GMT

What did you try? In what way did it fail?

Also why would you WANT to hide the code? Is there some reason?

Re: DS2 + sql query

ChrisNZ — Mon, 11 Nov 2019 23:50:45 GMT

> stored compiled macro can't be moved to another operating system or to a different release of SAS.

Whereas a DS2 package is immune to these issues?

Re: DS2 + sql query

langalife — Mon, 24 Oct 2022 10:52:08 GMT

Good day

I would like to know if you are creating in memory variables?

will you be using Packages, methods and data grids?

just a highlight n your purpose of your exercise.

I have been working on sas ds2 to store temporal variables where system will pass one input at time, or for batch processing.

Re: DS2 + sql query

Patrick — Mon, 24 Oct 2022 11:10:57 GMT

@langalife Unfortunately some old discussions don't get closed. Always worth to check the last posted date.