@SASUser_77 wrote: I took a screen capture of only one observation as an example. There are indeed 22 observations in the want2 table. I want to extract only the email addresses.    I do not understand what you mean when you say variable word, can you clarify? If you run a program like this: data want ; set sashelp.class; age2 = age**2 ; run; If you want to check if it worked by browsing the dataset (say by using whatever tool you took the photograph of) then you need to look at the value of the new variable AGE2 and not just the values of the old variables NAME or AGE . ... View more

SODA is set up for it though. Would just need to figure out the VS side. https://support.sas.com/ondemand/saspy.html ... View more

Copying this from another related discussion -- in general it's better to detect UTF-8 by examining contents and not relying on BOM. But some systems might still rely on it.   "Use of a BOM is neither required nor recommended for UTF-8, but may be encountered in contexts where UTF-8 data is converted from other encoding forms that use a BOM or where the BOM is used as a UTF-8 signature" https://www.unicode.org/versions/Unicode6.0.0/ch02.pdf ... View more

Let's reduce the complexity of the code for clarity: %let empty_tables=a; data _null_; put &empty_tables.; run; Log: 233 %let empty_tables=a; 234 235 data _null_; 236 237 put &empty_tables.; 238 run; NOTE: Variable a is uninitialized. The PUT statement resolves to :  put a;  Which is used in a manner that SAS thinks is a variable. You want quotes around your macro variable so it is treated as a text value that Put understands. 239 %let empty_tables=a; 240 241 data _null_; 242 243 put "&empty_tables."; 244 run; a   ... View more

Great! That solved it for me. Thank you so much! ... View more

Thank you for sharing your work with us, acordes. ... View more

In SAS discussions MERGE is a "side by side" type of data combining where common named variables will behave quite differently than SQL similar operations. Also a data step merge can have very unexpected results when BY variables have repeated values in two or more data sets and will usually show a warning about such in the LOG. Was there such a warning in the LOG for the data step merge. So when discussing combining data in SAS do not use "merge" unless you mean that side-by-side row combination.   The "union all" is a vertical or stack, which would be an Append procedure operation or SET in the data step.     ... View more

"Didn't work" is awful vague. Are there errors in the log?: Post the code and log in a code box opened with the "</>" to maintain formatting of error messages. No output? Post any log in a code box. Unexpected output? Provide input data in the form of data step code pasted into a code box, the actual results and the expected results. Instructions here: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 will show how to turn an existing SAS data set into data step code that can be pasted into a forum code box using the "</>" icon or attached as text to show exactly what you have and that we can test code against.   In other words, Show the code you actually used and best from the log as the messages SAS provides often will indicate what is needed. ... View more

data a; set sashelp.class; run; data b; set sashelp.class; if _n_=1 then delete; run; proc sql; create table duplicate_name as select name from a intersect select name from b ; quit; ... View more

Spoiler alert: It does work. ... View more

There is no need to put variables in the CLASS statement that are not also specified in the MODEL statement, and as mentioned, doing so can result in additional observations being ignored if the extra variables contain missing values. But if the extra variables contain no missings, then the results should be the same with or without them in the CLASS statement. You should never put continuous variables in the CLASS statement unless you want to treat them as categorical and they have relatively few values. Any variable in the CLASS statement is treated as categorical by internally creating a set of variables that are used in the design/model matrix to represent that variable. If your continuous, 3 month averaged variables for a subject are the result of averaging the separate values from each of the observations for that subject, then you are just throwing away information. You might better use the separate values in each of the three observations for each subject. ... View more

You are quite right. I rarely used formats but you have demonstrated and explained to me that it is very useful and effective in saving time, especially in research. Thanks again for taking the time to help me. I really like SAS because there is a lot of help for people in difficulty. If I don't succeed in doing my analyzes with SAS, I will have to learn R. Unfortunately, this is the tool used in bioinformatics. Sincerely yours, Nathalie ... View more

If you want to read text files, do NOT use PROC IMPORT. Write the data step yourself, according to the documentation you received along with the file. ... View more