Veracrypt and Mac Users to access data on STATA

[Arja Dayal]

Hi,

Our project recently migrated from Boxcryptor to Veracrypt, and we have been facing issues accessing PII data for Mac users on STATA. Here is the problem:

We can mount the folder to our local drive using the Veracrypt STATA command, but once it is mounted with the local folder named "NO NAME" we can't seem to import the encrypted excel file on STATA. Locally, I can see the folder and the file, but both the import excel STATA command and when we even try to open the file from STATA directly, it doesn't allow us. We have tried multiple permutations and combinations of codes but seem to be running into this problem.

Here is my code, can you help me understand what is going wrong?

global veracrypt ${raw}/pm_raw
global veracrypt_1 ${temp}/pm_temp
global raw "~/1:/Process Monitoring Raw"
global temp "~/2:/Process Monitoring Temp"
global output ${work}/ReachUp_Study/3_Data_processing/4_Process Monitoring/Clean

cap: veracrypt, dismount drive (1)
veracrypt ${veracrypt}, mount

cap: veracrypt, dismount drive (2)
veracrypt ${veracrypt_1}, mount

import excel "$raw/Process_Monitoring_r1.xlsx", firstrow

It is the import command that throws an error:

error: file 1:/Process Monitoring Raw/Process_Monitoring_r1.xlsx not found

Thank you,
Arja

[Daniel Feenberg]

Could the macros not be evaluating to what you need? I notice the tilde seems to evaluate to empty according to the error message. Try

set trace on

and follow the evolution of $RAW in the output. That should point to the problem.