SAS Support Communities

cho16 · ‎02-09-2023

Hi Team, One column that has weekdays, timings, and a delimiter . what I want to divide into seven columns based on the delimiter ,. Additionally, the values are separated by a comma. It was closed on some of the days. The data I have looks like this: data have; length days $200; infile datalines truncover; input days $ 1-200; datalines; Sun CLOSED, Mon 9:00AM-6:30PM, Tue 9:00AM-6:30PM, Wed 9:00AM-6:30PM, Thu 9:00AM-6:30PM, Fri 9:00AM-6:30PM, Sat 9:00AM-4:00PM, Sun 10:00AM-9:00PM, Mon 8:00AM-9:00PM, Tue 8:00AM-9:00PM, Wed 8:00AM-9:00PM, Thu 8:00AM-9:00PM, Fri 8:00AM-9:00PM, Sat 8:00AM-9:00PM, Sun CLOSED, Mon 8:00AM-5:00PM, Tue 8:00AM-5:00PM, Wed 8:00AM-5:00PM, Thu 8:00AM-5:00PM, Fri 8:00AM-5:00PM, Sat CLOSED, ; run; I want data as I tried the below code data want (drop=days); set have; Sunday = scan(days,1,','); monday = scan(days,2,','); tuesday = scan(days,3,','); wednesday = scan(days,4,','); thursday = scan(days,5,','); friday = scan(days,6,','); saturday = scan(days,7,','); run;

cho16 · ‎02-06-2023

Good Morning all, I am seeing formatting problems while adding a column to the existing code. Existing: After adding new column: ods _all_ close; ods excel /* file="%sysget(DSR_DIR)/NonKYC_Delta_CRS_CCMP6754_Response_File_View_&fDate2..xlsx"*/ file="&DSR_DIR./NonKYC_Delta_CRS_CCMP6754_Response_File_View_&fDate2._upd1.xlsx" style=HTMLBlue; ods Excel options ( sheet_name="Summary" start_at="A1" tab_color="gold" autofilter="all" frozen_headers="on" FLOW="HEADERS" FITTOPAGE="OFF" absolute_column_width="6,12,12,26,7,11,7,7,7,9,9,7"); proc report data=Stat_look_week ; columns Week Day Date Workflow_BU LOB Names_Screened Hits Alerts Hit_Rate Alert_Rate shared_acts acts_diff; define Week /display 'Week' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={ tagattr='wraptext:no' just=c}; define Day /display 'Day' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={ tagattr='wraptext:yes' just=l}; define Date /display 'Date' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={ tagattr='wraptext:no' just=l}; define Workflow_BU /display 'Workflow Business Unit' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=l}; define LOB /display 'LOB' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=c} style(column)={tagattr='wraptext:no' just=c}; define Names_Screened /Display width=11 'Names Screened' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Hits /display 'Hits' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Alerts /display 'Alerts' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Hit_Rate /display 'Hit Rate' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Alert_Rate /display 'Alert Rate' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define shared_acts /display 'shared_acts' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define acts_diff /display 'acts_diff' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; compute LOB; if substr(LOB,1,4)='Week' then do; call define(_row_,"style","style={background=lightgray}"); call define(_col_,"style","style={tagattr='wraptext:no' just=r fontstyle=italic fontweight=bold}"); end; endcomp; run; Please let me know if i need to add any additional options to remain same format . Thanks in advance !

cho16 · ‎02-06-2023

Good Morning all, I am seeing formatting problems while adding a column to the existing code. Existing: After adding new column: ods _all_ close; ods excel /* file="%sysget(DSR_DIR)/NonKYC_Delta_CRS_CCMP6754_Response_File_View_&fDate2..xlsx"*/ file="&DSR_DIR./NonKYC_Delta_CRS_CCMP6754_Response_File_View_&fDate2._upd1.xlsx" style=HTMLBlue; ods Excel options ( sheet_name="Summary" start_at="A1" tab_color="gold" autofilter="all" frozen_headers="on" FLOW="HEADERS" FITTOPAGE="OFF" absolute_column_width="6,12,12,26,7,11,7,7,7,9,9,7"); proc report data=Stat_look_week ; columns Week Day Date Workflow_BU LOB Names_Screened Hits Alerts Hit_Rate Alert_Rate shared_acts acts_diff; define Week /display 'Week' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={ tagattr='wraptext:no' just=c}; define Day /display 'Day' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={ tagattr='wraptext:yes' just=l}; define Date /display 'Date' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={ tagattr='wraptext:no' just=l}; define Workflow_BU /display 'Workflow Business Unit' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=l}; define LOB /display 'LOB' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=c} style(column)={tagattr='wraptext:no' just=c}; define Names_Screened /Display width=11 'Names Screened' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Hits /display 'Hits' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Alerts /display 'Alerts' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Hit_Rate /display 'Hit Rate' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define Alert_Rate /display 'Alert Rate' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define shared_acts /display 'shared_acts' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; define acts_diff /display 'acts_diff' style(header)={tagattr='wraptext:yes' height = 44 vjust=t just=l} style(column)={tagattr='wraptext:no' just=r}; compute LOB; if substr(LOB,1,4)='Week' then do; call define(_row_,"style","style={background=lightgray}"); call define(_col_,"style","style={tagattr='wraptext:no' just=r fontstyle=italic fontweight=bold}"); end; endcomp; run; Please let me know if i need to add any additional options to remain same format . Thanks in advance !

