topic which one is the correct about .csv file ? in ODS and Base Reporting

which one is the correct about .csv file ?

tianerhu — Thu, 09 Sep 2021 18:45:00 GMT

libname cert 'C:\SAS data and program\data\data set used in OG of SAS base\cert';
%let Location = USA;
data work.FlightEmpData;
set Cert.empdata cert.empdatu cert.empdatu2;
where Country = "&Location" and Salary >= 30000;
run;
proc sort data = work.FlightEmpData;
by descending Salary;
run;
proc export data = work.FlightEmpData
            outfile = 'C:\SAS data and program\program\10 scenarios of sas base OG\FlightEmpData.csv'
            dbms = csv
			replace;
run;

the code above generate a .csv file , like excel , like the following :

but the answer on the textbook : (it's a notepad)

how to generate a notepad as the answer on the book ?

Re: which one is the correct about .csv file ?

Kurt_Bremser — Thu, 09 Sep 2021 19:46:45 GMT

Open the file with Notepad instead of Excel. Right-click, select "Open with", and then Notepad (or another text editor).

Re: which one is the correct about .csv file ?

Tom — Thu, 09 Sep 2021 20:13:08 GMT

A CSV file is a text file. Why post a photograph text? Why not just post the text from the file? For example from the command line just use the DOS type command to display the text of the file. Or open the file with a text editor like notepad and then copy and paste the lines of text.

Be very careful opening a CSV with Excel as Excel will transform some of the text in the file based on its assumptions. For example strings with digits separated by hyphens might get converted into a date value by Excel.

Re: which one is the correct about .csv file ?

Reeza — Thu, 09 Sep 2021 20:47:26 GMT

CSV files open by default with Excel but CSV literally means comma (semicolon) separated data in a text file.
So open your file with NotePad and it will be exactly the same as the image.

In general, you actually shouldn't get in the habit of opening CSV with Excel. When you do that, Excel essentially runs it's own PROC IMPORT in the back end and converts the data so it may not match the text file. I once spent a long time debugging an issue with dates because Excel showed them as MMDDYY but they were actually DDMMYY in the CSV file. Never wasting 4 hours on that again.

Re: which one is the correct about .csv file ?

tianerhu — Thu, 09 Sep 2021 21:42:40 GMT

Right-click on the file

select propertises

click Change...

select notepad

select Ok

select apply

This method works.

Thank you all for your helps.