264.TEMPLES OF INDIA DATASET ANALYSIS USING PROC PRINT | PROC CONTENTS | PROC SORT | PROC FREQ | PROC MEANS | PROC SQL | PROC TABULATE | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC RANK | PROC SGPLOT

TEMPLES OF INDIA DATASET ANALYSIS USING PROC PRINT | PROC CONTENTS | PROC SORT | PROC FREQ | PROC MEANS | PROC SQL | PROC TABULATE | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC RANK | PROC SGPLOT | MACROS

/*Creating a dataset of different temple types in India*/

1. DATA CREATION: TEMPLES OF INDIA DATASET

options nocenter;

data temples_india;

length Temple_ID 8 Temple_Name $40 Location $25 State $20 Deity $20

Architecture_Style $25 Built_Year 8 Visitors_per_Year 8 Importance $30;

infile datalines dlm=',' dsd;

input Temple_ID Temple_Name $ Location $ State $ Deity $ Architecture_Style $

Built_Year Visitors_per_Year Importance $;

datalines;

1,Kashi Vishwanath,Varanasi,UttarPradesh,Shiva,Nagara,1780,8000000,Spiritual Hub

2,Meenakshi Amman,Madurai,TamilNadu,Meenakshi,Dravidian,1623,5000000,Cultural Heritage

3,Jagannath,Puri,Odisha,Jagannath,Kalinga,1161,7000000,Char Dham

4,Somnath,Veraval,Gujarat,Shiva,Chaulukya,1951,3000000,First Jyotirlinga

5,Tirupati Balaji,Tirupati,AndhraPradesh,Venkateswara,Dravidian,1130,25000000,Richest Temple

6,Golden Temple,Amritsar,Punjab,GuruNanak,Sikh,1604,6000000,Sikhism Central

7,Konark Sun,Konark,Odisha,Surya,Kalinga,1250,1500000,UNESCO Heritage

8,Kedarnath,Kedarnath,Uttarakhand,Shiva,Himalayan,800,2500000,Char Dham

9,Badrinath,Badrinath,Uttarakhand,Vishnu,Nagara,900,2000000,Char Dham

10,Akshardham,Delhi,Delhi,Swaminarayan,Modern,2005,3500000,Modern Wonder

11,Vaishno Devi,Katra,JammuKashmir,VaishnoDevi,CaveTemple,1100,10000000,Pilgrimage

12,Lingaraja,Bhubaneswar,Odisha,Shiva,Kalinga,1100,4000000,Historic

13,Brihadeeswarar,Thanjavur,TamilNadu,Shiva,Dravidian,1010,2000000,UNESCO Heritage

14,Siddhivinayak,Mumbai,Maharashtra,Ganesh,Modern,1801,5000000,Popular Pilgrimage

15,Ramanathaswamy,Rameswaram,TamilNadu,Shiva,Dravidian,1200,3500000,Char Dham

;

run;

proc print;run;

Output:

