I am importing a csv file (attached) of time series numeric data which contains occasional missing values as ".."
The simple import code I am using is:
Code: Select all
import M:\ExportDirect.csv colhead=1 @freq Q 1986q1
Four (4) of the 152 series are being imported as alphas rather than numeric. These series are:
- HLFQ_SMB1JCA
HLFQ_SMB2JBE
HLFQ_SMB3JBF
HLFQ_SMB3JCK
While these 4 series all have occasional instances of "..", there are other series which also have instances of ".." which are coming through as numeric.
Any suggestions as to how I can get the import to recognise the ".." as missing values?
I tried the following, but it did not work:
Code: Select all
import M:\ExportDirect.csv na=".." colhead=1 @freq Q 1986q1
Thanks in advance for any assistance