topic Re: SAS DI Datasets to be exported as csv files in SAS Data Management

SAS DI Datasets to be exported as csv files

laxmanpai — Thu, 25 Aug 2022 05:13:08 GMT

Hi Team,

I have a Data folder in SAS DI which has over 152 Tables. I need to export these 152 datasets to be copied as .csv files and need to be exported to a local folder .

Could you let me know

Re: SAS DI Datasets to be exported as csv files

JosvanderVelden — Thu, 25 Aug 2022 09:39:18 GMT

What are the properties of the data folder? Are the tables SAS tables?
What do you mean by local folder? Local for the server where SAS is running or a workstation where you are running SAS clients (ex. SAS management console & SAS enterprise guide)?
What are you going to use to run the export code? A batch process on the server or SAS Enterprise Guide or ???

Re: SAS DI Datasets to be exported as csv files

LinusH — Tue, 06 Sep 2022 09:16:09 GMT

Assuming these table have different table structures.

The answer depends on what level of lineage you require.

From implementation/coding perspective, you can easily write a macro that exports all table in a libref to a certain location.

Fore some traceability. you can add this into a DI Studio job an link all source table to this step.

For full lineage, you would use the file writer transformation on each source table and have a corresponding external file object defined.

Re: SAS DI Datasets to be exported as csv files

RacheLGomez123 — Mon, 28 Nov 2022 06:44:08 GMT

Suppose we have the following dataset in SAS:

/*create dataset*/
data my_data;
input A B C;
datalines;
1 4 76
2 3 49
2 3 85
4 5 88
2 2 90
4 6 78
5 9 80
;
run;

/*view dataset*/
proc print data=my_data;

We can use the following code to export this dataset to a CSV file called data.csv:

/*export dataset*/
proc export data=my_data
outfile="/home/u13181/data.csv"
dbms=csv
replace;
run;

I can then navigate to the location on my computer where I exported the file and view it:

The data in the CSV file matches the dataset from SAS.

Regards,

Rachel Gomez