BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
enginemane44
Calcite | Level 5

SAS-Ler's

I'm trying to use a non-indexed merge (no BY statement) to pull together two data sets.  One is a one-observation data set with 5 variables that are string literals (constants); the other is a more traditional data set

with several observations and variables.  All variables are character.

Here is what I have so far :


--------------------------------------------------------------------------------------------------------------------------------------

                                                            Have1 data set                           14:46 Wednesday, July 2, 2014   1

                                                    Obs    desc1    desc2    desc3

                                                     1       one          cold       wet
                                                     2       two          warm      wet
                                                     3       three       cold        dry
                                                     4       four         warm      dry

--------------------------------------------------------------------------------------------------------------------------------------

                                                            Have2 data set                           14:46 Wednesday, July 2, 2014   2

                                 Obs   lit1                lit2               lit3                lit4                 lit5

                                  1     category1    category2    category3    category4    category5

I'm using this statement to combine the data sets, using a MERGE statement with RETAIN :

data all;

length lit1$ 32 lit2$ 32 lit3$ 32 lit4$ 32 lit5$ 32;

retain lit1--lit5;  /* <--- This should keep the lit varables from being reset to missing */

merge have1 have2;

run;

This is what I get for the merged data set :

--------------------------------------------------------------------------------------------------------------------------------------

                                                           Merged data set                           14:46 Wednesday, July 2, 2014   3

                   Obs      lit1         lit2         lit3         lit4         lit5       desc1    desc2    desc3

                    1     category1    category2    category3    category4    category5    one      cold      wet
                    2                                                                                                                two      warm      wet
                    3                                                                                                                three    cold      dry
                    4                                                                                                                four     warm      dry


What I want is for all lthe 'lit' variables to be non-missing in the merged data set :

                   Obs   lit1               lit2                lit3                 lit4                lit5               desc1  desc2  desc3

                    1     category1    category2    category3    category4    category5    one      cold      wet

                    2     category1    category2    category3    category4    category5    two      warm     wet

                    3     category1    category2    category3    category4    category5    three    cold      dry

                    4     category1    category2    category3    category4    category5     four     warm    dry

I tried altering the merge statement by adding a set statement :

data all;

length lit1$ 32 lit2$ 32 lit3$ 32 lit4$ 32 lit5$ 32;

retain lit1--lit5;

merge have1(in=a) have2(in=b);

if not b then set have2;

run;

But this created a data set with only two observations (although the 'lit' variables were propogated from the first obs to the second).

Any ideas ?  I have a feeling the solution may require an 'IF _N_=1 THEN...' statement or use of an array.

Thanks in advance.

Barry Walton

1 ACCEPTED SOLUTION

Accepted Solutions
stat_sas
Ammonite | Level 13

Try this.

data all;

if _n_=1 then set have2;

set have1;

run;

View solution in original post

1 REPLY 1
stat_sas
Ammonite | Level 13

Try this.

data all;

if _n_=1 then set have2;

set have1;

run;

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

How to Concatenate Values

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 708 views
  • 0 likes
  • 2 in conversation