BookmarkSubscribeRSS Feed
yogita_patel
Calcite | Level 5

Hello, I have final dataset for adae treatment related which shows 0 as missing value . but when i create proc report then those 0s are just blank. I dont how it is happening?

as final dataset looks all fine

 

3 REPLIES 3
PaigeMiller
Diamond | Level 26

@yogita_patel wrote:

Hello, I have final dataset for adae treatment related which shows 0 as missing value . but when i create proc report then those 0s are just blank. I dont how it is happening?

as final dataset looks all fine

 


More details, please! Show us a portion of this data set where you see the missing values. Also, SHOW US what you are seeing from PROC REPORT.

--
Paige Miller
HB
Barite | Level 11 HB
Barite | Level 11

One might guess

proc report data=yourdata missing;

 

but actual data, your current programming effort, and a desired output will get you more help.

tarheel13
Rhodochrosite | Level 12

did you try options missing=0? 

SAS Innovate 2025: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!

Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 3 replies
  • 787 views
  • 0 likes
  • 4 in conversation