cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
PriyaSaha
‎09-01-2015
  • 13 Posts
  • 3 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: need help to write query on email send with base sas

by Calcite | Level 5 in SAS Programming
‎08-29-2015 05:14 AM
‎08-29-2015 05:14 AM
I need a query send email with a set of duplicate data to my email id if there is no duplicate no email. ... View more

Re: need help to write query on email send with base sas

by Calcite | Level 5 in SAS Programming
‎08-28-2015 07:37 AM
‎08-28-2015 07:37 AM
In above CLASS data set, data should not be duplicate by Rollno .If it is duplicate then send a email with duplicate dataset to email id. ... View more

need help to write query on email send with base sas

by Calcite | Level 5 in SAS Programming
‎08-28-2015 06:09 AM
‎08-28-2015 06:09 AM
I have class dataset as below Rollno name marks grade A11     Ram    50    C A11     Ram    50    C A11      Hari    60    B C22     Priya    70   B C33    Ram    60   B D44    Hari    80   A D44    priya   90   A I want to write a query with below condition “If class dataset contain any duplicate with Rollno then send a email with duplicate data details otherwise do not sent any email if data is not duplicate in Class dataset .” Please help me write the query. Thanks in advance. ... View more

email send by using base SAS

by Calcite | Level 5 in SAS Programming
‎08-27-2015 10:05 AM
‎08-27-2015 10:05 AM
I have a dataset which contains duplicate and non duplicate data by key id .I want to write a query "if it has duplicate data by key id then send to my email to my id .if there is no duplicated then no email to send ." Please help me to write the query in base sas. Thank in advance. ... View more

how can we merge more than 2 dataset with merge setment

by Calcite | Level 5 in SAS Procedures
‎02-05-2015 06:53 AM
‎02-05-2015 06:53 AM
How could we  combine more than 2 data set like proc sql join statement like in data step merge statement. Thanks, Priya ... View more

difference between merge set and update

by Calcite | Level 5 in SAS Procedures
‎02-05-2015 06:49 AM
‎02-05-2015 06:49 AM
Can any body explain me how merge ,set and update are differently work ? Thanks in advance , Priya ... View more

How to debug a sas program ?

by Calcite | Level 5 in SAS Procedures
‎02-03-2015 03:51 AM
‎02-03-2015 03:51 AM
Without executing SAS dataset or any records can we check error in the sas program? how can we debug sas program ? Thanks, Priya ... View more

query

by Calcite | Level 5 in SAS Procedures
‎12-08-2014 03:48 AM
‎12-08-2014 03:48 AM
I have a input dataset like below input dataset Name A B E F D C Need a datase like below output dataset Name C D F E B A Please help me write this query. Thanks in advance priya ... View more

sas anlytics

by Calcite | Level 5 in SAS Data Science
‎11-30-2014 02:25 PM
‎11-30-2014 02:25 PM
Hi , I want to learn sas anlytics ,data modeling .Please help me how can I learn the basic of sas analytic and modeling. Thanks, Priya ... View more

Re: create automate macro code

by Calcite | Level 5 in SAS Programming
‎11-24-2014 09:15 PM
‎11-24-2014 09:15 PM
Hi Arthur, Above data the day name if S then it Saturdays ,if SS then Saturdays and Sunday.If it is ' T ' then take from SALE_DAY_NAME bold latters.otheif r wise take the position T ,like if it is 2nd position then Tueseday,5th position thusday.If TH then Thusday if TU then tuesday. Thanks in advance. Regards, Priya ... View more

Re: create automate macro code

