Help using Base SAS procedures

Proc report

Reply
N/A
Posts: 0

Proc report

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
Valued Guide
Posts: 634

Re: Proc report

Posted in reply to deleted_user
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.
SAS Super FREQ
Posts: 8,868

Re: Proc report

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Proc report

Posted in reply to Cynthia_sas
@cynthia Sorry....i forgot to mention it. i thought it was a wrong place for posting my question
SAS Super FREQ
Posts: 8,868

Re: Proc report

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Proc report

Posted in reply to Cynthia_sas
yes Cynthia i got the answer from your post only
N/A
Posts: 0

Re: Proc report

Posted in reply to Cynthia_sas
@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
Ask a Question
Discussion stats
  • 6 replies
  • 237 views
  • 0 likes
  • 3 in conversation