topic Is there any way to store the source code of SAS Utility Macro(%DS2CSV) in SAS Programming

Is there any way to store the source code of SAS Utility Macro(%DS2CSV)

Manu_SAS — Tue, 10 Feb 2015 06:37:39 GMT

Hello,

The source code of %ds2csv macro is stored in Application dispatcher.

In the following example, the %COPY statement writes the stored source code to the SAS log:

%macro foobar(arg) /store source

des="This macro does not do much";

%put arg = &arg;

%mend

%copy foobar/source;

What If I'm using the Utility macro %DS2CSV, for example

%ds2csv (data=sashelp.retail, runmode=b, csvfile=.\retail.csv);

When I tried using below, im facing the following error,

%copy ds2csv/source;

ERROR: /source option is not included in the macro ds2csv.

When I tried to find the source code of %ds2csv,

DS2CSV CSV File

Generator

webcsv1.sas,

webcsv1.html

This sample program uses the DS2CSV macro to convert

any SAS data set to a comma separated variable file to be

downloaded to the browser

Re: Is there any way to store the source code of SAS Utility Macro(%DS2CSV)

Patrick — Tue, 10 Feb 2015 10:13:56 GMT

There are different options when compiling a macro SAS(R) 9.4 Macro Language: Reference, Third Edition

Using "source" will store the source code with the compiled macro so it can easily be retrieved. On the other hand using "secure" will make it almost impossible for you to retrieve the source code.

Re: Is there any way to store the source code of SAS Utility Macro(%DS2CSV)

Manu_SAS — Tue, 10 Feb 2015 12:01:39 GMT

Hi Patrick,

Thanks for the reply.

Alternatively, went through the SASROOT directory(Unix SAS 9.4). Under SASAUTOS, we have the ds2csv.sas code. Copied to my home directory, modified by adding "/store source" in %macro statement.

Thus, ERROR resolved.

Thanks,

Manohar

Re: Is there any way to store the source code of SAS Utility Macro(%DS2CSV)

Patrick — Tue, 10 Feb 2015 19:59:39 GMT

If you want this as a permanent solution for everybody then you could also extend the SASAUTOS paths with an additional directory (as first directory) and then store the amended copy of ds2csv.sas there. SAS will then pick-up this "overlay" version as it finds it first.

The disadvantage of such an approach is of course that this macro will never get updated when upgrading to a newer SAS version.

Re: Is there any way to store the source code of SAS Utility Macro(%DS2CSV)

Tom — Wed, 11 Feb 2015 00:28:35 GMT

You need to use %COPY to view the source code of a macro if the macro was delivered in a compiled catalog. But DS2CSV and other supplied SAS macro are delivered as source files.

So you don't need to se %COPY, just read the file.

data _null_;

infile sasautos('ds2csv.sas');

input;

put _infile_;

run;