topic Missing columns with concatenating in SAS Programming

Missing columns with concatenating

CathyVI — Sat, 08 Oct 2022 17:02:41 GMT

Hi,

This may sound simple but I need help.

I concatenate 2 dataset and the observations output seems fine.

Data 1 have 12316611 obs and187 columns

Data 2 have 12316611 obs and 86 columns

When I concatenate I got Total rows: 24633222 Total columns: 268 but I expected 273 column. Why is the number of variables is reduced. Could this be related to variables having different attributes. How do I resolve the issue. Thanks

Re: Missing columns with concatenating

Tom — Sat, 08 Oct 2022 17:15:37 GMT

Why would you expect there to be more than 187 variables? Are you saying that you expected NONE of the variables between the two datasets to be the same? Then why did you concatenate the datasets? They don't appear to have anything to do with each other.

As it is it appears that the second dataset have 268 - 187 = 81 variables that are NOT in the first dataset.

So there are only 5 variables that they have in common.

Re: Missing columns with concatenating

ballardw — Sat, 08 Oct 2022 19:50:47 GMT

Show the code that you used to "concatenate" the data sets.

It sounds like you did a data step merge and that you have 5 variables (not "columns") with the same name in both sets.