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.
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.