09-21-2017 01:13 AM
Here is the problem i am facing while data preperation .
This invloves a column which has commodity names and includes several leveles(you can refer to the excel sheet attached).
i was asked to create a hierarchy from that column.
i have been trying by transposing the dataset , creating custom categories but all of them resulted nothing useful.
if there is any way i can get through this problem , please guide me.
thanks in advance
09-21-2017 06:33 AM
If you really want anyone to answer, you will have to do two things.
First, post a few lines of data instead of attaching a spreadsheet. Few people trust an online spreadsheet.
Second, describe what you mean by "hierarchy". What should the final result look like?
09-22-2017 12:48 AM
The data in excel sheet is like...
I primary articles
(A) Food Articles
Like this every level of data is in single column.I want this data to be in multiple columns for every level inside, to be able to create a hierarchy in sas va
comm_name1 comm_name2 Comm_name3 Comm_name4 Commm_name5
I Primary Articles (A) Food Articles a.Food Grains a.cereals Rice
I Primary Articles (A) Food Articles a.Food Grains a.cereals Wheat
I Primary Articles (A) Food Articles a.Food Grains a.cereals Jowar
. . . . .
. . . . .
if there is any way i can get it in sas va ....! or in sas eg, base sas ...