Hello,
I was wondering when doing a Proc Transpose, i want to keep one variable just as it was. And copy it to the whole dataset.
proc transpose data = TEMP.TRANSP () out = work.W6GBUSX6 () ;
by TABLE_KEY;
var INTERNAL_ORG_REFERENCE_NO AGGREGATION_ID CIC_EXT_NUM INTEREST_TYPE_CD;
copy X_SOURCE_DETAIL_CD;
run;
but the problem is the X_SOURCE_DETAIL_CD is only filled in one of the four lines...any help?
Sorry, not sure I follow. If you want that variable to remain as is and present on each line, then put it in the by line:
proc transpose data = TEMP.TRANSP () out = work.W6GBUSX6 () ;
by TABLE_KEY X_SOURCE_DETAIL_CD;
var INTERNAL_ORG_REFERENCE_NO AGGREGATION_ID CIC_EXT_NUM INTEREST_TYPE_CD;
run;
Sorry, not sure I follow. If you want that variable to remain as is and present on each line, then put it in the by line:
proc transpose data = TEMP.TRANSP () out = work.W6GBUSX6 () ;
by TABLE_KEY X_SOURCE_DETAIL_CD;
var INTERNAL_ORG_REFERENCE_NO AGGREGATION_ID CIC_EXT_NUM INTEREST_TYPE_CD;
run;
thanks.. damn, that simple
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.