About Madansas7b

Madansas7b · ‎05-16-2017

Thank You Soooo MUCH @Reeza .

Madansas7b · ‎05-16-2017

Hi All, can u please suggest me on this as i was confused evry time. what would be the minimum and maximum number of records if i use inner join between two tables .? and is duplicate values impact on that count?

Madansas7b · ‎04-05-2017

hi @Reality696, am not sure but try like bellow .while caling the start and end time %do i=%sysevalf(&start) %to %sysevalf(&end) %by 30*60;

Madansas7b · ‎04-04-2017

Thanks for your suggetion @RW9.im not aware of that as i am new to this.. from onwards will folllow your guidelines .any way i got the solution. thanks once again for paying your attention on this.

Madansas7b · ‎04-04-2017

HI EVRY ONE. please help on this. ive last 3 months txns data and ive to find the number and % of population active on Restaurants MCC according to respective Txns bands and what are their average spends and ATS for CC and DC Ex Txn Band | Number of Customers | Number of Restaurants Active Customers | % of Restaurant Active Customers | Total Spends | Restaurant Spends | ATS overall | ATS restaurants

Madansas7b · ‎03-30-2017

When the type and length of a variable are not explicitly set, SAS gives the variable a default type and length as shown in bellow x='ABC'; x='ABCDE'; here it will consider as per first obs length

Madansas7b · ‎03-30-2017

i think you are missed to assign the character format to the variable Store_No

Madansas7b · ‎03-30-2017

as of my understand to keep only numbers there are several ways .and you can use like bellow num = compress(long_string, , 'kd');

Madansas7b · ‎03-24-2017

proc sql; create table want as select count(distinct id) as Count_A, count(distinct Variable) as Count_B from have; quit;

Online Status	Offline
Date Last Visited	‎05-16-2017 09:54 AM

Re: inner join

inner join

Re: boucle do with 30 minutes increment

Re: urgent help

urgent help

Re: First When clause works for renaming, second one fails???

Re: First When clause works for renaming, second one fails???

Re: Extract Information from text

Re: How to count the frequency of a value by unique ID's

Re: Extract Information from text

Re: inner join

inner join

Re: boucle do with 30 minutes increment

Re: urgent help

urgent help

Re: First When clause works for renaming, second one fails???

Re: First When clause works for renaming, second one fails???

Re: Extract Information from text

Re: How to count the frequency of a value by unique ID's