Obs	Temple_ID	Temple_Name	Location	State	Deity	Architecture_Style	Built_Year	Visitors_per_Year	Importance
1	1	Kashi Vishwanath	Varanasi	UttarPradesh	Shiva	Nagara	1780	8000000	Spiritual Hub
2	2	Meenakshi Amman	Madurai	TamilNadu	Meenakshi	Dravidian	1623	5000000	Cultural Heritage
3	3	Jagannath	Puri	Odisha	Jagannath	Kalinga	1161	7000000	Char Dham
4	4	Somnath	Veraval	Gujarat	Shiva	Chaulukya	1951	3000000	First Jyotirlinga
5	5	Tirupati Balaji	Tirupati	AndhraPradesh	Venkateswara	Dravidian	1130	25000000	Richest Temple
6	6	Golden Temple	Amritsar	Punjab	GuruNanak	Sikh	1604	6000000	Sikhism Central
7	7	Konark Sun	Konark	Odisha	Surya	Kalinga	1250	1500000	UNESCO Heritage
8	8	Kedarnath	Kedarnath	Uttarakhand	Shiva	Himalayan	800	2500000	Char Dham
9	9	Badrinath	Badrinath	Uttarakhand	Vishnu	Nagara	900	2000000	Char Dham
10	10	Akshardham	Delhi	Delhi	Swaminarayan	Modern	2005	3500000	Modern Wonder
11	11	Vaishno Devi	Katra	JammuKashmir	VaishnoDevi	CaveTemple	1100	10000000	Pilgrimage
12	12	Lingaraja	Bhubaneswar	Odisha	Shiva	Kalinga	1100	4000000	Historic
13	13	Brihadeeswarar	Thanjavur	TamilNadu	Shiva	Dravidian	1010	2000000	UNESCO Heritage
14	14	Siddhivinayak	Mumbai	Maharashtra	Ganesh	Modern	1801	5000000	Popular Pilgrimage
15	15	Ramanathaswamy	Rameswaram	TamilNadu	Shiva	Dravidian	1200	3500000	Char Dham

2. PROC PRINT: VIEW DATA

proc print data=temples_india noobs;

title "TEMPLES OF INDIA DATASET";

run;

Output:

TEMPLES OF INDIA DATASET


Temple_ID	Temple_Name	Location	State	Deity	Architecture_Style	Built_Year	Visitors_per_Year	Importance
1	Kashi Vishwanath	Varanasi	UttarPradesh	Shiva	Nagara	1780	8000000	Spiritual Hub
2	Meenakshi Amman	Madurai	TamilNadu	Meenakshi	Dravidian	1623	5000000	Cultural Heritage
3	Jagannath	Puri	Odisha	Jagannath	Kalinga	1161	7000000	Char Dham
4	Somnath	Veraval	Gujarat	Shiva	Chaulukya	1951	3000000	First Jyotirlinga
5	Tirupati Balaji	Tirupati	AndhraPradesh	Venkateswara	Dravidian	1130	25000000	Richest Temple
6	Golden Temple	Amritsar	Punjab	GuruNanak	Sikh	1604	6000000	Sikhism Central
7	Konark Sun	Konark	Odisha	Surya	Kalinga	1250	1500000	UNESCO Heritage
8	Kedarnath	Kedarnath	Uttarakhand	Shiva	Himalayan	800	2500000	Char Dham
9	Badrinath	Badrinath	Uttarakhand	Vishnu	Nagara	900	2000000	Char Dham
10	Akshardham	Delhi	Delhi	Swaminarayan	Modern	2005	3500000	Modern Wonder
11	Vaishno Devi	Katra	JammuKashmir	VaishnoDevi	CaveTemple	1100	10000000	Pilgrimage
12	Lingaraja	Bhubaneswar	Odisha	Shiva	Kalinga	1100	4000000	Historic
13	Brihadeeswarar	Thanjavur	TamilNadu	Shiva	Dravidian	1010	2000000	UNESCO Heritage
14	Siddhivinayak	Mumbai	Maharashtra	Ganesh	Modern	1801	5000000	Popular Pilgrimage
15	Ramanathaswamy	Rameswaram	TamilNadu	Shiva	Dravidian	1200	3500000	Char Dham

3. PROC CONTENTS: DATASET STRUCTURE

proc contents data=temples_india;

title "STRUCTURE OF TEMPLES DATASET";

run;

Output:

STRUCTURE OF TEMPLES DATASET

The CONTENTS Procedure


Data Set Name	WORK.TEMPLES_INDIA	Observations	15
Member Type	DATA	Variables	9
Engine	V9	Indexes	0
Created	08/18/2025 17:53:52	Observation Length	184
Last Modified	08/18/2025 17:53:52	Deleted Observations	0
Protection		Compressed	NO
Data Set Type		Sorted	NO
Label
Data Representation	SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64
Encoding	utf-8 Unicode (UTF-8)


