topic Re: getting non missing value into new variable in SAS Programming

getting non missing value into new variable

yashraj89 — Wed, 08 May 2019 21:24:13 GMT

I have data in the format where there are variable from eci01nam to eci20nam. Only one value would be present for each observation.

i want to get that non missing value into new variable.

Re: getting non missing value into new variable

Reeza — Wed, 08 May 2019 21:37:18 GMT

Use a CAT function to pull the information in.

WANT = CATS(of eci01nam-eci20nam);

@yashraj89 wrote:

I have data in the format where there are variable from eci01nam to eci20nam. Only one value would be present for each observation.

i want to get that non missing value into new variable.

Re: getting non missing value into new variable

Astounding — Wed, 08 May 2019 21:35:52 GMT

It's easy as long as those 20 are the only variable names that begin with "eci":

newvar = max (of eci: ) ;

Re: getting non missing value into new variable

Reeza — Wed, 08 May 2019 21:38:15 GMT

I think MAX() only works on numeric variables in a data step.

Re: getting non missing value into new variable

yashraj89 — Wed, 08 May 2019 22:04:27 GMT

I think it will work but first i have to convert the variable numeric suffix. It throughs the error

ERROR: Missing numeric suffix on a numbered variable list (eci01nam-eci18nam).
ERROR 71-185: The CATS function call does not have enough arguments.

Re: getting non missing value into new variable

novinosrin — Wed, 08 May 2019 22:14:16 GMT

@Reeza Mam , Are you telling me you forgot coalescec?

WANT = coalescec(of eci01nam-eci20nam);

Or did you not have coffee or you must be tired?

Re: getting non missing value into new variable

ballardw — Wed, 08 May 2019 22:17:29 GMT

Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the {i} icon or attached as text to show exactly what you have and that we can test code against.

Re: getting non missing value into new variable

Astounding — Wed, 08 May 2019 22:24:47 GMT

You're right. I was using a handheld where I couldn't actually see the sample data. Oh well.