Proc Export csv file - ending up with unreadable file

[wklierman]

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

[VDD · Accepted solution]

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"

[wklierman]

VDD-

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

Thanks for your help and expertise.

wklierman