topic Re: is it possible to import CSV file using DS2 in SAS Programming

is it possible to import CSV file using DS2

rickrp2 — Tue, 01 Aug 2017 19:38:11 GMT

Re: is it possible to import CSV file using DS2

error_prone — Tue, 01 Aug 2017 20:16:27 GMT

As far as i know it is not possible to import files with ds2.

Re: is it possible to import CSV file using DS2

rickrp2 — Tue, 01 Aug 2017 21:06:19 GMT

So, Do you Know If Can I execute a SAS Tradicional Code in DS2?

Re: is it possible to import CSV file using DS2

ballardw — Tue, 01 Aug 2017 21:30:53 GMT

Please describe why you are unable to run "traditional" SAS code outside of DS2.

What type of code are you attempting?

Re: is it possible to import CSV file using DS2

Kurt_Bremser — Tue, 01 Aug 2017 21:41:35 GMT

"Traditional" SAS code is run in a data step, as always.

Re: is it possible to import CSV file using DS2

rickrp2 — Tue, 01 Aug 2017 21:42:32 GMT

I have a problem with my SAS version, that not contains the JSON packages to parse a JSON file, so I built the code below in SAS traditional programming as a workaround. The code will be execute by SAS ESP.

	filename data '/sasdata/ma/mailing/ric4.json';

	data datatest (drop =  linha pos);
		infile data lrecl = 32000 truncover scanover dsd firstobs=2;

		Length linha $255.;

		Input Linha;

		campo    = trim(left(tranwrd(scan(linha,1,': '),'"','')));

		/*
		verificar se e uma informacao de data
		*/
		pos=index(linha,'_date');

		if pos = 0 then do;
		   conteudo = trim(left(tranwrd(tranwrd(scan(linha,-1,': '),'"',''),',','')));
		end;
	    else do;
 		   conteudo = trim(left(tranwrd(tranwrd(scan(linha,-2,'_date"'),'"',''),',','')));
		end;
	
	    if trim(left(campo)) not in ('[','{',']');

		grava = 0;
		grava =index(campo,'}');
	run;

Re: is it possible to import CSV file using DS2

ChrisHemedinger — Tue, 01 Aug 2017 21:58:33 GMT

In SAS 9.4 M4 we have the JSON libname engine. If you have that with your SAS ESP environment, that might be more robust.

Re: is it possible to import CSV file using DS2

rickrp2 — Tue, 01 Aug 2017 22:01:37 GMT

The JSON package are available from SAS 9.4 M3, the version that I using is SAS 9.4 M2.