Nope. Your output dataset will have values from the B variables listed in the SELECT  , B.Phone_number , B.Email , B.Home_address , B.Secondary as address When ever there is an observation that matches A on both the name fields and the ZIP field.   Two things to check. 1) Do any of the matches have multiple observations coming from B?  If so that will increase the number of observations written.  For example 2 input duplicate name/zip combos in A that match 3 replicant name/zip combo in B will result in 2*3=6 observations written. 2) Remember that if ZIP is missing in both dataset that is a MATCH. ... View more

@JibJam221 wrote: hello! Thanks for letting me know, I didnt know that! and the Source variable is working, its outputting the sources as i'd like to. Im just hoping to find a way for it to stay when I try to further query the table. I'm confused. You said the source variable is working.    So is it working or not? ... View more

@JibJam221 wrote: hello! Thanks for letting me know, I didnt know that! and the Source variable is working, its outputting the sources as i'd like to. Im just hoping to find a way for it to stay when I try to further query the table. I'm confused. You said the source variable is working.    So is it working or not? ... View more

Assuming NAME is defined long enough and the pattern of either NAME having a value or the other two having values is consistent then just replace name with combination of all three. data want; set have; name=catx(' ',name,firstname,lastname); run; If NAME is not long enough then change it s length first. data want; length name $100 ; set have; name=catx(' ',name,firstname,lastname); run; ... View more

Yes. I tried it ,but the latter does not work. ... View more

Sorry, I do not have any macro code handy. This would be a custom program for your situation. If you want to dig, you could try reading other posts like this these:  Solved: Renaming variable names with macro and loop - SAS Support Communities Renaming variable w/ macros - SAS Support Communities ... View more

@JibJam221 wrote: this is exactly what I need. The datasets are being sent to their respective locations, and cannot contain information regarding other locations (due to data confidentiality). Thanks so much In that case it might be easier to send them CSV files (as long as none of the strings in the data contain end of line characters). You can do that directly use a single data step without a need to find the location names.  And filenames will not have the limitations on naming that you would have with a dataset name.   It is especially trivial if the files do not have to have header lines.  Then you can write the file from the data without even having to sort by location first. data _null_; length filename $256; set have; filename=cats('/home/me/outdir/',location,'.csv'); file dummy dsd filevar=filename mod; put (_all_) (+0); run;   ... View more

data extract; set have; where indexc(id_response,'#') or indexc(id_response,'$') or indexc(id_response,'%'); run; ... View more

I also tried this and it worked as well! Thank you so much ... View more

@JibJam221 wrote: Sorry I meant to say that test_date didnt change to a NUM variable. Any suggestions on how to make test_date a NUM var? You cannot change the type of an existing variable. So if TEST_DATE already appeared as a character variable in your source dataset then just trying to attach a numeric format to it or assign a numeric value to it would not change how it was already defined.   Check that TEST_DATE does not already exist on COVID.COVID.  If it does then you can use DROP= or RENAME= dataset option to get it out of the way so you can use TEST_DATE as the name of your NEW variable. data main2; set covid.covid (drop=test_date); format test_date mmddyy10.; test_date = input(Accurate_Episode_Date,date9.); run; ... View more

Here's a tutorial on using Arrays in SAS https://stats.idre.ucla.edu/sas/seminars/sas-arrays/   You need arrays to process multiple variables in the same fashion.   data want; set have; array myvars(3) col1-col3; do i=1 to dim(myvars); if myvars(i) in ('somewhat negative', 'extremely negative') then myvars(i) = 'negative'; end; run; @JibJam221 wrote: Hi everyone,    im looking for an efficient way to replace values in a table in a SAS work.library. This data was imported from excel, and there are many variables in multiple columns that im looking to change. For example: in column1, column2, column3, I would like to replace their values from "somewhat negative" and "extremely negative" to simply "negative".   Any ideas?    thanks!   ... View more

Show us the log so we can see the errors (and the code you used as well). When providing the log, it is critical that you maintain the formatting of the log so we can see it exactly as SAS showed it to you, making it easier for us to use. To maintain the formatting of the log, click on the </> icon and paste the log as text into the window that appears. DO NOT SKIP THIS STEP. ... View more