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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
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.