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: 
Sukhi1
‎07-20-2023
  • 23 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: Generate hourly SLA for last 14 hours excluding holiday and weeken...

by Calcite | Level 5 in SAS Programming
‎07-20-2023 02:40 AM
‎07-20-2023 02:40 AM
Thank you so much. This what I was looking for. You can't believe how much you helped me by doing this. Thanks again ... View more

Generate hourly SLA for last 14 hours excluding holiday and weekend if...

by Calcite | Level 5 in SAS Programming
‎07-19-2023 01:25 AM
‎07-19-2023 01:25 AM
Hi all, I want to generate a program which will work as per my SLA time. I have a created a format which will tell if a particular date is fall in holiday/weekend. Here is the data I want to print excluding weekend and holiday. my program will run 4 times a day ,7AM , 11AM, 2PM and 4PM. each time I want output like below. for date 18/07/23. either I need 14 row or 17 row                 7AM                                            11AM                                         2PM                                                   4PM 18/07/23     08:00AM                18/07/23     11:00AM              18/07/23     02:00PM       18/07/23     04:00PM  17/07/23     04:00PM                 18/07/23     10:00AM             18/07/23     01:00PM         18/07/23     03:00PM  17/07/23     03:00PM                 18/07/23     09:00AM            18/07/23     12:00PM         18/07/23     02:00PM  17/07/23     02:00PM                 18/07/23     08:00AM           18/07/23     11:00AM          18/07/23     01:00PM  17/07/23     01:00PM                  17/07/23     04:00PM             18/07/23     10:00AM       18/07/23     12:00PM  17/07/23     12:00PM                  17/07/23     03:00PM              18/07/23     09:00AM      18/07/23     11:00AM  17/07/23     11:00AM                   17/07/23     02:00PM              18/07/23     08:00AM      18/07/23     10:00AM  17/07/23     10:00AM                  17/07/23     01:00PM               17/07/23     04:00PM      18/07/23     09:00AM  17/07/23     09:00AM                 17/07/23     12:00PM                17/07/23     03:00PM      18/07/23    08:00AM   17/07/23     08:00AM                 17/07/23     11:00AM                17/07/23     02:00PM      17/07/23     04:00PM  14/07/23    04:00PM                  17/07/23     10:00AM             17/07/23     01:00PM        17/07/23     03:00PM  14/07/23     03:00PM                 17/07/23     09:00AM             17/07/23     12:00PM        17/07/23     02:00PM  14/07/23     02:00PM                  17/07/23     08:00AM             17/07/23     11:00AM        17/07/23     01:00PM  14/07/23     01:00PM                   14/07/23     04:00PM             17/07/23     10:00AM      17/07/23     12:00PM  Please help me create this.   ... View more

Want to create 12 month report but I have data for few months want to ...

by Calcite | Level 5 in SAS Procedures
‎05-23-2023 02:48 AM
‎05-23-2023 02:48 AM
Hi all, I want to create report for 12 months but I will have data to up to current month only. so I want to populate default value for the months which does not have data.   I want something like this :                       Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec A                   2      3     4     5      6       0     0    0      0     0      0       0 B                   2      3     4     5      6       0     0    0      0     0      0       0 C                   2      3     4     5      6       0     0    0      0     0      0       0 D E F the A B C D E F are the some names      but I have data something like this  SRNo       Account      Month        Init 1                  0001             jan           1/23/23 2                 0456             feb          2/15/23 3                 0567              feb         2/27/23 4                 0012              mar       3/3/23 5                0034             apr          4/5/23 6                0009            may        5/18/23 Please help me.    ... View more

Re: Help: Creating Employee Hierarchy from Employee - Manager Relation...

by Calcite | Level 5 in SAS Programming
‎01-29-2019 03:23 AM
‎01-29-2019 03:23 AM
Hi Can you suggest what all modification needs to be done. if we have duplicate(that will form another hierarchy/tree) node. currently I am working on some similar project where I need to create a parent child grandchildren ....so on. relation table. Your code seems to be perfect but only thing is that I have duplicate also in the input file. ... View more

Re: how will you optimize below code?

by Calcite | Level 5 in New SAS User
‎10-16-2018 01:02 AM
‎10-16-2018 01:02 AM
Hi , For now minimum lines of code and less execution time would be good for me. Thanks a lot ... View more

how will you optimize below code?

