Hi All, I'm still a novice with SAS programming and I just downloaded the free edition of SAS Studio 3 days ago so please bear with me.. i would really appreciate some specific help with these questions cause i've been searching for hours for solutions on google and just got more confused.Thank you in advance for any assistance provided. 1st how can i convert the variable hold_month values to month-year only (i.e no day)? As you can see below in the variable attributes, I tried reformatting the date9. format from the hold_placed_datetime variable to the format date7. to no avail. 2nd how can I calculate the # of days between the hold_placed_datetime and hold_filled_datetime? Below is a copy of the dataset and proc contents I currently have: hold_placed_datetime hold_filled_datetime source_location_code pickup_location_code hold_month days_till_pickup 28-Oct-14 18-Oct-18 Main Library Main Library 28-Oct-14 3-Mar-15 2-Feb-19 Forest Park Branch Forest Park Branch 3-Mar-15 2-Jun-15 20-Dec-18 Harrison Branch Covedale Branch 2-Jun-15 3-Jun-15 18-Oct-18 West End Branch Delhi Township Branch 3-Jun-15 30-Jun-15 13-Dec-18 Hyde Park Branch Hyde Park Branch 30-Jun-15 3-Jul-15 26-Dec-18 Bond Hill Branch Pleasant Ridge Branch 3-Jul-15 3-Aug-15 18-Oct-18 Miami Township Branch Delhi Township Branch 3-Aug-15 10-Sep-15 20-Feb-19 Green Township Branch Green Township Branch 10-Sep-15 10-Sep-15 7-Jan-19 Harrison Branch Harrison Branch 10-Sep-15 9-Oct-15 12-Jul-19 Wyoming Branch Wyoming Branch 9-Oct-15 The CONTENTS Procedure Data Set NameObservationsMember TypeVariablesEngineIndexesCreatedObservation LengthLast ModifiedDeleted ObservationsProtectionCompressedData Set TypeSortedLabel Data Representation Encoding WORK.IMPORT1 2518839 DATA 6 V9 0 11/17/2019 11:28:03 72 11/17/2019 11:28:03 0 NO NO SOLARIS_X86_64, LINUX_X86_64, ALPHA_TRU64, LINUX_IA64 utf-8 Unicode (UTF-8) Engine/Host Dependent InformationData Set Page SizeNumber of Data Set PagesFirst Data PageMax Obs per PageObs in First Data PageNumber of Data Set RepairsFilenameRelease CreatedHost CreatedInode NumberAccess PermissionOwner NameFile SizeFile Size (bytes) 65536 2775 1 908 871 0 /tmp/SAS_work689500000A1F_localhost.localdomain/SAS_workF77400000A1F_localhost.localdomain/import1.sas7bdat 9.0401M6 Linux 541858 rw-rw-r-- sasdemo 174MB 181927936 Alphabetic List of Variables and Attributes# Variable Type Len Format Informat625143 days_till_pickup Char 1 $1. $1. hold_filled_datetime Num 8 DATE9. DATE9. hold_month Num 8 DATE7. DATE7. hold_placed_datetime Num 8 DATE9. DATE9. pickup_location_code Char 21 $21. $21. source_location_code Char 21 $21. $21.
... View more
