Hi everyone!
I am facing the following problem:
I want to import an excel that is created by another do-file.
However, in days when I don't receive new data, this excel is not created.
Therefore, if I simply try to run:
import excel "this excel - ${today}.xlsx" , ///
firstrow clear
I will receive an error all the days that I haven't received data (which means there would be no excel for ${today}.
Is there any way I can conditional the import of the excel on the existence of the file?
For example, with an "IF"?
Thanks in advance!!
Isabela
Related Posts with Importing data conditional on something
Can I extract few letters from a string variable based on a conditional is another string variable?Dear Statalists, I have a dataset including six variables: ID PersonName ExcelPersonID CompanyName …
matrix divisionHi, I have two variables for which I use the sum command to aggregate the values, so I end-up with …
Oaxaca-Blinder command. Statistical significance of the components.Hi everyone, I am a current user of Oaxaca command and I don't know how Stata calculates (with which…
Diagnostics for mixed effects logistic regression and interpretation of ICC.Hello, I am looking at the association between certain protective/risk factors and suicide in a sam…
Threshold Regression in Panel DataI am trying to estimate threshold estimation for my balanced panel data. The value of T=12 & N=2…
Subscribe to:
Post Comments (Atom)
0 Response to Importing data conditional on something
Post a Comment