sdcTools / UserSupport

The place to be for User Support on SDC tools and to download the latest releases
https://sdctools.github.io/UserSupport/
Other
11 stars 3 forks source link

Metadata for tabular file #197

Closed ViragMistry closed 1 year ago

ViragMistry commented 1 year ago

SDC Tool Used: tau-argus Version: 4.2.3 Build 1 Operating System used: Windows

I wanted to create the 2 dimension table as under, 206105434-53f33ca3-64ed-4ffd-b859-84025fc66d54

Please guide me on table and metadata file structure.

I tried couple of options and getting below mention output,

206166177-3dcd7547-aafd-4153-b01a-f95bc40b0d27

Thank You.


ppdewolf commented 1 year ago

Depends a lot on the information you have available. First of all: do you have microdata or only tabular data for input? Assuming microdata input: see section 5.1.1 and 5.1.2 of the manual for meta data for microdata input. Assuming tabular data input: see section 5.1.4 of the manual for meta data for tabular input.

Using only the information you provide with your screenshots, assuming that the bold number is unsafe, you could use e.g.

table.rda:

<SEPARATOR> ";"
<SAFE> S
<UNSAFE> U
"Marital Status"
    <RECODABLE>
    <TOTCODE> "Total"
"Sex"
    <RECODABLE>
    <TOTCODE> "Total"
Respons
    <NUMERIC>
status
    <STATUS>

or alternatively, if it is a frequency table:

<SEPARATOR> ";"
<SAFE> S
<UNSAFE> U
"Marital Status"
    <RECODABLE>
    <TOTCODE> "Total"
"Sex"
    <RECODABLE>
    <TOTCODE> "Total"
freq
    <FREQUENCY>
status
    <STATUS>

and tabular data input table.tab:

"Total";"Total";70;S
"Total";"Male";48;S
"Total";"Female";22;S
"Married";"Total";55;S
"Married";"Male";38;S
"Married";"Female";17;S
"Divorced";"Total";11;S
"Divorced";"Male";7;S
"Divorced";"Female";4;S
"Single";"Total";4;S
"Single";"Male";3;S
"Single";"Female";1;U

Using the second .rda and the .tab as input for tau-argus, with "Use safety rules", "Maximum frequency", "Frequency=2" I get: afbeelding

ViragMistry commented 1 year ago

Thank you for your prompt response. I will try to go through the provided input and come back in case further guidance required.