Engine/Host Dependent Information
Data Set Page Size	131072
Number of Data Set Pages	1
First Data Page	1
Max Obs per Page	711
Obs in First Data Page	15
Number of Data Set Repairs	0
Filename	/saswork/SAS_workC4D90001979C_odaws02-apse1-2.oda.sas.com/SAS_workFA150001979C_odaws02-apse1-2.oda.sas.com/temples_india.sas7bdat
Release Created	9.0401M8
Host Created	Linux
Inode Number	1153671
Access Permission	rw-r--r--
Owner Name	u63247146
File Size	256KB
File Size (bytes)	262144


Alphabetic List of Variables and Attributes
#	Variable	Type	Len
6	Architecture_Style	Char	25
7	Built_Year	Num	8
5	Deity	Char	20
9	Importance	Char	30
3	Location	Char	25
4	State	Char	20
1	Temple_ID	Num	8
2	Temple_Name	Char	40
8	Visitors_per_Year	Num	8

4. PROC SORT: SORT TEMPLES BY VISITORS

proc sort data=temples_india out=sorted_temples;

by descending Visitors_per_Year;

run;

proc print data=sorted_temples(obs=5);

title "TOP 5 MOST VISITED TEMPLES";

run;

Output:

TOP 5 MOST VISITED TEMPLES


Obs	Temple_ID	Temple_Name	Location	State	Deity	Architecture_Style	Built_Year	Visitors_per_Year	Importance
1	5	Tirupati Balaji	Tirupati	AndhraPradesh	Venkateswara	Dravidian	1130	25000000	Richest Temple
2	11	Vaishno Devi	Katra	JammuKashmir	VaishnoDevi	CaveTemple	1100	10000000	Pilgrimage
3	1	Kashi Vishwanath	Varanasi	UttarPradesh	Shiva	Nagara	1780	8000000	Spiritual Hub
4	3	Jagannath	Puri	Odisha	Jagannath	Kalinga	1161	7000000	Char Dham
5	6	Golden Temple	Amritsar	Punjab	GuruNanak	Sikh	1604	6000000	Sikhism Central

5. PROC FREQ: FREQUENCY OF STATES

proc freq data=temples_india;

tables State;

title "FREQUENCY OF TEMPLES BY STATE";

run;

Output:

FREQUENCY OF TEMPLES BY STATE

The FREQ Procedure


State	Frequency	Percent	Cumulative Frequency	Cumulative Percent
AndhraPradesh	1	6.67	1	6.67
Delhi	1	6.67	2	13.33
Gujarat	1	6.67	3	20.00
JammuKashmir	1	6.67	4	26.67
Maharashtra	1	6.67	5	33.33
Odisha	3	20.00	8	53.33
Punjab	1	6.67	9	60.00
TamilNadu	3	20.00	12	80.00
UttarPradesh	1	6.67	13	86.67
Uttarakhand	2	13.33	15	100.00

6. PROC MEANS: VISITOR STATISTICS

proc means data=temples_india mean min max maxdec=2;

var Visitors_per_Year Built_Year;

title "VISITOR STATISTICS FOR TEMPLES";

run;

Output:

VISITOR STATISTICS FOR TEMPLES

The MEANS Procedure


Variable	Mean	Minimum	Maximum
Visitors_per_Year Built_Year	5866666.67 1361.00	1500000.00 800.00	25000000.00 2005.00

7. PROC SQL: ADVANCED QUERIES

proc sql outobs=3;

title "TEMPLES BUILT BEFORE 1200";

select Temple_Name, State, Built_Year

from temples_india

where Built_Year < 1200;

title "TOP 3 TEMPLES BY VISITORS";

select Temple_Name, State, Visitors_per_Year

from temples_india

order by Visitors_per_Year desc;

quit;

Output:

TEMPLES BUILT BEFORE 1200


Temple_Name	State	Built_Year
Jagannath	Odisha	1161
Tirupati Balaji	AndhraPradesh	1130
Kedarnath	Uttarakhand	800

