We tried to connect to sql server throught ODB connection, test was completed successfully. so connection is working OK:           But when we tried to connect to this database in SAS EG we got this error:       LIBNAME IDB ODBC DATAsrc=IDB SCHEMA=dbo USER=danasova PASSWORD="xxx";   What we did incorrect?   ... View more

Hello,   i want to ask, if i have query like this...   pro sql;   create table DATABASE.SKUSKA  AS  SELECT....   an this querry runs like 40 mins, and this table database.skuska is base of front end table in application, so when user come to application in the time when querry runs, there is incomplete information. Is there a way to 1. run a querry and then 2. replace a table faster? So there will not be 40 minutes incomplete information in application? How can i do it if it is possible?   For example run a querry in work library and when is table complete just overwrite database.skuska table.   Thanks. ... View more

how can i do this, but in sas eg (odbc engine) through implicit statements?    proc sql; connect to sqlsvr as mydb (datasrc="SASDATA" user="sas" password="xxx"); select * from connection to mydb (CREATE INDEX ZP on dashboard_novacik (ZP) ; CREATE INDEX Fin on dashboard_novacik (Fin) ; ); QUIT;   This code works in SAS Studio (sqlsvr engine).   Thanks ... View more

Hello,   how can i transpose data if i have transposed data which first few words are the same, and this method take just few words at the start but now thole field, i got error: ERROR: The ID value "'Dávka pre prípad hospitalizácie'n" occurs twice in the same BY group. NOTE: The above message was for the following BY group: K_PART=17 C_PZ=0304626732 But there are not the same words: There are more words like that, not the same, just the beggining of field is the same, and it just appear to be transposing it be few first letters in the field.   Is there a way how to take whole name and transpose it with whole name in the field (in my case it is field description).   Thank you.   P.   ... View more

Hello, how can i import csv file from table from database to sftp server? For example i have this information and need to import csv file there:   Username: Pandas Host: 37.9.169.9 Password: XXX   Thanks. ... View more

Is there any possible way to connect to postgresql from sas EG - program?   Tried this but it is not working from program in sas EG:   DRIVER=SQL;CONOPTS=((DRIVER=POSTGRES;CATALOG=public;UID=myuid;PWD=123pass; SERVER=aurora-instance-1.ctkz01uv9xcr.us-east-1.rds.amazonaws.com; PORT=5432;DB=aurora))                                     Thanks for any help.                                                                                                                                                                                                                                                                       ... View more

How can i truncate table, this is not working for me:   Proc sql; truncate table sasdata.barkoci; run;   Thanks. ... View more