Challenge #36: Data Cleansing Extract Authors

[danielhoge]

Spoiler

[99tyler99]

[afnfyz]

I am getting more and more comfortable with the crosstab and transpose tools!

Spoiler

[Carolyn]

Solved - this was a good one 

Spoiler

[Tofel]

Spoiler

[AndrewDMerrill]

Simple but useful problem

Spoiler

[sknman92]

solution attached!

[Rob-Silk]

My solution below:

Spoiler

[fluteman]

This one required some formatting. You need to determine each block of information as its own Unique ID; You also need to figure out which rows in a given block pertain to a given book variable indicated by AB-; TI- etc. Watch out for paragraphs within the TI and AB what contain words with a -, these will throw off the formatting.

Then you pair your unique ID with the actual PMID;

Filter on FAU.

I used summarize by concatenate by ";" and then text to columns (30) splitting this cell. 

As a check I measured how many authors were against each book. there's a book with 264 authors; so I capped my columns at 30 and thought that was the gist of this exercise!

[jennifer_owens]

attached!