!! Hello Team !! We are using SAS DI STUDIO 9.4   I have one SAS DI ETL. I have worked on this etl from last 15 days . We had done multiple steps in this etl and use many transformations,Today after save this etl and try to reoprn , its not opening.Its load for sometime and then close automatically. Now i dont have any backup (.spk) file for this etl.Can anyone help me how can i get back my etl. It is very important etl in my project.   Is there anyway to get back my job from the dms server (If server have any automatic backfile) OR Is possible to get my etl backup sas code(which is also help me to create new job)   Below i mentioned some trial which i already done but it not succesfully working 1) export the job spk file after crash the job and try to import that but still its not opening. 2) try to open etl from the diffrent user    please provide me guidlines to solve this truble.       ... View more

Hello Team.   SAS DI Version:9.4 Problem :- I want to fetch data from the REST API with post method in sas di studio(Using REST API Transformation).   I check the API with third party software like postman.its working fine. we also tried with sas code (proc htttp)  and it was giving corrrect output. But we are not able to do this activity with REST API transformation in  sas di studio.   Actually the client requirment is create a SAS DI ETL and use the REST API transformation and fetch the data.Then schedule this ETL.   I am working on sas di studio from last few month and i have good hands on it.But i never use the REST API transformation.   So can you please suggest me some document or blog which are related to the REST API Transformation. ... View more

Hello Everyone,   I am using sas viya 3.05.   We create a ETL and make one target table and load that table in oracle database.   My target table have one variable "Father_Name" and some value of this variable is in local language. So we can see these values in my sas enterprise guide.                                               but when we load this table Oracle_DB To CAS server on sas viya,and check my data into cas  the Father_Name variable values look like this "???????? ?????".It looks not good is in our VA reports.                                    data properties in sas viya data encoding type= UTF-8 ,observations=12 million ,Columns=22   So how can we resolve this issue in sas-viya. Can anyone suggest us. Thanks in advance. ... View more

I need help to get my desire output through the sas coding. I am using sas eg 8.1.   I have one data with column name "Name" and i want to found sound like name in same variable.   Data Have;   Name    mrityunjaya gaurav deepak mrtunjay dipak piyush mrityunjaya;   And i want output like this.(generate new column with "match" "non match" value)   Data want;   Name                Flag mrityunjaya      match gaurav             not-match deepak            match mrtunjay          match dipak               match piyush              not-match mrityunjaya     match   can some please help me how can i do this in sas.   ... View more

Hello Everyone, I am using sas-viya 3.05.   I am stuck in one process ,   Actually I want to fetch data from the Facebook and Twitter Account/fan page.Recently facebook and twitter both changed their policy to access data from third party software.   So i am not able to fetch data from the Facebook and twitter with the help of sasviya.   I get this type of error whenever i try to fetch data from the sas viya. First i go to this path 1)Import data ->social Media->Facebook Feed. 2)Add Facebook fan page name.  3)Select date range. 4)Add cas target table name.  5)Select Import Item.   I am getting this error after done the all above five steps.   ERROR: (#10) This endpoint requires the 'manage_pages' or 'pages_read_engagement' permission or the 'Page Public Content Access' feature or the 'Page Public Metadata Access' feature. Refer to https://developers.facebook.com/docs/apps/review/login-permissions#manage-pages, https://developers.facebook.com/docs/apps/review/feature#reference-PAGES_ACCESS and https://developers.facebook.com/docs/apps/review/feature#page-public-metadata-access for details. [code :10] [HTTP Status :400] ERROR: Facebook search return with error response.  I refer the links but not understood how can i do that.....   Can someone suggest me how can i authorize my account in Facebook. if anyone have any document or blogs related to this activity.please attached in comment.         ... View more