hi how can i delete records in my metadata tables? i defined an authentication domain back then and i want to delete it but i don't know how. the same goes with a machine i defined back then. if i delete this entries will it affect other tables as well? thanks a lot! ... View more

hello, what are the different ways SAS can connect to a MSSQL source? In DI Studio how can you create libraries for MSSQL? thanks! ... View more

Hi, My code looks like this: proc sql; create table loan as select * from loan left join x_loan on loan.rkid = x_loan.rkid; quit; rkid is a primary key and with this code of mine integrity is a problem since i recreated the table loan. Is there a way to recreate a table without the integrity? Or are there any steps i can do to achieve what i intend to do? Thanks! ... View more

Hi, Please correct me if I'm wrong and sorry if my question sounds confusing. I heard that ETL Studio uses XML as its file type when exporting jobs/etc while DI Studio's saves it as an .spk file. What is the structure of the XML file back then on ETL Studio's era? And why was the save as XML file when exporting metadata removed in DI Studio? Thanks! ... View more

Hello, let's say i have tables a and b. a has var1 var2 and b has var3 var4 then i need to create a table that adds a column to table a named tag which depends on the first 5 chars of var1. so when substr(var1,1,5) is equal to a certain value of var3 then tag = var4. here's the code: proc sql; select * from a left join b on substr(var1,1,5) = var3; quit; assuming that there are only two values for var4. how come when i create a table that separates the two values of var3, their total count is different to the whole? i feel i wasn't able to explain it well but if you understood what i'm trying to talk about your help is much appreciated. is there wrong with my code? or logic? or other thing? thanks a lot! 😃 ... View more

hi! how can you combine duplicates(not summing them up) using data step or proc sql? advance thanks! 🙂 ... View more

let's say i have a report like these: proc report data=mydata; column a b c,(x y z); define a / group noprint; define b / group descending; define c / across; define x / analysis; define y / analysis; define z / analysis; rbreak after / dul summarize; compute after; b = 'Total'; endcomp; run; the output would display c over x y and z. let's say i want to add style and for every c the background color would be different, is that possible? thanks! 🙂 ... View more

is it possible to hide i column un proc report? i used a column for ordering the report but i don't want to display it thanks! ... View more