topic how to create multiple dimension table for repporting in SAS Programming

how to create multiple dimension table for repporting

Ashwini — Sat, 02 Jun 2012 12:57:59 GMT

I have a data set like below mention table

stroll	stid	stname	math	science	history	geography	total	class	grade
111	s111	AA	60	50	45	60	215	I	B
212	s212	BB	70	50	30	60	210	II	B
324	S324	CC	70	80	50	70	270	III	A
456	S456	DD	60	70	60	60	250	IV	A
578	S578	EE	70	30	30	60	190	V	C
678	S678	FF	40	60	40	40	180	VI	B
789	S789	CC	60	40	50	70	220	VII	B
987	S987	GG	80	30	40	50	200	IX	A

I want to create a cross table using above data as below mention table like

student name verses total mark percentage

stroll

stid

math

science

history

geography

total

class

grade

Please help me to solve this ASAP.

Thanks and Regards,

Ashwini

Re: how to create multiple dimension table for repporting

Tom — Sat, 02 Jun 2012 14:44:31 GMT

Can you describe what you want?

Do you just want to transpose the data? Or are you trying to summarize it in some way?

Re: how to create multiple dimension table for repporting

Ashwini — Sat, 02 Jun 2012 18:17:09 GMT

Dear Tom,

I want a summarized data .

I want to create a cross table contain as below mention table .I want percentage each student as mention below report

student name * total mark percentage

stroll

stid

math

science

history

geography

total

class

grade

Re: how to create multiple dimension table for repporting

Tom — Sun, 03 Jun 2012 00:21:35 GMT

Still doesn't make any sense. Perhaps if you put in some actual numbers?

What are the variable STROLL and STID? They look to me like student ID numbers. So do you want one row per student? Then what variable are you summarizing away? Why do you still have columns for MATH, SCIENCE, etc if you want to summarize grades?

You seem to want to make columns for each student (assuming the variable STNAME is student name). What number is it that you want to appear under column for when STNAME='AA'? How many rows do you expect to see in the result for your sample data?

Re: how to create multiple dimension table for repporting

Ksharp — Mon, 04 Jun 2012 05:09:37 GMT

As Tom said, still can't understand what you want .

data have;
infile datalines expandtabs;
input stroll $     stid $     stname      $ math     science     history     geography     total     class $     grade $;
datalines;
111     s111     AA     60     50     45     60     215     I     B
212     s212     BB     70     50     30     60     210     II     B
324     S324     CC     70     80     50     70     270     III     A
456     S456     DD     60     70     60     60     250     IV     A
578     S578     EE     70     30     30     60     190     V     C
678     S678     FF     40     60     40     40     180     VI     B
789     S789     CC     60     40     50     70     220     VII     B
987     S987     GG     80     30     40     50     200     IX     A
;
run;
proc tabulate data=have;
class stroll     stid      math     science     history     geography      class     grade  stname ;
var total ;
table stroll*stid*math     *science*     history*     geography*     class*     grade ,stname*total*pctsum;
run;

Ksharp