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
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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.