Thank you, Chris, for your reply.  I have just begun to read your blog and received a response from my internal SAS contact.  I find there response interesting: "our group does not support issues with copy files task since this is not part of the SAS depot, but we do allow it".  Making these types of necessary processes functional and have to depend on the buddy system continues the inefficiency.  Why isn't this a part of the SAS depot?  I will continue to raise the issue internally.  My working life is filled with these types of workarounds.  It also makes it difficult to train someone new. ... View more

Thank you Reeza and ballardw for your advice.  I have sent your responses to my SAS Support person asking for them to elevate the situation because as you've both mentioned, this is a poor use of manpower.  Thanks to each of you for your time. ... View more

Hi everyone, I want to thank everyone for their time.  I was making something much harder than it needed to be.  All I needed to do was to change the variable RBRVSYear from text to numeric.  After all of my attempts, literally 16 hours, and the feedback from this group I got it done in 10 minutes:  Here is the code that worked.   proc sql; create table folder.pst_reference_cptrbrvs_final as (select input(RBRVSYear, 4.) as RBRVSYear ,SubspecialtyId ,FSSSubspecialtyId ,ProcedureCodeCategory ,ProcedureCode ,ModifierCode ,BlendedSiteOfService ,CignaWorkFactor ,CignaFacilityPracticeFactor ,CignaNonFacilityPracticeFactor ,CignaMalPracticeFactor ,MedicareWorkFactor ,MedicareFacilityPracticeFactor ,MedicareNonFacilityPracticeFac ,MedicareMalpracticeFactor ,LabAmount from folder.pst_reference_cptrbrvs ); quit; ... View more

Here is my attempt without the renaming that Tom has indicated that I need.   I'm not sure how to incorporate Tom's information.   data folder.pst_reference_cptrbrvs_final; LENGTH RBRVSYear $4. SubspecialtyId 3 FSSSubspecialtyId 3 ProcedureCodeCategory $1. ProcedureCode $5. ModifierCode $2. BlendedSiteOfService $1. CignaWorkFactor 8 CignaFacilityPracticeFactor 8 CignaNonFacilityPracticeFactor 8 CignaMalPracticeFactor 8 MedicareWorkFactor 8 MedicareFacilityPracticeFactor 8 MedicareNonFacilityPracticeFac 8 MedicareMalpracticeFactor 8 LabAmount 8; set folder.cpt_expan_annualcodeupdate_fix; format CignaWorkFactor 6.3 CignaFacilityPracticeFactor 6.3 CignaNonFacilityPracticeFactor 6.3 CignaMalPracticeFactor 6.3 MedicareWorkFactor 6.3 MedicareFacilityPracticeFactor 6.3 MedicareNonFacilityPracticeFac 6.3 MedicareMalpracticeFactor 6.3 LabAmount 7.2; run; ... View more

If the list of variables(columns) have some that are numeric and some that are text, which variables should be listed under the "length" and which variables should be listed under the "format"?   ... View more

Thanks for the quick response. I created a SAS dataset on my local drive from information from a DB2 Mainframe. It is my created SAS dataset that I'm not trying to format after some additional manipulations. The Proc Content of my original SAS Dataset is below.   The code that I used to create a new table that has the necessary format is:   proc sql; create table folder.pst_reference_cptrbrvs_work ( RBRVSYear num ,SubspecialtyId num ,FSSSubspecialtyId num ,ProcedureCodeCategory Char(1) ,ProcedureCode Char(5) ,ModifierCode Char(2) ,BlendedSiteOfService Char(1) ,CignaWorkFactor num format=6.3 ,CignaFacilityPracticeFactor num format=6.3 ,CignaNonFacilityPracticeFactor num format=6.3 ,CignaMalPracticeFactor num format=6.3 ,MedicareWorkFactor num format=6.3 ,MedicareFacilityPracticeFactor num format=6.3 ,MedicareNonFacilityPracticeFac num format=6.3 ,MedicareMalpracticeFactor num format=6.3 ,LabAmount num format=7.2  ); quit;   Here is my proc append code:   proc append base = folder.pst_reference_cptrbrvs_work data = folder.pst_reference_cptrbrvs FORCE; run; Alphabetic List of Variables and Attributes # Variable Type Len Format Informat Label 7 BLENDEDSITEOFSERVICE Char 1 $1. $1. BLENDEDSITEOFSERVICE 9 CIGNAFACILITYPRACTICEFACTOR Num 8 8.3 8.3 CIGNAFACILITYPRACTICEFACTOR 11 CIGNAMALPRACTICEFACTOR Num 8 8.3 8.3 CIGNAMALPRACTICEFACTOR 10 CIGNANONFACILITYPRACTICEFACTOR Num 8 8.3 8.3 CIGNANONFACILITYPRACTICEFACTOR 8 CIGNAWORKFACTOR Num 8 8.3 8.3 CIGNAWORKFACTOR 3 FSSSubspecialtyId Num 8       16 LABAMOUNT Num 8 7.2 7.2 LABAMOUNT 13 MEDICAREFACILITYPRACTICEFACTOR Num 8 8.3 8.3 MEDICAREFACILITYPRACTICEFACTOR 15 MEDICAREMALPRACTICEFACTOR Num 8 8.3 8.3 MEDICAREMALPRACTICEFACTOR 14 MEDICARENONFACILITYPRACTICEFAC Num 8 8.3 8.3 MEDICARENONFACILITYPRACTICEFAC 12 MEDICAREWORKFACTOR Num 8 8.3 8.3 MEDICAREWORKFACTOR 6 MODIFIERCODE Char 2 $2. $2. MODIFIERCODE 5 PROCEDURECODE Char 5 $5. $5. PROCEDURECODE 4 PROCEDURECODECATEGORY Char 1 $1. $1. PROCEDURECODECATEGORY 1 RBRVSYEAR Char 4 $4. $4. RBRVSYEAR 2 SubspecialtyId Num 8       ... View more