topic Re: How to make a report in SAS ??? in SAS Programming

How to Make a Report in SAS ???

Mohan_Reddy — Tue, 03 Mar 2020 12:22:00 GMT

Through this below existing dataset(First picture) i want make a report like second picture........Please write a code for this SAS Task ...

First Picture : Existing dataset

Second Picture : Output Report

Re: How to Make a Report in SAS ???

Kurt_Bremser — Tue, 03 Mar 2020 12:37:24 GMT

Please support us in supporting you, by writing the data step code to create the example dataset.

Re: How to Make a Report in SAS ???

ballardw — Tue, 03 Mar 2020 16:07:35 GMT

It is very hard to code against pictures. And in this case, I can't get the text of the "dataset" picture to be legible due to orientation and font size.

For your report you would likely also have to tell us whether the headings "EAG + PCG", "Niki" and what ever that cutoff heading is, come from values of one or more variables or not. Also any whether any of the fields in the body are supposed to be summaries such as sums (and from which variable(s) ) or grouping values and using which variable(s).

Re: How to Make a Report in SAS ???

Mohan_Reddy — Wed, 04 Mar 2020 03:50:02 GMT

I Have attached one excel file..so please import that excel file to SAS..Then see below picture and i want make a report like exactly show in this picture..please write a report code for this...r this...

How to make a Report in SAS ??

Mohan_Reddy — Wed, 04 Mar 2020 04:42:51 GMT

I have attached Excel file..please import that file into SAS..then make a report like below picture exactly...please help us in programme.

How to make a report in SAS ???

Mohan_Reddy — Wed, 04 Mar 2020 05:25:19 GMT

I have attached some Excel files ..Through that files want to make a report like below picture shown.Please make a programme for that..

Re: How to make a report in SAS ???

Patrick — Wed, 04 Mar 2020 05:35:46 GMT

You will likely need to amend your question/request for people to give you helpful answers.

Here some guidance how you could improve your question.

Re: How to make a Report in SAS ??

andreas_lds — Wed, 04 Mar 2020 05:48:28 GMT

Please stop double-posting questions! Fix issues with the way you are asking for help in the original-message. You message still lacks relevant information: you have not explained anything and you have not posted data in an usable form.

Re: How to make a report in SAS ???

Kurt_Bremser — Wed, 04 Mar 2020 07:55:52 GMT

I merged the multiple posts back into the original one.

Do NOT double-post.
Supply example data in usable form, in data steps with datalines, so we can recreate the data with a simple copy/paste and submit.
Excel files are blocked from downloading at many corporate sites, and they can not convey all the important information contained in a dataset; they are mostly useless.
If you post pictures at all, take care that they are correctly oriented. We're not fond of working with our heads turned sideways.
If you already have a visual sample of a report, how was that created? Show the code.
Show the code you already tried.
Don't just ask "write the code for me". If you need a consultant to do your work for you, hire one. Again, show what you tried, including logs and results that did not meet your expectations.

Re: How to make a report in SAS ???

ballardw — Wed, 04 Mar 2020 18:11:37 GMT

The first step in creating a report in SAS is going to be creating a SAS data set.

Do you have your data in SAS? If so then you can provide a useable example of the data in the form of a data step.

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Reasons XLS (besides being old formats) are not good:

1) we do not know if some fields should be character or numeric, which becomes very important when combining multiple sources of data, or what the maximum length of a character variable should be

2) frequently spreadsheets will have mixed types of data in a single column which means that lots of work will need to be done to get a useable SAS data set

3) block data formats with columns meaning different things on different rows

4) values that need to be available for each record in a data set for processing occur on only one row or as a column heading

5) data in column headings such as dates or store names

6) characteristics of importance indicated with color, comments or font and border appearance, not the actual values.

7) summary values, and sometimes not even indicated as such, in rows and/or columns

That is just for starters.