About Vishy

Vishy · ‎05-18-2018

Just for knowledge, how to change the display name in this community account?

Vishy · ‎05-18-2018

Thank you all for contributing your thoughts on this. It really helps.

Vishy · ‎05-18-2018

Yes, that's correct. thanks

Vishy · ‎05-18-2018

　 Actually if month & year of Date1 = month & year of date3 then I need the row with previous month's of date2. In the below dataset I need the row4. date1=Apr17 & date3=Apr17 so I need the previous month row which is date2=Mar17 data check1; input row ID date1 :date7. date2 :anydtdte. date3 :anydtdte.; format row 8. date1 date9. date2 monyy5. date3 monyy5. ; datalines; 1 1001 03Apr17 Dec16 Jul03 2 1001 03Apr17 Jan17 Jul03 3 1001 03Apr17 Feb17 Jul03 4 1001 03Apr17 Mar17 Jul03 5 1001 03Apr17 Apr17 Apr17 6 1001 03Apr17 May17 Apr17 7 1001 03Apr17 Jun17 Apr17 8 1001 03Apr17 Jul17 Apr17 9 1001 03Apr17 Aug17 Apr17 10 1001 03Apr17 Sep17 Apr17 11 1001 03Apr17 Oct17 Apr17 12 1001 03Apr17 Nov17 Apr17 13 1001 03Apr17 Dec17 Apr17 ; run;

Vishy · ‎05-18-2018

The condition is month(date1)=date3 actually.

Vishy · ‎05-18-2018

How can I select the row I needed based on the condition? Below is the requirement. When date1=date3 then I need the row which has previous month date of date2. In the below example. Data: ID Date1 Date2 Date3 1001 03-Apr-17 Dec-16 Jul-03 1001 03-Apr-17 Jan-17 Jul-03 1001 03-Apr-17 Feb-17 Jul-03 1001 03-Apr-17 Mar-17 Jul-03 1001 03-Apr-17 Apr-17 Apr-17 1001 03-Apr-17 May-17 Apr-17 1001 03-Apr-17 Jun-17 Apr-17 1001 03-Apr-17 Jul-17 Apr-17 1001 03-Apr-17 Aug-17 Apr-17 1001 03-Apr-17 Sep-17 Apr-17 1001 03-Apr-17 Oct-17 Apr-17 1001 03-Apr-17 Nov-17 Apr-17 1001 03-Apr-17 Dec-17 Apr-17 Desired Output: ID Date1 Date2 Date3 1001 03-Apr-17 Mar-17 Jul-03

Vishy · ‎05-18-2018

Thank you all for your inputs.

Vishy · ‎05-18-2018

@RW9, Thanks for looking into this. what is ds=ifn(a,1,2); below? It's not working.

Vishy · ‎05-18-2018

Hi, Is there any logic to get the previous month's value when a condition matches using two different data sets? Please see below data sets sample. Dataset1: Var_A Var_B 1 01Feb18 2 15Mar18 3 13Mar18 4 21Apr18 5 11Jul18 6 21Apr18 7 17May18 Dataset2: Var_A Var_C Int Rate 1 01Jan18 5.20% 1 01Feb18 6.20% 2 15Dec17 1.50% 2 15Jan18 2.50% 2 15Feb18 3.50% 2 15Mar18 4.50% 3 20Mar18 5.50% 3 20Apr18 6.50% 3 20May18 7.50% 4 10Apr18 2.60% 4 10May18 3.60% 5 11Jun18 8.80% 5 11Jul18 9.80% 6 21Apr18 5.70% 7 30Oct18 4.60% 7 30Nov18 6.60% Desired Output: Var_A Var_B Int Rate 1 01Feb18 5.20% 2 15Mar18 3.50% 3 13Mar18 4 21Apr18 5 11Jul18 8.80% 6 21Apr18 5.70% 7 17May18

Vishy · ‎02-02-2017

@LinusH - Thanks for your answers. Yes, I have a license for SAS, but not sure if this also includes a feature to integrate with MSTR. I will check that. But I have understood from your points that if we have license from SAS then we can integrate with MSTR. @JuanS_OCS: Thanks for looking into it & contributing Regards, V

Vishy · ‎02-01-2017

Yes, I am trying to understand if MicroStrategy can read sas datasets & a connection can be created between SAS & Microstrategy so that once data is run on SAS it generates the results on Microstrategy Thanks Vishy

Vishy · ‎02-01-2017

Hi, Can we connect Mircrostrategy on top of SAS Enterprise Guide?

Vishy · ‎12-15-2016

Great. It works, thank you very much Ksharp..I appreciate it.

Vishy · ‎12-14-2016

Ksharp, thanks for very much for the solution. Can we apply the format and informat in the method you have mentioned? DATA DATASET1; INPUT VAR1 VAR2 VAR3 VAR4 COL1 COL2 COL3 $3.; DATALINES; ABC BBB ASB AAS ATS EES DAS ASD FDA ASD DAS AEW KJL ASD AES EWL SAG GLA GKE AKS SAF ; RUN; data _null_; set sashelp.vcolumn(keep=libname memname type name where=(libname='WORK' and memname='DATASET1' and type='char')) end=last; if _n_=1 then call execute('proc sql;alter table dataset1 modify'); call execute(name||' char(5)'); if last then call execute(';quit;'); else call execute(','); run;

Vishy · ‎12-14-2016

Hi All, Yes, it's working from both the methods. Thanks a lot for your contributions & help on this. I really appreciate it. Thanks

Re: How to Change SAS Communities Account Email

Re: Selecting a customised row based on requirement

Re: Selecting a customised row based on requirement

Re: Selecting a customised row based on requirement

Re: Selecting a customised row based on requirement

Selecting a customised row based on requirement

Re: Getting previous month's data when condition matches

Re: Getting previous month's data when condition matches

Getting previous month's data when condition matches

Re: SAS to Microstrategy Bridge

Re: How to change the length of multiple variables in one go in SAS?

Re: How to change lengh of multiple variables in one go in SAS?

Re: How to change the length of multiple variables in one go in SAS?

Re: How to change the length of multiple variables in one go in SAS?

Re: How to change the length of multiple variables in one go in SAS?

Re: How to Change SAS Communities Account Email

Re: Selecting a customised row based on requirement

Re: Selecting a customised row based on requirement

Re: Selecting a customised row based on requirement

Re: Selecting a customised row based on requirement

Selecting a customised row based on requirement

Re: Getting previous month's data when condition matches

Re: Getting previous month's data when condition matches

Getting previous month's data when condition matches

Re: SAS to Microstrategy Bridge

Re: SAS to Microstrategy Bridge

SAS to Microstrategy Bridge

Re: How to change the length of multiple variables in one go in SAS?

Re: How to change the length of multiple variables in one go in SAS?

Re: How to change the length of multiple variables in one go in SAS?