How do I modify the Data step below to decrease the processing time by specifying the records of a specific branch instead of all branches?
DATA transaction; INFILE ’C:/MyRawData/BankTrans.csv’ DLM = ’,’ LRECL = 1500;
INPUT Branch Name Branch ID Trans ID Account Data MMDDYY8. Start Time Time8.
End Time Time8. Amount Balance;
RUN;
DATA transaction;
INFILE 'C:/MyRawData/BankTrans.csv' DLM = ',' DSD LRECL = 1500 OBS=50;
INPUT BranchName $ BranchID $ TransID $ Account $ Date MMDDYY8. StartTime Time8.
EndTime Time8. AmountBalance;
IF BRANCHID = '12345';
RUN;
@collegestudent2 wrote:
How do I modify the Data step below to decrease the processing time by specifying the records of a specific branch instead of all branches?
DATA transaction; INFILE ’C:/MyRawData/BankTrans.csv’ DLM = ’,’ LRECL = 1500;
INPUT Branch Name Branch ID Trans ID Account Data MMDDYY8. Start Time Time8.
End Time Time8. Amount Balance;
RUN;
EDIT: I changed the input code to read in fields like BRANCHID as characters which is the usual standard.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.