The SAS Output Delivery System and reporting techniques

Above value getting repeated when blank values shown.

Reply
Contributor
Posts: 34

Above value getting repeated when blank values shown.

In dataset the value is like . And in report it's taking above value repeated wherever the . Is appearing .

For example :
Value1 2
Value2. .
In dataset

In report it's like
Value1. 2
Value2. 2


Repeats above value to below.
Super User
Posts: 6,936

Re: Above value getting repeated when blank values shown.

Show the code and state what your problem is.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Super User
Posts: 6,936

Re: Above value getting repeated when blank values shown.

And supply the source dataset in a data step.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Contributor
Posts: 34

Re: Above value getting repeated when blank values shown.


IMG_20170310_152836-1024x576.jpg
Contributor
Posts: 34

Re: Above value getting repeated when blank values shown.


IMG_20170310_152849-1024x576.jpg
Super User
Super User
Posts: 7,401

Re: Above value getting repeated when blank values shown.

When we ask for data in the form of a datastep, this doesn't mean take a picture of your screen which is of no help at all.  Follow this post:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-dat...

 

Once you have posted your test data, post your code - in a code window which is {i} above your post.  Also post any other relevant information such as logs with errors/warnings, explanation of logic etc. 

 

Only good quality questions will get good quality answers.

 

Ask a Question
Discussion stats
  • 5 replies
  • 276 views
  • 1 like
  • 3 in conversation