topic Re: non missing in SAS Programming

non missing

shynu — Fri, 16 Dec 2016 10:42:44 GMT

How do I select the first non missing value??

Write a program to get the below O/P:
i/P:
1
12
123
1234

o/p:
0001
0012
0123
1234

Re: non missing

RW9 — Fri, 16 Dec 2016 11:13:19 GMT

1) What do you mean by "select the first"? Do you only want to output to dataset the first one?

data want;
  length op $4;
  set have;
  op=put(ip,z4.);
run;

The Zx. format will put out the zeroes.

Re: non missing

Reeza — Fri, 16 Dec 2016 11:17:53 GMT

Your question statement has no relation to your desired output...

Re: non missing

shynu — Fri, 16 Dec 2016 11:26:55 GMT

I'am sorry, they are 2 different questions.

And in the first question I mean to ask, if there are a set of observations with missing and non missing values of a variable, how can I output the 1st non missing value of that variable.

Thank you.

Re: non missing

Reeza — Fri, 16 Dec 2016 11:29:13 GMT

@shynu wrote:

I'am sorry, they are 2 different questions.

And in the first question I mean to ask, if there are a set of observations with missing and non missing values of a variable, how can I output the 1st non missing value of that variable.

Thank you.

Post sample input/output as well.