topic Re: Proc SQL case in SAS Enterprise Guide

Proc SQL case

chennupriya — Tue, 24 Feb 2015 16:00:38 GMT

I Have a dataset

x y and I have to create z

x y

CA 02

PA MX

GA FL

i have to create Z variable in dataset and x and y has state codes

when y in 02 then we assign SC some state code but when not numberic then Y as it is but when missing then shd do x=y

and. Now Z.

CAn anyone pls help

Re: Proc SQL case

LinusH — Tue, 24 Feb 2015 16:20:19 GMT

Don't understand what you are saying.

Please provide a complete result data set with X, Y and Z columns.

Re: Proc SQL case

chennupriya — Tue, 24 Feb 2015 16:28:48 GMT

HHi

I have state codes in X and Y but I need to create Z coloumn from Y

and Y has numeric and character data when state codes in 02 they gave me conversion that 02 means SC and 03 means VA but Y has character data also like MX and FL then leave as it is

aand Y has missing data then Z coloumn takes value from X coloumn as Y has missing values we u notice X Y and Z which I gave u above explains it now I am stuck how to create Z

Re: Proc SQL case

Reeza — Tue, 24 Feb 2015 16:45:52 GMT

Neither do we, unless you clarify your problem.

In your sample output above where does SC come from and why is PA missing?

Re: Proc SQL case

chennupriya — Tue, 24 Feb 2015 19:28:03 GMT

hi ,

ok lets go like this

state p_st

XY PA

SC LA

I WANT A CODE WHEN P_ST IS MISSING THEN TAKE A VALUE FROM STATE OTHERWISE P_ST

Re: Proc SQL case

Reeza — Tue, 24 Feb 2015 19:51:12 GMT

Use the coalesce function, see the documentation regarding the usage details:

SAS(R) 9.2 Language Reference: Dictionary, Fourth Edition

Z = coalesce(p_st, state);