something like this data have; /* Use PRXPARSE to compile the Perl regular expression. */ val ='123abc'; output; val ='bacde_bde'; output; val='abcdef'; output; val='abc-jj'; output; run; data want(drop=patternid); set have; patternID = prxparse('/[^A-Za-z_]+/'); if prxmatch(patternID, val)>0; run; ... View more

I think what you might used and I suggested is libname assigned for a particular schema in oracle. Please ask the IT people, what is the name of schema. ... View more

Everything looks right. try change it to IDWE_OWN.CUSTOMERS instead of customers ... View more

something like below should work, answer is very similar to what @Reeza has written /* your intial table with your records*/ data intialtable; a=10; run; /* this is your empty table as intial table where you have records*/ proc sql; create table uyuy like abc; /* this is empty table you have*/ proc sql; create table xyxx (gg num); /* here you will get all columns by cross join*/ proc sql; create table final_tabl as select a.*, b.* from uyuy a cross join xyxx b; /* do a proc append to your final_tabl which has all columns you need and insert data from table where you have data*/ proc append base =final_tabl data =intialtab ; quit;   ... View more

say you table abc then alter table add new columns(b,c) you want.   data abc; a=10; run; proc sql; alter table abc add b char(10), c num format=10.; quit; ... View more

check the below link someone with problem   1. https://communities.sas.com/t5/Base-SAS-Programming/Loading-sas-date-into-sql-server/td-p/235058. please do the following if the above link does not work 1. As I mentioned and shown earlier, inserting into table using connect statement is easier bet. 2. Try using SASDATEFMT shown in the link, we used to use this a lot with date and datetime and I am sure if you following one of this example it will work.  http://support.sas.com/documentation/cdl/en/acreldb/69580/HTML/default/viewer.htm#p13xka550rm442n1gdvi1swxgr1h.htm 3. Create a SAS table with format date9. with data yoou have and then insert.   ... View more

As @Reeza said earlier this is a datetime column, not a date column. Did you try using datetime value which @Reeza has provided. please let me know if that has nor worked. ... View more

@sas_td2016 This is an assumption, which may not be true sometimes. A similar query run on SQL Server and SAS may have different results. One reson I can think of is case sensitive. SQL server is case insensitive, whereas SAS is case sensitive.    select * from database.dbo.mytablename where name = 'hello'   LIBNAME SQLS ODBC DSN=’sql server’ user=sasjlb pw=pwd; select * from SQLS.mytablename where name ='hello'   Show us what is the code you run. what are the values you got or what is the error, someone can definetly help you.   ... View more

Sorry @tparvaiz, it seems I have understood your question wrongly ... View more

because of format monyy7. it displays so. Change it to something like yymmdd10. then it will display like date ... View more