by Calcite | Level 5 in SAS Programming
‎11-24-2014 01:10 PM
‎11-24-2014 01:10 PM
Hi Arthur, I have a dataset like below SALE_DAY_NAME day_name A fav name Day M-F 6a-3p MTWTF A fav name Early M-F 3p-6p MTWTF A fav name Early Morn Sa-Su 6a-8a S A fav name Early Morn Sa-Su 6a-8a SS A fav name Prime M-SU 6p-12a vvv MTWTFSS Name M-Su 12a-2a MTWTFSS good day name Sa 7p S best day name ENCORE Sa 11p S best day namet M-Su 7p-12a MTWTFSS best day name M-Su 7p-12a S best day name M-Su 7p-12a best day name ORIG Th 10p T Daylight ROS M-F 6a-3p Daylight ROS M-Su 6a-3p gpd MTWTF I want a data set like SALE_DAY_NAME day_name day1 day2 day3 day4 day5 day6 day7 A fav name Day M-F 6a-3p MTWTF Monday Tuesday Wednesday Thursday Friday A fav name Early M-F 3p-6p MTWTF Monday Tuesday Wednesday Thursday Friday A fav name Early Morn Sa-Su 6a-8a S Saturday A fav name Early Morn Sa-Su 6a-8a SS Saturday Sunday A fav name Prime M-SU 6p-12a MTWTFSS Monday Tuesday Wednesday Thursday Friday Saturday Sunday Name M-Su 12a-2a MTWTFSS Monday Tuesday Wednesday Thursday Friday Saturday Sunday good day name Sa 7p S Saturday best day name ENCORE Sa 11p S Saturday best day namet M-Su 7p-12a MTWTFSS Monday Tuesday Wednesday Thursday Friday Saturday Sunday best day name M-Su 7p-12a S Saturday best day name M-Su 7p-12a Monday Tuesday Wednesday Thursday Friday Saturday Sunday best day name ORIG Th 10p T Thursday Daylight ROS M-F 6a-3p Monday Tuesday Wednesday Thursday Friday Daylight ROS M-Su 6a-3p gpd MTWTF Monday Tuesday Wednesday Thursday Friday                     for example last observation i                    if  SALE_DAY_NAME= Daylight ROS M-Su 6a-3p gpd and day_name=MTWTF then put value from day1 to day5. if  SALE_DAY_NAME=  best day name M-Su 7p-12a and day_name='  ' then take M-Su put value from day1 to day7.                                            first we have check the day_name if day_name blank then take the bold part from SALE_DAY_NAME and put value in day1....day7. Please help me to write the code for above query.                        Thanks in advance .I am waiting for your replay. ... View more

Re: create automate macro code

by Calcite | Level 5 in SAS Programming
‎11-23-2014 10:33 AM
‎11-23-2014 10:33 AM
Thanks a lot Arthur for your kind support.Could please guide me how can this query write in macro ? Regards, Priya ... View more

create automate macro code

by Calcite | Level 5 in SAS Programming
‎11-21-2014 01:30 PM
‎11-21-2014 01:30 PM
I have a dataset as below. Sale_day_name short_name Z ww pp M-F 6a-3p MTWTF Z tt bb erty M-F 3p-6p MTWTF Z gg kk pp Sa-Su 6a-8a       S Z kk pp llkjhg Sa-Su 6a-8a      SS Z kk pp llkjhg M-SU 6p-12a MTWTFSS KPI M-Su 12a-2a MTWTFSS gtyuooo cyytrrf vftyu Sa 7p      S vghj nkiug njhgg Sa 11p      S bhjmm jjhg jjll M-Su 7p-12a MTWTFSS bhjmn mkj njk M-Su 7p-12a      S bhgfx gghh hjjkm M-Su 7p-12a       bjim kkoo kkiuuh Th 10p    T  bjklm njkl M-F 6a-3p       I need a output like below For example in first observation Sale_day_name is "Z ww pp M-F 6a-3p" and short_name is MTWTF so it create varible like date day1,day2....day5. Z gg kk pp Sa-Su 6a-8a like day4=Thusday like this each row have one condition.I need a less line code macro query for this. Sale_day_name short_name Day1 Day2 Day3 Day4 Day5 Day6 Day7 Z ww pp M-F 6a-3p MTWTF Monday Tuesday Wednesday Thursday Friday Z tt bb erty M-F 3p-6p MTWTF Monday Tuesday Wednesday Thursday Friday Z gg kk pp Sa-Su 6a-8a       S Saturday Z kk pp llkjhg Sa-Su 6a-8a      SS Saturday Sunday Z kk pp llkjhg M-SU 6p-12a MTWTFSS Monday Tuesday Wednesday Thursday Friday Saturday Sunday KPI M-Su 12a-2a MTWTFSS Monday Tuesday Wednesday Thursday Friday Saturday Sunday gtyuooo cyytrrf vftyu Sa 7p      S Saturday vghj nkiug njhgg Sa 11p      S Saturday bhjmm jjhg jjll M-Su 7p-12a MTWTFSS Monday Tuesday Wednesday Thursday Friday Saturday Sunday bhjmn mkj njk M-Su 7p-12a      S Sunday bhgfx gghh hjjkm M-Su 7p-12a       Monday Tuesday Wednesday Thursday Friday Saturday Sunday bjim kkoo kkiuuh Th 10p    T  Thursday bjklm njkl M-F 6a-3p       Monday Tuesday Wednesday Thursday Friday Please help me to write it. ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎09-01-2015 07:11 AM
Likes given to
Quick links