Hi, I am using Eurostat data for one project, I download them using:
But I have a problem since seasonally adjusted and unadjusted data are being exported into the same column, thus creating duplicates. Is there a way for me to split the variable into separate variables according to the seasonal adjustment identifier in a way that there will be no duplicates?
Or alternatively, is there a way how to import them individually in the first place?
So far I tried to generate new variables by the seasonal adjustment identifier, but the problem is that when I do this the new variables have values not next to each other but in a sort of staircase-like fashion:
and thus I have a problem with duplicates. What I would like would be to have them like
Thanks for any help.
HTML Code:
eurostatuse namq_10_gdp, noflags long
Or alternatively, is there a way how to import them individually in the first place?
So far I tried to generate new variables by the seasonal adjustment identifier, but the problem is that when I do this the new variables have values not next to each other but in a sort of staircase-like fashion:
year | country | SA GDP | NSA GDP |
1999 | AT | 1100 | . |
1999 | AT | . | 1000 |
year | country | SA GDP | NSA GDP |
1999 | AT | 1100 | 1000 |
Thanks for any help.
Comment