topic Re: How to rename variable in PROC SQL? in SAS Procedures

How to rename variable in PROC SQL?

ybz12003 — Wed, 08 Feb 2017 21:22:23 GMT

Hello,

I would like to rename the following variable in Proc SQL although I know it could be done in SAS data steps. But I would like to use in PROC SQL, how? Thanks.

data dataout.rename;

set dataout.test;

rename HAVARTH3=AR _PRACE=RACE _AGEG5YR=AGE _INCOMG=INCOME _HCVU651=INSURANCE _BMI5CAT=BMI

LMTJOIN3=LMTJOIN DRNKANY5=DRNKANY DIABETE3=DIABETE _SMOKER3=SMOKER;

run;

Re: How to rename variable in PROC SQL?

Sven111 — Wed, 08 Feb 2017 22:49:29 GMT

PROC SQL;
    CREATE TABLE dataout.rename AS
        SELECT  HAVARTH3        AS AR 
               ,_PRACE          AS RACE
               ,_AGEG5YR        AS AGE 
               ,_INCOMG         AS INCOME
               ,_HCVU651        AS INSURANCE 
               ,_BMI5CAT        AS BMI
               ,LMTJOIN3        AS LMTJOIN
               ,DRNKANY5        AS DRNKANY
               ,DIABETE3        AS DIABETE
               ,_SMOKER3        AS SMOKER
       FROM     dataout.test;
;QUIT;

Re: How to rename variable in PROC SQL?

ballardw — Wed, 08 Feb 2017 23:53:45 GMT

Unrelated question: Is there any chance this data is coming from BRFSS?

Re: How to rename variable in PROC SQL?

ybz12003 — Thu, 09 Feb 2017 01:25:23 GMT

Thanks

Re: How to rename variable in PROC SQL?

ybz12003 — Thu, 09 Feb 2017 01:26:02 GMT

yes, you worked on it before?

Re: How to rename variable in PROC SQL?

elwayfan446 — Wed, 17 May 2017 19:18:57 GMT

Can you tell me why the renamed columns don't export to excel using ods excel file = "" ? The regular variable names are what get exported instead.

Re: How to rename variable in PROC SQL?

ChrisHemedinger — Wed, 17 May 2017 19:26:38 GMT

Hi @elwayfan446, this sounds like a new question. Want to create a new topic with some sample code? ODS EXCEL is for ODS output, not data sets exactly, so it doesn't really play into PROC SQL unless you're leaving off the CREATE TABLE statement.

Re: How to rename variable in PROC SQL?

elwayfan446 — Wed, 17 May 2017 19:37:05 GMT

Thanks Chris. I was using the output method but you bringing up the create table statement made me realize that creating a temp table and using proc export was much easier and fixed my problem.