Hi Team   I am running the below code and am getting space in the output. The &comp. is the global variable. Is there any way that we can remove the space at the output.   data _null_; set &outdat.; file "&drv2./test/Current/&benpk._&comp._00.txt" ls = 4000 mod; put '"' name +(-1) '",' '"' fname +(-1) '",' '"'zip +(-1) '",' run;   E_42 _00.txt   NEED: E_42_00.txt   Thank You ... View more

Hi All, We are migrating the SAS programs from 9.3 to viya. When we run the below macro code the office hours are created as expected IN 9.3, but in 9.4 the output was different. Not sure what to update on 9.4 to get the same results as in 9.3.   %macro time(day,when,table); data hours1a; set &table; format time1 timeampm8. time2 $8. &day.&when.a $7.; time1=&day.&when; time2=put(time1,timeampm8.); if time2='12:00 AM' then time2='00:00 PM'; hr=kscan(time2,1,':'); l=length(ktrim(kleft(hr))); if l=1 then time2='0'||ktrim(kleft(time2)); &day.&when.a=kcompress(time2,''); drop time1 time2 l hr; run; %mend time; %time(su,beg1,anc1); %time(su,end1,hours1a); %time(mo,beg1,hours1a); %time(mo,end1,hours1a); %time(tu,beg1,hours1a); %time(tu,end1,hours1a); %time(we,beg1,hours1a); %time(we,end1,hours1a); %time(th,beg1,hours1a); %time(th,end1,hours1a); %time(fr,beg1,hours1a); %time(fr,end1,hours1a); %time(sa,beg1,hours1a); %time(sa,end1,hours1a);   data hours2a; set hours1a; format sunday1 monday1 tuesday1 wednesday1 thursday1 friday1 saturday1 $50.; sunday1=subeg1a||'-'||suend1a||'00:00PM-00:00PM 00:00PM-00:00PM'; monday1=mobeg1a||'-'||moend1a||'00:00PM-00:00PM 00:00PM-00:00PM'; tuesday1=tubeg1a||'-'||tuend1a||'00:00PM-00:00PM 00:00PM-00:00PM'; wednesday1=webeg1a||'-'||weend1a||'00:00PM-00:00PM 00:00PM-00:00PM'; thursday1=thbeg1a||'-'||thend1a||'00:00PM-00:00PM 00:00PM-00:00PM'; friday1=frbeg1a||'-'||frend1a||'00:00PM-00:00PM 00:00PM-00:00PM'; saturday1=sabeg1a||'-'||saend1a||'00:00PM-00:00PM 00:00PM-00:00PM'; keep provno sunday1 monday1 tuesday1 wednesday1 thursday1 friday1 saturday1; run;   output: 9.3   output9.4   Thanks . ... View more

  I have a data set with a bunch of code as example below. I want to delete the code BH1003 for all LOB’s except HAR. Any help with SAS code is much appreciated.   Code                                     LOB BH1003                                 HAR BH1003                                 LIP BH1003,BH1005,BH1007   LIP BH1005                                 MA AEHJ                                    IP BH1003,BH1006,BH1008   HAR BH1006,BH1003,BH1004   CCC   Want Code                                     LOB BH1003                                 HAR BH1005,BH1007     LIP BH1005                                 MA AEHJ                                    IP BH1003,BH1006,BH1008   HAR BH1006, BH1004                 CCC ... View more

Hi all,   I am looking for a support to write a stored procedure and deploy as web service. Can you please share any share program.   Thanks in advance.       ... View more

Hi all,   I want to read all the table names from the database (dsn 'EDS').Currently I knew only 2 tables names to view all the data content information.   How can I pull all the table info from the database?   proc sql; connect to odbc as DW (dsn="EDS" uid=dw pwd=dw); create table hospmst as select * from connection to DW (select * from HOSPMaster); create table hospdiv as select * from connection to DW (select * from HOSPdivisions); quit;   Thanks in Advance.   Thanks. ... View more

Hello Team,   How to get all numeric fields stats details by using PROC MEANS and output should be in SAS dataset (no need report). Input: Num1 New_Ques New_Status_1 new_ Interval New_Status_2 new_ address 234 13 8 7 14 24 431 20 8 6 14 28 755 36 8 6 13 27 753 28 14 9 13 17 941 28 8 6 14 15 526 33 8 6 14 20 621 46 14 7 13 14 834 29 8 6 14 22     Output: Var Mean Std Min Max P5 P25 P50 P75 Num1 636.875 231.7717 234 941 234 478.5 234 794.5 New_Ques 29.125 9.948977 13 46 13 24 13 34.5 New_Status_1 9.5 2.77746 8 14 8 8 8 11 new_ Interval 6.625 1.06066 6 9 6 6 6 7 New_Status_2 13.625 0.517549 13 14 13 13 13 14 new_ address 20.875 5.303301 14 28 14 16 14 25.5 ... View more

Hi ,   I have a dataset A and need to create multiple datasets based on the compno ,lobcod and dirsection values.   I want to simplify the below steps instead of creating multiple lines.     if compno in ('02','34') and lobcod in ('FDA','SHP') and dirsection='NP' then do; ptype='NP'; output NP; end; if compno in ('02','34') and lobcod in ('FDA','SHP') and dirsection='ADHS' then do; ptype='ADHS'; output ADHS; end; if compno in ('02','34') and lobcod in ('FDA','SHP') and dirsection='aadh' then do; ptype='AADH'; output AADH; end;   Thanks in Advance. if compno in ('02','34') and lobcod in ('FDA','SHP') and dirsection='CDPAS' then do; ptype='CDPAS'; output CDPAS; end; ... View more