XPORT BRFSS data on Mac

[ballardw]

I don't know if it makes you feel any better but I had to diagnose a similar issue when our IT department policies moved all of our work OneDrive.

I frequently use a macro variable to hold the path so I can have common use for multiple ODS documents without having to retype 100+ character strings, which got longer when the OneDrive required replacing C:\ with C:\Users\xxxxxxx\OneDrive - xxxx .

Previously a macro variable such as

%let path= c:\folder\otherfolder\;
ods rtf file="&path.filename.rtf";

worked just fine. When writing to OneDrive locations however, it was actually attempting to use the leading space before the drive letter and all of the code had to remove the space in the macro variable definitions.

And the error messages that SAS received from OneDrive were not obvious that a space was causing a problem.

[abbyrjones72]

Well I am glad I wasn't the only one who noticed this. Glad we both fixed it.

[Tom]

You need to fix the path to the export file.

Read the log carefully and my previous message and you should be able to do it yourself.

[zahidhasandipu]

Hi,
I was wondering what study you did after xporting the LLCP2014 data set. May I know what variable you chose as an outcome variable and exposure variable, and what was the analysis about?

[abbyrjones72]

I can post the study when I get off work.

[zahidhasandipu]

Thank you so much! Appreciate it.

[abbyrjones72]

Below are the files corresponding to my study: the study itself and the code. If you cite this work, please do so in APA format using 'unpublished' as the type.

[zahidhasandipu]

Thank you so much!