SAS Support Communities

nishukhawale · ‎12-19-2016

Hi, I have data where todays closing becomes next days opening after calculations in Base SAS Code I have written and I have data from Jan2016 to Jul2016 so what is happening here is when I run one time data for 1st jan matches when I run second time data for 2nd jan matches and so on but how to cut down this repeting process short so that I can get all the matching values in one go. Thnaks,

nishukhawale · ‎12-12-2016

Hi, I am trying sum up the columns using SUM function ang group by but it is not happening I am attaching dummy data and code I am using cuurently please suugest me solution for the same. code: proc sql; create table demo.unit_capital1 as (select t1.*, (case when (t1.sch_class in ('539','540','541','812','813') and t1.tran_type in ('SWIN','SWINC','UNSAL','UNSALC')) then sum(t1.trades_units) else 0 end) as SHARES_SUBSCRIBED, (case when (t1.sch_class in ('539','540','541','812','813') and t1.tran_type in ('SWOUT','SWOUTC','UNPUR','UNPURC')) then sum(t1.trades_units) else 0 end) as SHARES_REDEEMED, (case when (t1.sch_class in ('539','540','541','812','813') and t1.tran_type in ('SWIN','SWINC','UNSAL','UNSALC')) then sum(t1.Subscription) else 0 end) as Subscription_Money, (case when (t1.sch_class in ('539','540','541','812','813') and t1.tran_type in ('SWOUT','SWOUTC','UNPUR','UNPURC')) then sum(t1.Subscription) else 0 end) as Redemption_Money, (case when (t1.sch_class in ('539','540','541','812','813') and t1.tran_type in ('SWOUT','SWOUTC','UNPUR','UNPURC')) then sum(t1.scheme_load) else 0 end) as Load_ from demo.unit_capital t1 WHERE T1.SCH_CLASS in ('539','540','541','812','813') and t1.upload_date >= '31DEC2015'd group by t1.UPLOAD_DATE,t1.sch_class,t1.tran_type) order by t1.sch_class,t1.tran_type; quit; Thanks,

nishukhawale · ‎11-01-2016

Hi Sandeep, I am also new to SAS VA but as far as your 2nd and 3rd query cis concern I think I can help you out to some extent, I am trying to answer your 2nd and 3rd question at one go, ---if you are suppose to use autoload feature for perticular data set then you are suppose to create library in SMC where you have to regester the table the one you are going to use as data source for report then in SAS VA you have to create data query change the name of data source,schedule the query and replace the previous data source with new one for the report. this is the process for autoload I have followed however there is another way for autolod which I am not aware about I am still exploring. Thanks, Nishant

nishukhawale · ‎11-01-2016

Thank you very much mam for your reply and really useful links. Nishant

nishukhawale · ‎10-28-2016

sorry for this to late reply but suggestion you have given for unloading some data from the LASR server did work and the query ran well so does my auto load process. Madam do you some alternate approaches for Autolad in SAS VA other than registering table in library in SMC and then build query on SAS VA. I would like to here from you and once again I really appreciate your reply and solution on the topic. Thanks&Regards Nishant

nishukhawale · ‎10-25-2016

yours also gives the same output

nishukhawale · ‎10-25-2016

thank you for your reply however I got the output by using following function Var_new= round(var, 10**-dp)

nishukhawale · ‎10-25-2016

actually I would like make the process automated and Proc print will not work for me. but thank you very much for your reply and good news is I got the answer for that Var_new= round(var, 10**-dp)

nishukhawale · ‎10-24-2016

Hi, I am trying to round off the value upto its 8 decimal places I tried following functions and getting results against it but it is not as expect it to be e.g. value 0.00932304 round function=0 ceil=1 floor=0 int=0 what shall I try so that I can get some result other than these? I am trying it for column. Thank You

nishukhawale · ‎08-09-2016

Hi, I was getting this error while log in after entering server details and LDAP user credentials. But anyways it got solve as it seems to be issue with Realm parameters.I changed those and now it is working. Thanks

nishukhawale · ‎08-08-2016

Hi, I am trying for accessing SAS Mobile BI for that I have even followed Web Authentication Steps also using Realm details I am able to login in LDAP Utility for data authentication after all this I have restatrted the Webapp server but still I am not able to login into SAS Mobile BI using LDAP users getting error as Invalid credentials,can somebody help me out with solution for this. Thanks,

nishukhawale · ‎08-08-2016

Hi, I am trying for accessing SAS Mobile BI for that I have even followed Web Authentication Steps also using Realm details I am able to login in LDAP Utility for data authentication after all this I have restatrted the Webapp server but still I am not able to login into SAS Mobile BI using LDAP users getting error as Invalid credentials,can somebody help me out with solution for this. Thanks,

nishukhawale · ‎07-05-2016

Hi, I am refering the following document perticularly section Configuring Web Authentication Starting with the Second Maintenance Release for SAS 9.4 http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#n1bhp608f0hsoen10i1vi0p9l5f7.htm I have made the changes as asked in the document but I am bit confuse in step 7 to 9,can any body help me out with these steps. also I have sasdemo as LDAP user which is getting log in in SAS Mobile BI but for other users it is not happening. Thanks&Regards Nishant

nishukhawale · ‎06-29-2016

Hi, I can not login through SAS Mobile BI App using LDAP user Login, so as a solution I am following below mentioned link for Configuring Web Authentication, http://support.sas.com/documentation/cdl/en/bimtag/68217/HTML/default/viewer.htm#n1bhp608f0hsoen10i1vi0p9l5f7.htm for second maintenance release in step 14 where can I find required information? we have ADFS server in place. Thnaks&Regards Nishant

nishukhawale · ‎06-23-2016

Hi, actually I got solution by making changes on conf file and by adding certificate chain file but anyways I will keep thing in mind from next time. Thanks&Regards Nishant

SAS Support Communities

day on day code run

SUM up Vertically in Proc SQL

Re: SAS LASR server data Load life cycle

Re: error during query building

Re: error during query building

Re: Round value upto 8 decimal palces

Re: Round value upto 8 decimal palces

Re: Round value upto 8 decimal palces

Round value upto 8 decimal palces

Re: SAS Mobile BI LDAP user Login Fail

Re: error during query building

Re: SAS Mobile BI Add server

Re: error during query building

Re: Round value upto 8 decimal palces

Re: SAS Mobile BI LDAP user Login Fail

day on day code run

SUM up Vertically in Proc SQL

Re: SAS LASR server data Load life cycle

Re: error during query building

Re: error during query building

Re: Round value upto 8 decimal palces

Re: Round value upto 8 decimal palces

Re: Round value upto 8 decimal palces

Round value upto 8 decimal palces

Re: SAS Mobile BI LDAP user Login Fail

SAS Mobile BI LDAP User Login Issue

SAS Mobile BI LDAP user Login Fail

LDAP User login

Configuring Web Authentication for Mobile BI LDAP user login

Re: SAS Mobile BI Add server

SAS Global Forum 2016

Follow Us

What is...