topic Reference guides for Data representation in Tabular form in SAS Programming

Reference guides for Data representation in Tabular form

dennis_oz — Wed, 12 May 2021 01:51:34 GMT

Hi all,

I was looking for some blogs where it explains how data needs to be put tabular format for different business requirements .

for example

eg : capturing contacts from a customer . But when we need to have this reported every month how it needs to be done , how to go about doing that .

use table 2 or use table 3

customer	sms	phone	email
Mark
John

table 2
customer	sms_042021	phone_042021	email_042021	sms_052021	phone_052021	email_052021
Mark
John

table 3
customer	month	sms	phone	email
Mark	42021
Mark	52021
John	42021
John	52021

so looking for some blogs or documentation on similar scenarios.

sorry if I don't make sense . I did not know whether to post this message out there or not .. but I thought if I hold back there is nothing I am learning . I might as well ask an irrelevant question and be corrected on my approach that have this just kept in my mind .

thanks in advance !

Re: Reference guides for Data representation in Tabular form

japelin — Wed, 12 May 2021 02:27:36 GMT

It depends on what kind of data you currently have and what purpose you want to use the data for, but in general, normalized data is easier to work with.

Therefore, it is better to use table3. It is easy to extract monthly data.

Re: Reference guides for Data representation in Tabular form

andreas_lds — Wed, 12 May 2021 04:46:55 GMT

Difficult to suggest something without knowing the "different business requirements" you mention.

I would question then need to see old and maybe outdated contact information at all.

Re: Reference guides for Data representation in Tabular form

Sajid01 — Wed, 12 May 2021 11:39:21 GMT

Hello
The following blogs will help you understand the concepts of database design

https://en.wikipedia.org/wiki/Database_design

https://en.wikipedia.org/wiki/Database_schema

https://www.datavail.com/blog/an-introduction-to-database-design-from-logical-to-physical/

https://www.astera.com/type/blog/all-you-need-to-know-about-database-design/#:~:text=Database%20design%20is%20defined%20as,for%20the%20proposed%20database%20system.

You can also look at some of the sample databases that come with Microsoft Access and Microsoft SQL Server .
These resources will help how data needs to be put tabular format for different business. requirements.