I'm reading in an MS Access file:
libname enrsum access path='\\warehouse\freezes_official_2010.accdb';
Doing some processing on other fields, then writing the data to a file:
ods listing close;
ods csv file="t:\201910Tday15.csv" style=minimal;
Using a proc print statement:
proc print data=work.RECODE;
The format of the freeze_event from the Access file is 201910TDAY15. When the proc print puts it in a file, it adds question marks and looks like 201910?T?DAY15.
Why is it doing this and how do I fix it?
Is that variable in the ACCESS database a character variable or a date variable?
The symptom you describe sometimes indicates that a character variable contains characters that either the font you are using for the output (controlled by you active style) does not recognize the value or that there may be an encoding difference between the data base and your SAS session.
Does this have the same appearance if you use an ODS RTF destination instead? CSV files do not contain any font information. So depending on the font your application for viewing the CSV file with may not have definitions for certain characters.
Options could include creating a SAS data set and instead of sending results directly from the data base to csv (Access should do that directly) and 1) editing a character field 2) creating a SAS date value and using a SAS date format to display the value 3) changing font in the program viewing the csv 4) changing encoding of the dataset.
You might also change to using PROC Export to CSV instead ODS CSV by selecting the variables in a dataset option.
Secure your spot at the must-attend AI and analytics event of 2024: SAS Innovate 2024! Get ready for a jam-packed agenda featuring workshops, super demos, breakout sessions, roundtables, inspiring keynotes and incredible networking events.
Register by March 1 to snag the Early Bird rate of just $695! Don't miss out on this exclusive offer.
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.