proc export data = work.flightempdata
outfile = "C:\Users\li\Documents\My SAS Files\prep guide\base\practice data\cert\flightempdata.csv"
dbms = CSV
replace;
run;
additionally, the four value from the second to fifth of the column date is missing . why?
the answer is like following:
Get it . Thank you for your help .
No. The correct answer is:
NEVER USE EXCEL TO INSPECT A CSV FILE.
Use a proper text editor instead.
Thank you for your help.
@tianerhu wrote:
proc export data = work.flightempdata outfile = "C:\Users\li\Documents\My SAS Files\prep guide\base\practice data\cert\flightempdata.csv" dbms = CSV replace; run;
additionally, the four value from the second to fifth of the column date is missing . why?
the answer is like following:
What missing dates? Excel is showing ********, nothing missing. It does that when the value in the expected display format will not fit. Make the column wider if you really must see the data in Excel. Not a good idea as if you accidentally "save" the file while open in Excel you may find the actual values in a CSV file get changed because Excel already did one conversion to internal preferences to display the values.
Thank you for your help.
Don’t miss the livestream kicking off May 7. It’s free. It’s easy. And it’s the best seat in the house.
Join us virtually with our complimentary SAS Innovate Digital Pass. Watch live or on-demand in multiple languages, with translations available to help you get the most out of every session.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.