TOP 3 TEMPLES BY VISITORS


Temple_Name	State	Visitors_per_Year
Tirupati Balaji	AndhraPradesh	25000000
Vaishno Devi	JammuKashmir	10000000
Kashi Vishwanath	UttarPradesh	8000000

8. PROC TABULATE: VISITORS SUMMARY BY STATE

proc tabulate data=temples_india;

class State;

var Visitors_per_Year;

table State, Visitors_per_Year*(mean sum max);

title "SUMMARY OF VISITORS BY STATE";

run;

Output:

SUMMARY OF VISITORS BY STATE


	Visitors_per_Year
	Mean	Sum	Max
State	25000000.00	25000000.00	25000000.00
AndhraPradesh	25000000.00	25000000.00	25000000.00
Delhi	3500000.00	3500000.00	3500000.00
Gujarat	3000000.00	3000000.00	3000000.00
JammuKashmir	10000000.00	10000000.00	10000000.00
Maharashtra	5000000.00	5000000.00	5000000.00
Odisha	4166666.67	12500000.00	7000000.00
Punjab	6000000.00	6000000.00	6000000.00
TamilNadu	3500000.00	10500000.00	5000000.00
UttarPradesh	8000000.00	8000000.00	8000000.00
Uttarakhand	2250000.00	4500000.00	2500000.00

9. PROC REPORT: FORMATTED REPORT

proc report data=temples_india nowd;

column Temple_Name State Deity Visitors_per_Year;

define Temple_Name / "Temple";

define State / group;

define Deity / display;

define Visitors_per_Year / analysis sum "Total Visitors";

title "REPORT OF TEMPLES WITH TOTAL VISITORS";

run;

Output:

REPORT OF TEMPLES WITH TOTAL VISITORS


Temple	State	Deity	Total Visitors
Tirupati Balaji	AndhraPradesh	Venkateswara	25000000
Akshardham	Delhi	Swaminarayan	3500000
Somnath	Gujarat	Shiva	3000000
Vaishno Devi	JammuKashmir	VaishnoDevi	10000000
Siddhivinayak	Maharashtra	Ganesh	5000000
Jagannath	Odisha	Jagannath	7000000
Konark Sun		Surya	1500000
Lingaraja		Shiva	4000000
Golden Temple	Punjab	GuruNanak	6000000
Meenakshi Amman	TamilNadu	Meenakshi	5000000
Brihadeeswarar		Shiva	2000000
Ramanathaswamy		Shiva	3500000
Kashi Vishwanath	UttarPradesh	Shiva	8000000
Kedarnath	Uttarakhand	Shiva	2500000
Badrinath		Vishnu	2000000

10. PROC TRANSPOSE: TRANSFORM DATA

proc transpose data=temples_india out=transpose_temples prefix=Temple_;

id Temple_ID;

var Visitors_per_Year;

run;

proc print data=transpose_temples;

title "TRANSPOSED DATASET OF VISITORS";

run;

Output:

TRANSPOSED DATASET OF VISITORS


Obs	_NAME_	Temple_1	Temple_2	Temple_3	Temple_4	Temple_5	Temple_6	Temple_7	Temple_8	Temple_9	Temple_10	Temple_11	Temple_12	Temple_13	Temple_14	Temple_15
1	Visitors_per_Year	8000000	5000000	7000000	3000000	25000000	6000000	1500000	2500000	2000000	3500000	10000000	4000000	2000000	5000000	3500000

11. PROC FORMAT: CUSTOM FORMATTING

proc format;

value visitorfmt

low-2000000 = "Low Visitors"

2000001-6000000 = "Medium Visitors"

6000001-high = "High Visitors";

run;

proc print data=temples_india;

format Visitors_per_Year visitorfmt.;

title "TEMPLES CLASSIFIED BY VISITOR RANGE";

run;

Output:

TEMPLES CLASSIFIED BY VISITOR RANGE


