topic Re: ODS CSV-Data showing blank in CSV file in New SAS User

ODS CSV-Data showing blank in CSV file

ssaha — Tue, 13 Aug 2019 08:14:34 GMT

Using ODS CSV, when I am running from a stored process program the data is not getting populated in the csv file. It is showing blank.

For your reference, I used this ods csv code. I ran the stored process program from SAS 9.3

ods _all_ close;
ods csv file="/trnapp/sas/dev/projects/so/sho/num_as_char28.csv" options(Prepend_Equals='Yes' quote_by_type="Yes" );

proc print data=adw_mwh_to;

run;

ods csv close;

Re: ODS CSV-Data showing blank in CSV file

ballardw — Tue, 13 Aug 2019 14:29:49 GMT

@ssaha wrote:

Using ODS CSV, when I am running from a stored process program the data is not getting populated in the csv file. It is showing blank.

For your reference, I used this ods csv code. I ran the stored process program from SAS 9.3

ods _all_ close;
ods csv file="/trnapp/sas/dev/projects/so/sho/num_as_char28.csv" options(Prepend_Equals='Yes' quote_by_type="Yes" );

proc print data=adw_mwh_to;

run;

ods csv close;

Is there any LOG entry related to this? If so show the relevant part. Paste into a code box on the forum opened using the {I} icon to preserve formatting.

From the path you show for the output it is not possible to tell if you path starts at a drive map point or not. If "trnapp" is not a mount point then the output may have been directed to the default SAS executing directory and assumed that you wanted the location subordinate to that location.

Re: ODS CSV-Data showing blank in CSV file

Tom — Tue, 13 Aug 2019 14:37:50 GMT

Please show example line(s) from the CSV file where the value is not what you expect. use the Insert Code {i} icon to pop-up a window where you can paste the lines of text from the CSV file. Do NOT open the CSV file using Excel. Open it with a text editor so you can see what is in the file instead of what Excel converts it into.

Then show the values of the variables in the SAS dataset that you feel are not being represented properly in the CSV file. Show the data type and any formats attached the variables in question.

Re: ODS CSV-Data showing blank in CSV file

Cynthia_sas — Tue, 13 Aug 2019 17:33:31 GMT

Hi:

When you use a Stored Process to return results, you should be using %STPBEGIN and %STPEND for the required Stored Process Macro calls that are needed before and after any code that is going to generate streaming output.

So your use of a physical name doesn't look quite right. Or, if you're not going to use %STPBEGIN/%STPEND, then you might use _webout. This previous forum posting in the Stored Process forum has an example of the code I've always used: https://communities.sas.com/t5/SAS-Stored-Processes/How-do-I-export-sas-dataset-to-csv-using-stored-process/td-p/376152

Hope this helps. You might also want to post your question in the Stored Process Forum.

Cynthia