topic Re: How to fill the header with raw data by using SAS in SAS Programming

How to fill the header with raw data by using SAS

Lakhinansrilath — Mon, 19 Dec 2022 09:53:18 GMT

This is header part

Re: How to fill the header with raw data by using SAS

ballardw — Mon, 19 Dec 2022 10:44:21 GMT

Header of what?

You're going to need to provide some context. Such as describe some details of the process and possibly the output destination.

Re: How to fill the header with raw data by using SAS

PaigeMiller — Mon, 19 Dec 2022 10:57:36 GMT

In order to write a SAS program, we need to know at least two things:

The SAS data set you are working with
The desired output

We need both of these spelled out clearly so there's no need for us to guess.

The SAS data set you are using should be provided as working SAS data step code, which you can type in yourself or use these instructions. We cannot work from data in Excel or other documents; we cannot work with screen captures.

Re: How to fill the header with raw data by using SAS

andreas_lds — Mon, 19 Dec 2022 11:29:19 GMT

Please provide more information: does the screenshot show the complete header? Where to put what? What must follow the header? For such questions providing data in usable form is a must-requirement.

Re: How to fill the header with raw data by using SAS

Lakhinansrilath — Tue, 20 Dec 2022 00:35:55 GMT

I kept a photo.I want fill that parameters by using SAS and that part is under header

Re: How to fill the header with raw data by using SAS

Lakhinansrilath — Tue, 20 Dec 2022 00:38:55 GMT

Yeah.The screenshot provide whole information regarding header.I want to fill that header with raw data

Re: How to fill the header with raw data by using SAS

Lakhinansrilath — Tue, 20 Dec 2022 05:20:33 GMT

I want prepare a patient profile form.In that I want to make a header(as we do in word for each and every page). For that header I have rawdata, So I want to fill that header with rawdata by using SAS.

Re: How to fill the header with raw data by using SAS

PaigeMiller — Tue, 20 Dec 2022 13:18:22 GMT

@Lakhinansrilath

You haven't provided us with any new information. You need to provide new additional information and detail. We need to see (a portion of) your data. (Do not ignore this part!) We need to understand what variables go where. (Do not ignore this part!) You need to explain this clearly, completely, and in detail, start to finish.

Re: How to fill the header with raw data by using SAS

Tom — Tue, 20 Dec 2022 16:40:59 GMT

@Lakhinansrilath wrote:

I want prepare a patient profile form.In that I want to make a header(as we do in word for each and every page). For that header I have rawdata, So I want to fill that header with rawdata by using SAS.

So this is getting closer to an explanation. You are creating patient profile report.

The header you are talking about is the header to this report.

So to do this you need to know what values you have in the data that correspond to the information in the header. Is there a variable with the patient id? What is the variable name? What are the other fields in the header? What are the variables that hold that information.

How are you generating the patient profile? Is a single PROC PRINT? Something else?

In general the way to add header lines to a report is to use TITLE statements. You can have up to ten TITLE statements to add up to 10 lines at the top of each page.

Re: How to fill the header with raw data by using SAS

ballardw — Tue, 20 Dec 2022 22:12:27 GMT

@Lakhinansrilath wrote:
Yeah.The screenshot provide whole information regarding header.I want to fill that header with raw data

"Raw data" from where? Is it in a data set? Is it in the same data set that the body of the report uses?

Do you expect to make multiple reports with different headers? If there are multiple reports do you have the body data in one data set or multiple?

Re: How to fill the header with raw data by using SAS

Lakhinansrilath — Wed, 21 Dec 2022 04:33:08 GMT

Yeah, SUBJID is the variable used for Patient ID.All the parameter what I took in the header are there in the rawdata(Which was provided by client). I generate Profile form by using raw data,I used to make normal tables according to Profileform and finally I used PROC PRINT.I used TITLE statements also.
If we make tables for rawdata It will automatically fill according to our codes.but in header(what I kept as screenshot) what I have to do to fill the data in header part which is not in table format.This is the main query?