topic Re: Proc report in SAS Procedures

Proc report

deleted_user — Tue, 07 Dec 2010 18:58:11 GMT

Hello if anyone know the solution please reply me

i have a data set with around 40 variables and 20 observarions
i need to produce a report for that in the below mentioned way

1.each observation in a page i.e 20 observations in 20 pages

2.one obervation has only 18 variables and the data and in the remaining 2 variables s missing.

report for this observation should have only 18 variables and the variables with missing data must be removed.

for this program with proc report i need to give all the 40 variable names in the column statement.

is there any other way to solve this without giving the 40 variable names
since i have many data sets with different variable names

Thanks
Sid

Re: Proc report

ArtC — Tue, 07 Dec 2010 19:34:22 GMT

Help me here a bit. rows are observations. Variables columns.

You have a data set with 40 variables and 20 observations and you want to report on one observation at a time. OK so far,

But in the 2) portion of your post you have 18 variables, do you mean observations? You want to only include non-missing data in your report?

Perhaps if you gave us a dummy example, it might help us understand. Say 3 rows and 4 columns of made up data.

Re: Proc report

Cynthia_sas — Tue, 07 Dec 2010 19:50:24 GMT

Art asks good questions. Also, you do not need to post your question in multiple forums. I posted a response to this question in the ODS and Reporting forum.

cynthia

Re: Proc report

deleted_user — Tue, 07 Dec 2010 21:12:12 GMT

@cynthia Sorry....i forgot to mention it. i thought it was a wrong place for posting my question

Re: Proc report

deleted_user — Tue, 07 Dec 2010 21:14:00 GMT

@art i got the answer for my question

one observation has 38 variables means the other 2 variables has missing data in the total 40 variables.
variables are columns and observations are rows

each row has 40 columns

Re: Proc report

Cynthia_sas — Tue, 07 Dec 2010 21:20:17 GMT

Hi:
Generally, PROC REPORT, PROC TABULATE go hand-in-hand with ODS for reporting. So it was an OK place to post your original question.

Did you look at the program I posted??? It shows a similar data scenario - -using SASHELP.CLASS -- but with only 3 rows and 5 variables. However, one of the rows has missing values for 2 of the variables -- so except for the number of rows and the number of variables, the situation in my program will illustrate the fact that you cannot "remove" the column header for the 2 missing values.

cynthia

Re: Proc report

deleted_user — Tue, 07 Dec 2010 23:34:02 GMT

yes Cynthia i got the answer from your post only