Import CSV as numeric
Posted: Tue Apr 04, 2017 7:43 am
Hi,
I have a CSV file I'd like to import. I've used the pageload command and the import command for this. But no matter what, the series are imported as alphas. Especially those that have "NA"s before numbers. When I imported it manually, the series came out as numeric. Is there a workaround for this?
I've attached my CSV file.
Here are the codes I've tried:
%myfile is the file path to the CSV.
{%freqeuncy} is just a variable that holds either a, q, or m. This CSV has a monthly frequency so {%frequency} becomes m.
Thanks!
I have a CSV file I'd like to import. I've used the pageload command and the import command for this. But no matter what, the series are imported as alphas. Especially those that have "NA"s before numbers. When I imported it manually, the series came out as numeric. Is there a workaround for this?
I've attached my CSV file.
Here are the codes I've tried:
Code: Select all
import(page=Newdata) %myfile ftype=ascii rectype=crlf skip=0 fieldtype=delimited delim=comma byrow colhead=2 namepos=first eoltype=pad badfield=NA @freq {%frequency} @smpl @allCode: Select all
pageload %myfile ftype=ascii rectype=crlf skip=0 fieldtype=delimited delim=comma byrow colhead=2 namepos=first eoltype=pad badfield=NA @freq {%frequency} @smpl @all{%freqeuncy} is just a variable that holds either a, q, or m. This CSV has a monthly frequency so {%frequency} becomes m.
Thanks!