topic How do I add dummy values in blank character sas field in SAS Programming

How do I add dummy values in blank character sas field

Tyagii — Wed, 13 Jan 2016 06:46:19 GMT

data abhi;
input a b c d ;
datalines;
1 2 6 .
2 3 8 .
3 5 9 .
4 6 2 .
5 8 1 .
;
proc print data = abhi;
run;

results:

a b c d
1 2 6 .
2 3 8 .
3 5 9 .
4 6 2 .

Here we have d which is not having a blank value. Now I want to add some dummy values into the 'd' sas field after this step.
and results should look like given below. Please help me on this.

Dummy values are:
5
6
7
8

results should looks like.

a b c d
1 2 6 5
2 3 8 6
3 5 9 7
4 6 2 8

Re: How do I add dummy values in blank character sas field

Ksharp — Wed, 13 Jan 2016 07:55:07 GMT

Not Sure I understand what you mean.

data abhi;
input a b c d ;
datalines;
1 2 6 .
2 3 8 .
3 5 9 .
4 6 2 .
;
data Dummy;
input Dummy;
cards;
5
6
7
8
;
run;
data want;
 merge abhi Dummy(rename=(Dummy=d));
run;

Re: How do I add dummy values in blank character sas field

Tyagii — Wed, 13 Jan 2016 09:26:29 GMT

Thanks. you understand correctly. but i dont want to use cards or datalines. Can you please do the same without cards or datalines.

Re: How do I add dummy values in blank character sas field

RW9 — Wed, 13 Jan 2016 09:43:54 GMT

Hi,

Like (Note the use of indentation, and finishing a datastep/procedure correctly with run; or quit;) - code can be placed in posts using the {i} in the toolbar.

data abhi;
  input a b c d;
  d=_n_+4;
datalines;
1 2 6 .
2 3 8 .
3 5 9 .
4 6 2 .
5 8 1 .
;
run;

Re: How do I add dummy values in blank character sas field

andreas_lds — Wed, 13 Jan 2016 10:56:56 GMT

Tyagii schrieb:

Thanks. you understand correctly. but i dont want to use cards or datalines. Can you please do the same without cards or datalines.

To suggest any datasource other than datalines/cards you have to explain where the dummy-values come from.

Using output-statement is always possible ...

data Dummy;
  Dummy = 5; output;
  Dummy = 6; output;
/* ... */
;
run;