How to rename variable in PROC SQL?

[ybz12003]

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;

[Sven111 · Accepted solution]

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;

[ybz12003]

Thanks

[elwayfan446]

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.

[ChrisHemedinger]

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.

[elwayfan446]

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.

[ballardw]

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

[ybz12003]

yes, you worked on it before?