BookmarkSubscribeRSS Feed
aj34321
Quartz | Level 8

D/All,

SAS programs when executed on SAS 9.1.3 produces a null for all missing value when exported to CSV where as SAS 9.4 produces a period ( . ) for all the missing values in the dataset.

Is there a way to resolve this defect without changing the code. I have 5000+ source codes hence cannot take risk of updating all the codes.

Experts request your advice.

Thanks to everybody.. This forum & all experts are really awesome & helpful for almost any kind of issues we guys face.

Rgds, Anil

2 REPLIES 2
SASKiwi
PROC Star

This is not a defect. Most likely your SAS 9.1.3 has the SAS MISSING option set and SAS 9.4 doesn't. Add the statement: OPTIONS MISSING  = ''; to SAS 9.4.

Fugue
Quartz | Level 8

Are you using PROC EXPORT or ODS or ???

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

Explore Now →
How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 1936 views
  • 1 like
  • 3 in conversation