Obs	Temple_ID	Temple_Name	Location	State	Deity	Architecture_Style	Built_Year	Visitors_per_Year	Importance
1	1	Kashi Vishwanath	Varanasi	UttarPradesh	Shiva	Nagara	1780	High Visitors	Spiritual Hub
2	2	Meenakshi Amman	Madurai	TamilNadu	Meenakshi	Dravidian	1623	Medium Visitors	Cultural Heritage
3	3	Jagannath	Puri	Odisha	Jagannath	Kalinga	1161	High Visitors	Char Dham
4	4	Somnath	Veraval	Gujarat	Shiva	Chaulukya	1951	Medium Visitors	First Jyotirlinga
5	5	Tirupati Balaji	Tirupati	AndhraPradesh	Venkateswara	Dravidian	1130	High Visitors	Richest Temple
6	6	Golden Temple	Amritsar	Punjab	GuruNanak	Sikh	1604	Medium Visitors	Sikhism Central
7	7	Konark Sun	Konark	Odisha	Surya	Kalinga	1250	Low Visitors	UNESCO Heritage
8	8	Kedarnath	Kedarnath	Uttarakhand	Shiva	Himalayan	800	Medium Visitors	Char Dham
9	9	Badrinath	Badrinath	Uttarakhand	Vishnu	Nagara	900	Low Visitors	Char Dham
10	10	Akshardham	Delhi	Delhi	Swaminarayan	Modern	2005	Medium Visitors	Modern Wonder
11	11	Vaishno Devi	Katra	JammuKashmir	VaishnoDevi	CaveTemple	1100	High Visitors	Pilgrimage
12	12	Lingaraja	Bhubaneswar	Odisha	Shiva	Kalinga	1100	Medium Visitors	Historic
13	13	Brihadeeswarar	Thanjavur	TamilNadu	Shiva	Dravidian	1010	Low Visitors	UNESCO Heritage
14	14	Siddhivinayak	Mumbai	Maharashtra	Ganesh	Modern	1801	Medium Visitors	Popular Pilgrimage
15	15	Ramanathaswamy	Rameswaram	TamilNadu	Shiva	Dravidian	1200	Medium Visitors	Char Dham

12. PROC RANK: RANK TEMPLES BY VISITORS

proc rank data=temples_india out=ranked_temp descending ties=low;

var Visitors_per_Year;

ranks Visitors_Rank;

run;

proc print data=ranked_temp;

title "RANKED TEMPLES BY VISITORS";

run;

Output:

RANKED TEMPLES BY VISITORS


Obs	Temple_ID	Temple_Name	Location	State	Deity	Architecture_Style	Built_Year	Visitors_per_Year	Importance	Visitors_Rank
1	1	Kashi Vishwanath	Varanasi	UttarPradesh	Shiva	Nagara	1780	8000000	Spiritual Hub	3
2	2	Meenakshi Amman	Madurai	TamilNadu	Meenakshi	Dravidian	1623	5000000	Cultural Heritage	6
3	3	Jagannath	Puri	Odisha	Jagannath	Kalinga	1161	7000000	Char Dham	4
4	4	Somnath	Veraval	Gujarat	Shiva	Chaulukya	1951	3000000	First Jyotirlinga	11
5	5	Tirupati Balaji	Tirupati	AndhraPradesh	Venkateswara	Dravidian	1130	25000000	Richest Temple	1
6	6	Golden Temple	Amritsar	Punjab	GuruNanak	Sikh	1604	6000000	Sikhism Central	5
7	7	Konark Sun	Konark	Odisha	Surya	Kalinga	1250	1500000	UNESCO Heritage	15
8	8	Kedarnath	Kedarnath	Uttarakhand	Shiva	Himalayan	800	2500000	Char Dham	12
9	9	Badrinath	Badrinath	Uttarakhand	Vishnu	Nagara	900	2000000	Char Dham	13
10	10	Akshardham	Delhi	Delhi	Swaminarayan	Modern	2005	3500000	Modern Wonder	9
11	11	Vaishno Devi	Katra	JammuKashmir	VaishnoDevi	CaveTemple	1100	10000000	Pilgrimage	2
12	12	Lingaraja	Bhubaneswar	Odisha	Shiva	Kalinga	1100	4000000	Historic	8
13	13	Brihadeeswarar	Thanjavur	TamilNadu	Shiva	Dravidian	1010	2000000	UNESCO Heritage	13
14	14	Siddhivinayak	Mumbai	Maharashtra	Ganesh	Modern	1801	5000000	Popular Pilgrimage	6
15	15	Ramanathaswamy	Rameswaram	TamilNadu	Shiva	Dravidian	1200	3500000	Char Dham	9

