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? 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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
  • 565 views
  • 0 likes
  • 4 in conversation