topic Re: Using json in ds2 in SAS Programming

Using json in ds2

Liliya95 — Thu, 19 Mar 2020 06:39:36 GMT

Hi!

Please, help.

I have to start code from example

But have error

ERROR: Compilation error.
ERROR: No package or extension for type package json.

proc ds2;　
data _null_;　
method init();　
dcl package json j;　
dcl double dblVal;　
dcl int rc;　
dcl nvarchar(30) jsontxt;　
j= _NEW_ JSON( );　
rc = j.createWriter();　
if rc=0 then rc = j.writeArrayOpen();　
if rc=0 then rc = j.writeString( ' Hello World! ' );　
if rc=0 then rc = j.writeClose();　
j.writerGetText( rc, jsontxt );　
put rc= jsontxt=;　
end;　
enddata;　
run;　
quit;

Re: Using json in ds2

andreas_lds — Thu, 19 Mar 2020 07:55:34 GMT

Which sas-version is in use? No error appears with 9.4m5.

Re: Using json in ds2

Liliya95 — Thu, 19 Mar 2020 08:11:13 GMT

sas rtdm 6.3 platform 9.4

Re: Using json in ds2

BrunoMueller — Thu, 19 Mar 2020 09:37:57 GMT

I suggest you contact tech support on this.

Re: Using json in ds2

andreas_lds — Thu, 19 Mar 2020 10:11:50 GMT

"9,4" is to short to be useful. Please post the result of

%put &=SYSVLONG;

Re: Using json in ds2

Liliya95 — Thu, 19 Mar 2020 11:02:46 GMT

9.04.01M1P120413

Re: Using json in ds2

andreas_lds — Thu, 19 Mar 2020 11:27:59 GMT

@Liliya95 wrote:

9.04.01M1P120413

So there we have the culprit: you are using 9.4m1, but json-package was added to ds2 in m3. So you need to updating your sas install is afaik the only way to solve the problem.

Re: Using json in ds2

Liliya95 — Thu, 19 Mar 2020 11:37:03 GMT

Thanks!