DATA Step, Macro, Functions and more

SAS Enterprise Guide & SAS Visual Analytics Interactions

Reply
New Contributor
Posts: 3

SAS Enterprise Guide & SAS Visual Analytics Interactions

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;

re

 


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

Super User
Posts: 11,343

Re: SAS Enterprise Guide & SAS Visual Analytics Interactions

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.

Ask a Question
Discussion stats
  • 1 reply
  • 180 views
  • 0 likes
  • 2 in conversation