Hello! So I need to create a list using proc sql because I am running a statistical test that runs a bunch of tests cross referencing the variables called for in the variable list.
My proc sql code is:
proc sql noprint; select name into :tier1snps separated by ' ' from dictionary.columns where libname=upcase("work") and memname=upcase("domsnp") and (substr(name, 1, 3) in ('dom') or substr(name,1) in ('DOM_RS10462018','DOM_RS7107287','DOM_RS11022778','DOM_RS969485'));
I want to get rid of the last entry "dom_rs2267150" but I cannot figure out how to manually drop entries, although I figured out how to manually add entries. This would be a great help! Thank yo uso much!
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.