CrossTable

[NiTo]

Hi Folks,

Trying to do a crosstable here but have no idea how to proceed. Please check the attached file.

The field secondary starta have 29 different attributes . Primary Strata Name is age group starting from 04, 5 - 17 n so on.

Secondary Strata Name too got number of attributes. 

Help pls

[Chanty4u]

Try this

Sample:

Load * inline [

    OrderID, CustomerID, Product1, Product2, Product3, Product4

    1, A, Apple, Banana, Orange, Mango

    2, B, Pear, Kiwi, , 

    3, C, , , , 

    4, D, Grape, , , 

    5, E, , , , 

];

Crosstable (Attribute, Value)

Load OrderID, CustomerID, Product1, Product2, Product3, Product4 Resident Sample;

[NiTo]

Hello Chanty,

Thanks for the reply. Unfortunately, it is not very clear to me. Help me to understand it better.

Cheers

[NiTo]

Please follow the link below:

https://covid.cdc.gov/covid-data-tracker/#covidnet-hospitalization-network

I am trying to achieve the first Visualization. Data is available you can download too. Thanks