I have the PROC EXPORT statement with a KEEP statement in the DATA step, I thought, would simultaneously keep the variables from my data set I want to export and retain them in this order. However, when I run this statement, the variables are not in this order. How do I assign variable order in my EXPORT statement so I don't have to manually reorder them in excel? Thanks! PROC EXPORT
DATA=Work.Surveytempdata
(keep=Response_ID Response_Status Region_ AnotherOffer Job Q11 Q12 Length_Employment Q14 Q15 Q16 Q17 Q18 Q19 Q20 Q21 Q22 Q23 Q24 TrainingYN Q26 Q27 Q28 Q29 Q30 Q31 Q32 TrainingOther Q33 TrainingTimeframe Q35 TrainingPreparedMe
Q37 Q38 Q39 Q40 Q41 Q42 ChangeTrainingOther WorkloadExpected WorkloadNotExpected Q46 PhysicallyDemanding TooPhysicallyDemanding MostPhysicallyDemanding Q50 WorkingConditions
Q52 Q53 Q54 Q55 WorkingConditionsOther Q56 InfoForJob Q58 Q59 Q60 Q61 InfoForJobOther Q62 ToolsResources Q64 Q65 ToolsResourcesOther Q66 SkillsAbilities Q68
SupervisorCommunication Q70 DignityRespect Q72 WorkAgain Q74 Q75)
OUTFILE='\\SharedDrive\Desktop\survey'
DBMS=xlsx;
label;
run;
... View more
