topic Re: PROC EXPORT to Stata: all variables converted to lowercase - problem in SAS Procedures

PROC EXPORT to Stata: all variables converted to lowercase - problem

Arsenio_Staer — Wed, 21 Mar 2012 03:35:47 GMT

Dear all,

This should be a simple question. All datasets i export from SAS to Stata using code below end up with all variables low case although they were a mix of low and upper case in SAS.

PROC EXPORT DATA=lib.foo /* exporting for panel regression in stata for panel regression */

FILE="t:\my docs\lib.foo.dta"

DBMS=STATA REPLACE;

RUN;

Using R 2.13, same dataset and the code below,

write.dta(lib.foo, file=paste(df.project.path,"/","lib.foo.dta", sep=""))

conserves the casing of the variables. Have been searching around for the cause, but no luck. Would appreciate any help!

Thanks,

Arsenio

PROC EXPORT to Stata: all variables converted to lowercase - problem

Arsenio_Staer — Fri, 30 Mar 2012 00:57:34 GMT

Still haven't been able to figure it out. It's a rather strange coercion given that both SAS and Stata support mixed case var naming.

Any advice?

Re: PROC EXPORT to Stata: all variables converted to lowercase - problem

Linlin — Fri, 30 Mar 2012 01:27:23 GMT

you may find something information from the bottom part of the link https://communities.sas.com/message/119093#119093. there are options (such as VALIDVARNAME) to control cases.