topic Re: download of SAS output as Csv file. in SAS Programming

download of SAS output as Csv file.

krishna13 — Fri, 17 Jan 2020 13:07:54 GMT

I working academic project, I converted SAS date format to MMDDYYYY.

output displayed as expected.

How can to download output as CSV file?

else to save output as CSV file in same path ?

Re: download of SAS output as Csv file.

tomrvincent — Fri, 17 Jan 2020 13:37:16 GMT

What have you tried so far?

Re: download of SAS output as Csv file.

Amir — Fri, 17 Jan 2020 13:38:27 GMT

Are you looking for something like the following. If not then please provide some input data and what you want it to look like when it is output.

/* create data */
data have;
   input
      id      : $char8.
      my_date : date9.
   ;

   format
      my_date mmddyyn8.
   ;

   datalines;
1 16jan2020
2 17jan2020
3 18jan2020
;


/* write data out as a csv */
data _null_;
   file tempfile dlm=',';

   set have;

   put
      id
      my_date
   ;
run;

Regards,

Amir.

Re: download of SAS output as Csv file.

Reeza — Fri, 17 Jan 2020 16:53:38 GMT

PROC EXPORT, right click the file and select export or use the Export Task for starters.

It varies a bit based on the version of SAS and if you're on a server/UE.

Re: download of SAS output as Csv file.

Tom — Fri, 17 Jan 2020 17:11:17 GMT

@krishna13 wrote:

I working academic project, I converted SAS date format to MMDDYYYY.

output displayed as expected.

How can to download output as CSV file?

else to save output as CSV file in same path ?

Are you working on some remote SAS server? Is it one of SAS's servers (on demand for academics?) or a server at your institution. When you say "download" do you mean you need don't know how to create a CSV file? Or do already know how to create a CSV file but are having trouble moving it somewhere. Where do you want to move it?

How are you running your SAS code? Are you using some front end, like SAS/Studio or Enterprise Guide? Are you using SAS Display Manage to run SAS interactively? Or do you have some other way you are running SAS?