cho16 · ‎09-06-2022

Hi .. When I try to use the code below, I receive the error message listed below. Kindly help me with this. %let date_cntrl = %sysfunc(intnx(day, %sysfunc(today()), -7), mmddyy10.); %put &date_cntrl.; data week; set Stat_look; where date <= '&date_cntrl.'d; run; Getting an below error:

cho16 · ‎08-30-2022

Hi For example, if I export the current day file to the share point, the current day will be appended to that location, and the last day file should be deleted. I only want to keep the files for 40 days on the share point site. If there are any possibilities for implementing that logic on the proc export, please share your ideas.

cho16 · ‎08-09-2022

Hi .. Need a help on this. I have a dataset with the following attributes: id, typ(XN, IN), and sysdat. If an ID contains both XN and IN, only IN records should be retrieved. If the ID contains XN records, only XN records must be retrieved. If the ID conatins IN records , only IN records must be retrieved. Input : ID typ sysdat 123 IN 2210128 123 IN 2210128 123 XN 2410128 124 XN 2210128 125 IN 2210128 125 IN 2210128 Ouput : ID typ sysdat 123 IN 2210128 124 XN 2210128 125 IN 2210128 Thanks in Advance..

cho16 · ‎08-09-2022

Sorry typo mistake...If an ID contains both XN and IN, only XN records should be retrieved.

cho16 · ‎08-09-2022

Sorry typo mistake If an ID contains both XN and IN, only IN records should be retrieved.

cho16 · ‎08-09-2022

Hi .. Need a help on this. I have a dataset with the following attributes: id, typ(XN, IN), and sysdat. If an ID contains both XN and IN, only XN records should be retrieved. If the ID contains XN records, only XN records must be retrieved. If the ID conatins IN records , only IN records must be retrieved. Input : ID typ sysdat 123 IN 2210128 123 IN 2210128 123 XN 2410128 124 XN 2210128 125 IN 2210128 125 IN 2210128 Ouput : ID typ sysdat 123 IN 2210128 124 XN 2210128 125 IN 2210128 Thanks in Advance..

cho16 · ‎08-05-2022

Thanks Reeza..we are using SAS EG

cho16 · ‎08-05-2022

Our organization has a lot of plans. The vendor will put the file in one place if we wish to eliminate one plan from the extract. For instance, the deconversion is a one-time activity for the August release; the same process should not be followed for the September release; again, the deconversion will occur for the November release; hence, there is no need to modify the SAS code; rather, additional conditions must be included.Hope this helps

cho16 · ‎08-05-2022

Tom...Below I have provided some additional details.. Can we add a flag that says "Y" or "N"? If changes need to be made, set the flag to "Y" and start the process. If not, the procedure shouldn't start. DATA DE_CONVER_ACTS; infile "/hf_out.txt" dsd dlm='|' MISSOVER FIRSTOBS=2 end=eof; length ACCOUNT$ 16 SYS$ 4 MEMBER$ 4 AGENT$ 4 Date$ 8 ; input ACCOUNT$ SYS$ PRIN$ MEMBER $ Date$ ; run;

cho16 · ‎08-05-2022

Hi there, We aim to add some additional logic to the prod code that already exists. The code should read the text file as though it were a one-time task if any plans needed to be removed from the logic. Otherwise, 0 values must be read from the text file. Is it possible to add logic to it in any way? Thanks in advance

cho16 · ‎11-04-2021

Thank You everyone ! i have used the below code to rename the external file. data _null_; RC1=rename("&drv2./test/Current/C.txt", "&drv2./test/Current/C.txt", "file"); run;

cho16 · ‎11-04-2021

Yes i tried the trim function, still getting a space. Is there any option to change the output text file name from SAS data step ?

Online Status	Offline
Date Last Visited	‎10-09-2024 03:21 PM

SAS Support Communities

Splitting one column values into seven columns

Proc report formatting issue

proc report formatting issue

Date logic error

Proc export —keeping files for limited days option

Select a first observations from the data

Re: Select first records from the dataset

Re: Select first records from the dataset

Select first records from the dataset

Re: need to read text file has zero

Re: Select first records from the dataset

Re: Delete a multiple values in a variable

Re: Help with Date macro

Re: Nees to create Indicator to show the Hours

Re: convert text to numeric date function

Re: Help with Date macro

Splitting one column values into seven columns

Proc report formatting issue

proc report formatting issue

Date logic error

Proc export —keeping files for limited days option

Select a first observations from the data

Re: Select first records from the dataset

Re: Select first records from the dataset

Select first records from the dataset

Re: need to read text file has zero

Re: need to read text file has zero

Re: need to read text file has zero

need to read text file has zero

Re: Space in output file

Re: Space in output file

Follow Us

What is...