13. PROC SGPLOT: VISUALIZATION

proc sgplot data=temples_india;

vbar State / response=Visitors_per_Year stat=sum;

title "VISITOR DISTRIBUTION ACROSS STATES";

run;

Output:

proc sgplot data=temples_india;

scatter x=Built_Year y=Visitors_per_Year / datalabel=Temple_Name;

title "VISITORS VS. BUILT YEAR OF TEMPLES";

run;

Output:

14. MACROS: AUTOMATING ANALYSIS

%macro top_temples(n);

proc sql outobs=&n;

title "TOP &n TEMPLES BY VISITORS";

select Temple_Name, State, Visitors_per_Year

from temples_india

order by Visitors_per_Year desc

quit;

%mend;

%top_temples(5);

Output:

TOP 5 TEMPLES BY VISITORS


Temple_Name	State	Visitors_per_Year
Tirupati Balaji	AndhraPradesh	25000000
Vaishno Devi	JammuKashmir	10000000
Kashi Vishwanath	UttarPradesh	8000000
Jagannath	Odisha	7000000
Golden Temple	Punjab	6000000

%macro temples_by_state(st);

proc sql;

title "TEMPLES IN &st";

select Temple_Name, Deity, Visitors_per_Year

from temples_india

where State="&st";

quit;

%mend;

%temples_by_state(TamilNadu);

Output:

TEMPLES IN TamilNadu


Temple_Name	Deity	Visitors_per_Year
Meenakshi Amman	Meenakshi	5000000
Brihadeeswarar	Shiva	2000000
Ramanathaswamy	Shiva	3500000

%temples_by_state(Odisha);

Output:

TEMPLES IN Odisha


Temple_Name	Deity	Visitors_per_Year
Jagannath	Jagannath	7000000
Konark Sun	Surya	1500000
Lingaraja	Shiva	4000000

To Visit My Previous E-Commerce Dataset:Click Here
To Visit My Previous Length,Input,Retain Statements:Click Here
To Visit My Previous Urban Traffic Dataset:Click Here
To Visit My Previous Home Energy Consumption Dataset:Click Here

--->PLEASE FOLLOW OUR BLOG FOR MORE INFORMATION.
--->PLEASE DO COMMENTS AND SHARE OUR BLOG.

PLEASE FOLLOW OUR TELEGRAM CHANNEL CLICK HERE

PLEASE FOLLOW OUR FACEBOOK PAGE CLICK HERE

PLEASE FOLLOW OUR INSTAGRAM PAGE CLICK HERE

Sas All

Search This Blog

264.TEMPLES OF INDIA DATASET ANALYSIS USING PROC PRINT | PROC CONTENTS | PROC SORT | PROC FREQ | PROC MEANS | PROC SQL | PROC TABULATE | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC RANK | PROC SGPLOT | MACROS

TEMPLES OF INDIA DATASET ANALYSIS USING PROC PRINT | PROC CONTENTS | PROC SORT | PROC FREQ | PROC MEANS | PROC SQL | PROC TABULATE | PROC REPORT | PROC TRANSPOSE | PROC FORMAT | PROC RANK | PROC SGPLOT | MACROS

Comments

Post a Comment