topic Re: SAS Enterprise Guide & SAS Visual Analytics Interactions in SAS Programming

SAS Enterprise Guide & SAS Visual Analytics Interactions

Tyagii — Wed, 13 Jan 2016 06:38:49 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: SAS Enterprise Guide & SAS Visual Analytics Interactions

ballardw — Wed, 13 Jan 2016 16:31:38 GMT

Do you have your "dummy" values in a dataset? If so, are they a one-to-one match for the base data (the first dummy value goes with the first record in base data)?

If so:

Data want;
   merge abgu dummydata;
run

Should work.

If you don't have the dummy values in a data set then make one.

If the relationship is NOT one-to-one you will need to provide explicit rules on how to assign the first "dummy" value to the correct record(s) in the base dataset.