Hello,
I managed to create the desired data set. I have one last question pertaining to a permanent save of outputted data. I thought if I write the libname in "output out=onetlib.onetmerge" in the proc summary that it would create a permanent dataset regardless of whether the formats are permanent (since in proc format I use "library=work;"). When I ask it to proc print the data without a proc format running, it states "ERROR: Format $OCCF not found or couldn't be loaded for variable OCCSOC."
I plan to merge this with other data (IPUMS) and I would like to save permanent sets, and have multiple copies in different locations.
Thanks so much!!!
Diana
Current syntax:
libname ONETlib 'C:\Users\..'
proc format library=work; value $occf '11-1021.00'='111021' '11-1011.00', '11-1011.03', '11-1031.00'='1110XX'
.
.
'53-7111.00', '53-7121.00'='5371XX';
run;
proc summary data=onetlib.onet nway; class occsoc; format occsoc $occf.; var cognitiveindex manuphysindex workvaluesindex workstylesindex technicalindex manageindex environindex jobhazardindex bodypositindex ; output out=onetlib.onetmerge (drop=_type_ _freq_) mean=; run;
proc print data=onetlib.onetmerge; run;
... View more