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
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"
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"
VDD-
That was the problem. I was staring at it and didn't register.
Thanks for your help and expertise.
wklierman
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.