SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

Returning a blank cell when data is not inputted yet.

Reply
Occasional Learner
Posts: 1

Returning a blank cell when data is not inputted yet.

I would like the cell to return a blank when a date has not been entered yet for this formula but can not seem to complete this formula to accomplish this. Please help

 

="QTR"& INT((MONTH(Table2[@[Observation Date]])-1)/3)+1

Super User
Posts: 10,466

Re: Returning a blank cell when data is not inputted yet.

Looks more like an Excel question than SAS. I would find a forum for Excel for this question.

Ask a Question
Discussion stats
  • 1 reply
  • 191 views
  • 0 likes
  • 2 in conversation