Proc Export csv file - ending up with unreadable file

wklierman — Thu, 03 Oct 2019 23:11:29 GMT

I have applied Proc Export in the following manner:

Proc Export
Data= Stg_Out6.Sums_diff_ALL_datastep
dbms=csv
OUTFILE = "I:\Health Analytics\Health Complexity Validation\Cmplex_hlth_state_counts_2019_2018"
REPLACE;
Run;

the corresponding log confirms that the file was successfully created:

NOTE: DATA statement used (Total process time):
real time 0.06 seconds
cpu time 0.00 seconds

7670 records created in I:\Health Analytics\Health Complexity
Validation\Cmplex_hlth_state_counts_2019_2018 from STG_OUT6.SUMS_DIFF_ALL_DATASTEP.

NOTE: "I:\Health Analytics\Health Complexity Validation\Cmplex_hlth_state_counts_2019_2018"
file was successfully created.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.17 seconds
cpu time 0.07 seconds

However,

after I find the file it is not the usual csv icon but a white icon with twi little green dots in the NE corner (sorry but

wasn't able to copy).

When I click on the icon I get the screen "How Do You Want To Open This File?"

I routinely run the export procedure without a hitch (this is a smallish file 7,670 obs).

Your expertise is appreciated, as always.

Thanks.

wlierman

Re: Proc Export csv file - ending up with unreadable file

VDD — Thu, 03 Oct 2019 23:26:05 GMT

try to add the .csv to this

OUTFILE = "I:\Health Analytics\Health Complexity Validation\Cmplex_hlth_state_counts_2019_2018"

like this

OUTFILE = "I:\Health Analytics\Health Complexity Validation\Cmplex_hlth_state_counts_2019_2018.csv"

Re: Proc Export csv file - ending up with unreadable file

wklierman — Thu, 03 Oct 2019 23:30:39 GMT

VDD-

That was the problem. I was staring at it and didn't register.

Thanks for your help and expertise.

wklierman

topic Proc Export csv file - ending up with unreadable file in SAS Programming

Proc Export csv file - ending up with unreadable file

Re: Proc Export csv file - ending up with unreadable file

Re: Proc Export csv file - ending up with unreadable file