by Calcite | Level 5 in New SAS User
‎10-15-2018 10:46 AM
‎10-15-2018 10:46 AM
 proc sql;         create table work.EXUPL_GVA2_&YYMM. as         select R.*,                S.FIL as FILMAP, S.KTO as KTOMAP          from  work.EXUPL_GVA1_&YYMM. as R           left join LIB_CLNT.CLIENT2SEGMENT_FKN_FINAL_&YYMM.                (where =( FIL and KTO <=0)) as S            on  R.ORG_ID=S.ORG_ID           ;   quit;   data work.EXUPL_GVA3_&YYMM.;        set work.EXUPL_GVA2_&YYMM.;            if KTO eq 9999989 and KTOMAP not in (. 9999989) then do;               FIL=FILMAP;               KTO=KTOMAP;            end;   run;   proc sql;        create table work.EXUPL_GVA4_&YYMM. as              select R.*                    ,S.PCC                    ,S.GBM              from  work.EXUPL_GVA2_&YYMM. as R              left  join LIB_CLNT.CLIENT_MASTER_&YYMM. as S              on    R.FIL=S.FIL and R.KTO=S.KTO              ;   quit; ... View more

Re: Proc Summary/Mean

by Calcite | Level 5 in SAS Procedures
‎06-07-2018 02:01 AM
‎06-07-2018 02:01 AM
Yes. I did removed it from MAXID clause and it worked fine. Thank you. ... View more

Re: Proc Summary/Mean

by Calcite | Level 5 in SAS Procedures
‎06-07-2018 01:59 AM
‎06-07-2018 01:59 AM
Thanks for you suggestion.I will keep in mind from now onwards. Yes I did try autoname and autolabel but it created new variable gpnr2 and crms_org_id2. May be I have gpnr and crms_org_id in "by" statement also. Anyway I removed it from maxid(variable list) now it is fine. Thanks. ... View more

Proc Summary/Mean

by Calcite | Level 5 in SAS Procedures
‎06-05-2018 03:19 AM
‎06-05-2018 03:19 AM
Proc summary data = LIB_TRN.FFMSUB_SELECTED_1804 nway missing;   by gpnr crms_org_id;   var prov_num;   output out= LIB_TRN.FFMSUB_SELECTED_AGG_1804(drop = _:)   sum= maxid(prov_num(gpnr crms_org_id reporting_period db_filialnummer        db_kontonummer ccdb_id kategorie gpname gbmerker        nachrichtlich))=; quit; WARNING: Variable gpnr already exists on file LIB_TRN.FFMSUB_SELECTED_AGG_1804. WARNING: Variable crms_org_id already exists on file          LIB_TRN.FFMSUB_SELECTED_AGG_1804. WARNING: The duplicate variables will not be included in the output dat          the output statement number 1.   Please help me to remove this warning . ... View more

Re: how to remove conflicting attributes warning from sas proc compare...

by Calcite | Level 5 in SAS Programming
‎05-18-2018 05:59 AM
‎05-18-2018 05:59 AM
thanks I will remove all the format and informat for the time being. ... View more

Re: how to remove conflicting attributes warning from sas proc compare...

by Calcite | Level 5 in SAS Programming
‎05-18-2018 05:47 AM
‎05-18-2018 05:47 AM
I have defined the format for the above field like this . %LET DBETYBRCON_BK = DBETYBRCON_BK LENGTH=8. FORMAT=best12. ; %LET iDBETYBRCON_BK = INFORMAT DBETYBRCON_BK best32. ; now after assignment. that is after this line DBETYBRCON_BK = input(DBETYBRCON_BK1, ?? best32.);" it is getting something like this (proc compare) DBETYBRCON_BK WORK.LIBPRD Num 8 BEST12. BEST32. WORK.LIBNEW Num 8 ... View more

Re: how to remove conflicting attributes warning from sas proc compare...

by Calcite | Level 5 in SAS Programming
‎05-18-2018 04:14 AM
‎05-18-2018 04:14 AM
DBETYBRCON_BK = input(DBETYBRCON_BK1, ?? best32.);" So in this case new variable is DBETYBRCON_BK . right I wanted to have it attributes retained. after assignment. ... View more

Re: how to remove conflicting attributes warning from sas proc compare...

by Calcite | Level 5 in SAS Programming
‎05-18-2018 03:55 AM
‎05-18-2018 03:55 AM
there is no label for DBETYBRCON_BK here. but for the other variable there are label. Yes I have used macro and inside macro i have called that meta variable . does attributes of the variable change when we assign some value to them ? ... View more

Re: how to remove conflicting attributes warning from sas proc compare...

by Calcite | Level 5 in SAS Programming
‎05-18-2018 03:16 AM
‎05-18-2018 03:16 AM
Hello I have used DBETYBRCON_BK = input(DBETYBRCON_BK1, ?? best32.); in data step. also I have a meta data in which I have defined %LET DBETYBRCON_BK = DBETYBRCON_BK LENGTH=8. FORMAT=best12. ; %LET iDBETYBRCON_BK = INFORMAT DBETYBRCON_BK best32. ; %LET DBETYBRCON_BK1 = DBETYBRCON_BK1 FORMAT=$80.; %LET iDBETYBRCON_BK1 = INFORMAT DBETYBRCON_BK1 $80.; so I am unable to find why warning is coming ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎07-20-2023 04:09 AM
Quick links