topic Re: When exporting to CSV variables are defined by "assigned values" instead of "raw in SAS Programming

When exporting to CSV variables are defined by "assigned values" instead of "raw values"

FourLeafCLover — Wed, 20 Jan 2021 18:05:04 GMT

I am having an issue when exporting a SAS file to a CSV file. Specifically variables are being exported with their "assigned values" instead of their "raw values". For example there is a dichotomous numerical variable with "raw values" of either 0 or 1 with "assigned values" of 0="no", 1="yes". When exporting the SAS file to a CSV this variable includes its "assigned value" ('Yes' or 'No') instead of the "raw value" (0 or 1) . Is their code that helps avoid this? The following is the code used to export the data:

PROC EXPORT DATA=sas file

Outfile= CSV file

DBMS=csv REPLACE;

PUTNAMES=no;

Run;

Thanks for your help

Re: When exporting to CSV variables are defined by "assigned values" instead of "raw

Kurt_Bremser — Wed, 20 Jan 2021 18:15:22 GMT

Take the data step code (created by PROC EXPORT) from the log and de-assign the formats.

Re: When exporting to CSV variables are defined by "assigned values" instead of "raw

Reeza — Wed, 20 Jan 2021 18:59:06 GMT

You have formats applied to your data then.

You can remove the format ahead of time or apply it as needed to generate the data you want. ODS CSV is a good way to do this as you can easily control the formats within a proc and test it easily.

ods csv file='/folders/myfolders/demo.csv';
   proc print data=sashelp.class noobs;
   format age 8.2; *formats variable as numeric with 2 decimal places;
   run;
ods csv close;

Same answer as here:

https://stackoverflow.com/questions/65814476/exporting-sas-file-to-csv

Re: When exporting to CSV variables are defined by "assigned values" instead of "raw

FourLeafCLover — Wed, 20 Jan 2021 19:07:13 GMT

Thank you Reeza, appreciate the reply. Is there a way to remove formats from all variables without specifying each one? I am having this issue with many variables, not just the one. Thanks

Re: When exporting to CSV variables are defined by "assigned values" instead of "raw

FourLeafCLover — Wed, 20 Jan 2021 19:10:13 GMT

Thanks Kurt for the quick reply, I do see the data step in the log after running the proc export. Is there code to be added to this data step that de-assigns all the formats. Thanks

Re: When exporting to CSV variables are defined by "assigned values" instead of "raw

Tom — Wed, 20 Jan 2021 19:21:32 GMT

You can use the _ALL_ variable list.

proc print data=have;
  format _all_;
run;

But watch out for date, time or datetime values. You will get the raw number of days or seconds instead if you remove the formats. You can add a second format statement to re-attach them.

proc print data=have;
  format _all_;
  format date yymmdd10. time time5. datetime datetime19.;
run;