Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- This is a method to create a stacked data file from an unstacked Excel sheet.
- GET DATA /TYPE=XLSX
- /FILE='C:\Users\SLeeson\Desktop\16-0299 data unstacked.xlsx'
- /SHEET=name '160299a'
- /CELLRANGE=full
- /READNAMES=on
- /ASSUMEDSTRWIDTH=32767.
- EXECUTE.
- DATASET NAME DataSet1 WINDOW=FRONT.
- VARSTOCASES
- /MAKE section FROM sectiona sectionb sectionc
- /MAKE starrat FROM starratb starratt starratd
- /MAKE oar FROM oarb oart oard
- /MAKE distinc FROM distincb distinct distincd
- /MAKE ratprod FROM ratprodb ratprodt ratprodd
- /MAKE likrec FROM likrecb likrect likrecd
- /MAKE rtoq FROM rtoqb rtoqt rtoqd
- /MAKE rtsoft FROM rtsoftb rtsoftt rtsoftd
- /MAKE rtstre FROM rtstreb rtstret rtstred
- /MAKE rtflex FROM rtflexb rtflext rtflexd
- /MAKE rtthic FROM rtthicb rtthict rtthicd
- /MAKE rtbmc FROM rtbmcb rtbmct rtbmcd
- /MAKE rtcomf FROM rtcomfb rtcomft rtcomfd
- /MAKE rttrus FROM rttrusb rttrust rttrusd
- /MAKE rtplsh FROM rtplshb rtplsht rtplshd
- /MAKE rtsilk FROM rtsilkb rtsilkt rtsilkd
- /MAKE rtgld FROM rtgldb rtgldt rtgldd
- /MAKE rttxtr FROM rttxtrb rttxtrt rttxtrd
- /MAKE rtwtnss FROM rtwtnssb rtwtnsst rtwtnssd
- /MAKE rtsafe FROM rtsafeb rtsafet rtsafed
- /MAKE rtscnt FROM rtscntb rtscntt rtscntd
- /MAKE rtclnfc FROM rtclnfcb rtclnfct rtclnfcd
- /MAKE rtallnd FROM rtallndb rtallndt rtallndd
- /MAKE rtsnsv FROM rtsnsvb rtsnsvt rtsnsvd
- /MAKE rtgntc FROM rtgntcb rtgntct rtgntcd
- /MAKE rtpckg FROM rtpckgb rtpckgt rtpckgd
- /MAKE rtbgms FROM rtbgmsb rtbgmst rtbgmsd
- /MAKE rtboth FROM rtbothb rtbotht rtbothd
- /MAKE rtspng FROM rtspngb rtspngt rtspngd
- /MAKE rtsmth FROM rtsmthb rtsmtht rtsmthd
- /MAKE rtfew FROM rtfewb rtfewt rtfewd
- /MAKE rtntmr FROM rtntmrb rtntmrt rtntmrd
- /MAKE rteffc FROM rteffcb rteffct rteffcd
- /MAKE rtbttr FROM rtbttrb rtbttrt rtbttrd
- /MAKE rtlasts FROM rtlastsb rtlastst rtlastsd
- /MAKE rthlth FROM rthlthb rthltht rthlthd
- /MAKE rtnors FROM rtnorsb rtnorst rtnorsd
- /MAKE rtntwt FROM rtntwtb rtntwtt rtntwtd
- /MAKE rtdobst FROM rtdobstb rtdobstt rtdobstd
- /MAKE rtlsst FROM rtlsstb rtlsstt rtlsstd
- /MAKE rtabst FROM rtabstb rtabstt rtabstd
- /MAKE rtstrc FROM rtstrcb rtstrct rtstrcd
- /MAKE rtsywt FROM rtsywtb rtsywtt rtsywtd
- /MAKE rtsfsk FROM rtsfskb rtsfskt rtsfskd
- /MAKE rtpymr FROM rtpymrb rtpymrt rtpymrd
- /MAKE rtsplrg FROM rtsplrgb rtsplrgt rtsplrgd
- /MAKE rtlxry FROM rtlxryb rtlxryt rtlxryd
- /MAKE rtmssk FROM rtmsskb rtmsskt rtmsskd
- /MAKE rtmshn FROM rtmshnb rtmshnt rtmshnd
- /MAKE rtoabw FROM rtoabwb rtoabwt rtoabwd
- /MAKE rtpttrn FROM rtpttrnb rtpttrnt rtpttrnd
- /MAKE rtlkst FROM rtlkstb rtlkstt rtlkstd
- /MAKE rtlkc FROM rtlkcb rtlkct rtlkcd
- /MAKE rtlkth FROM rtlkthb rtlktht rtlkthd
- /MAKE rtlkab FROM rtlkabb rtlkabt rtlkabd
- /MAKE rtlkcs FROM rtlkcsb rtlkcst rtlkcsd
- /MAKE rtlkprm FROM rtlkprmb rtlkprmt rtlkprmd
- /MAKE rtlkprt FROM rtlkprtb rtlkprtt rtlkprtd
- /MAKE rtlkpl FROM rtlkplb rtlkplt rtlkpld
- /MAKE rtlksl FROM rtlkslb rtlkslt rtlksld
- /MAKE rtlkpm FROM rtlkpmb rtlkpmt rtlkpmd
- /MAKE rtlkspl FROM rtlksplb rtlksplt rtlkspld
- /MAKE rtlkmd FROM rtlkmdb rtlkmdt rtlkmdd
- /MAKE rtlklx FROM rtlklxb rtlklxt rtlklxd
- /MAKE rtlkimg FROM rtlkimgb rtlkimgt rtlkimgd
- /MAKE rtlksf FROM rtlksfb rtlksft rtlksfd
- /MAKE rtlkgnt FROM rtlkgntb rtlkgntt rtlkgntd
- /MAKE rtdpez FROM rtdpezb rtdpezt rtdpezd
- /MAKE rtdpon FROM rtdponb rtdpont rtdpond
- /MAKE rtstwh FROM rtstwhb rtstwht rtstwhd
- /MAKE rtnxt FROM rtnxtb rtnxtt rtnxtd
- /MAKE rtflsft FROM rtflsftb rtflsftt rtflsftd
- /MAKE rtflth FROM rtflthb rtfltht rtflthd
- /MAKE rtflch FROM rtflchb rtflcht rtflchd
- /MAKE rtflcn FROM rtflcnb rtflcnt rtflcnd
- /MAKE rtflpl FROM rtflplb rtflplt rtflpld
- /MAKE rtflslk FROM rtflslkb rtflslkt rtflslkd
- /MAKE rtflcw FROM rtflcwb rtflcwt rtflcwd
- /MAKE rtflpr FROM rtflprb rtflprt rtflprd
- /MAKE rtflst FROM rtflstb rtflstt rtflstd
- /MAKE rtflpm FROM rtflpmb rtflpmt rtflpmd
- /MAKE rtrtwt FROM rtrtwtb rtrtwtt rtrtwtd
- /MAKE rtenez FROM rtenezb rtenezt rtenezd
- /MAKE rtsfwp FROM rtsfwpb rtsfwpt rtsfwpd
- /MAKE rtthwp FROM rtthwpb rtthwpt rtthwpd
- /MAKE rtgldc FROM rtgldcb rtgldct rtgldcd
- /MAKE rtnttr FROM rtnttrb rtnttrt rtnttrd
- /MAKE rtclwp FROM rtclwpb rtclwpt rtclwpd
- /MAKE rtsmwp FROM rtsmwpb rtsmwpt rtsmwpd
- /MAKE rtgnsk FROM rtgnskb rtgnskt rtgnskd
- /MAKE rtezcl FROM rtezclb rtezclt rtezcld
- /MAKE rtntpk FROM rtntpkb rtntpkt rtntpkd
- /MAKE rtrtgp FROM rtrtgpb rtrtgpt rtrtgpd
- /MAKE rtezcr FROM rtezcrb rtezcrt rtezcrd
- /MAKE rtwkpr FROM rtwkprb rtwkprt rtwkprd
- /MAKE rttpbm FROM rttpbmb rttpbmt rttpbmd
- /MAKE rtfxwp FROM rtfxwpb rtfxwpt rtfxwpd
- /MAKE rtflcsh FROM rtflcshb rtflcsht rtflcshd
- /MAKE rttxez FROM rttxezb rttxezt rttxezd
- /MAKE rtezcn FROM rtezcnb rtezcnt rtezcnd
- /MAKE rtabur FROM rtaburb rtaburt rtaburd
- /MAKE rtntlv FROM rtntlvb rtntlvt rtntlvd
- /MAKE rtflsk FROM rtflskb rtflskt rtflskd
- /MAKE rtflsth FROM rtflsthb rtflstht rtflsthd
- /MAKE rtntsm FROM rtntsmb rtntsmt rtntsmd
- /MAKE rtalcln FROM rtalclnb rtalclnt rtalclnd
- /MAKE rtefgn FROM rtefgnb rtefgnt rtefgnd
- /MAKE rtefst FROM rtefstb rtefstt rtefstd
- /MAKE rtefps FROM rtefpsb rtefpst rtefpsd
- /MAKE rtefrn FROM rtefrnb rtefrnt rtefrnd
- /MAKE rtafwt FROM rtafwtb rtafwtt rtafwtd
- /MAKE rtafcm FROM rtafcmb rtafcmt rtafcmd
- /MAKE rtafsf FROM rtafsfb rtafsft rtafsfd
- /MAKE rtafls FROM rtaflsb rtaflst rtaflsd
- /MAKE rtafgn FROM rtafgnb rtafgnt rtafgnd
- /MAKE rtafcl FROM rtafclb rtafclt rtafcld
- /MAKE rtafms FROM rtafmsb rtafmst rtafmsd
- /MAKE rtafef FROM rtafefb rtafeft rtafefd
- /MAKE rtafez FROM rtafezb rtafezt rtafezd
- /MAKE rtcutx FROM rtcutxb rtcutxt rtcutxd
- /MAKE rtcust FROM rtcustb rtcustt rtcustd
- /MAKE rtcuso FROM rtcusob rtcusot rtcusod
- /MAKE rtcuth FROM rtcuthb rtcutht rtcuthd
- /MAKE rtcusf FROM rtcusfb rtcusft rtcusfd
- /MAKE rtcufx FROM rtcufxb rtcufxt rtcufxd
- /MAKE rtcuwt FROM rtcuwtb rtcuwtt rtcuwtd
- /MAKE rtcuaf FROM rtcuafb rtcuaft rtcuafd
- /MAKE rtcugp FROM rtcugpb rtcugpt rtcugpd
- /MAKE rtcugd FROM rtcugdb rtcugdt rtcugdd
- /MAKE rtcusz FROM rtcuszb rtcuszt rtcuszd
- /MAKE rtcuam FROM rtcuamb rtcuamt rtcuamd
- /MAKE rtcusc FROM rtcuscb rtcusct rtcuscd
- /MAKE rtcusk FROM rtcuskb rtcuskt rtcuskd
- /MAKE rtcupl FROM rtcuplb rtcuplt rtcupld
- /MAKE rtcusy FROM rtcusyb rtcusyt rtcusyd
- /MAKE rtcugn FROM rtcugnb rtcugnt rtcugnd
- /MAKE rtcusu FROM rtcusub rtcusut rtcusud
- /MAKE rtcups FROM rtcupsb rtcupst rtcupsd
- /MAKE rtcurn FROM rtcurnb rtcurnt rtcurnd
- /MAKE exptor FROM exptorb exptort exptord
- /MAKE exptus FROM exptusb exptust exptusd
- /MAKE exp2wt FROM exp2wtb exp2wtt exp2wtd
- /MAKE exp2sl FROM exp2slb exp2slt exp2sld
- /MAKE expdry FROM expdryb expdryt expdryd
- /MAKE expirr FROM expirrb expirrt expirrd
- /MAKE expres FROM expresb exprest expresd
- /MAKE expgrp FROM expgrpb expgrpt expgrpd
- /MAKE expfzz FROM expfzzb expfzzt expfzzd
- /MAKE expfry FROM expfryb expfryt expfryd
- /MAKE howhld FROM howhldb howhldt howhldd
- /MAKE typdp FROM typdpb typdpt typdpd
- /MAKE bmcns FROM bmcnsb bmcnst bmcnsd
- /MAKE bmcnsm FROM bmcnsmb bmcnsmt bmcnsmd
- /MAKE fdp2w FROM fdp2wb fdp2wt fdp2wd
- /MAKE nmwpch FROM nmwpchb nmwpcht nmwpchd
- /MAKE headline FROM headlineb headlinet headlined
- /MAKE review FROM reviewb reviewt reviewd
- /MAKE fv FROM fvb fvt fvd
- /MAKE uf FROM ufb uft ufd
- /MAKE scentoe FROM scentoeb scentoet scentoed
- /MAKE typckoe FROM typckoeb typckoet typckoed
- /MAKE fdp3woe FROM fdp2woeb fdp2woet fdp2woed
- /INDEX=Index1(2)
- /KEEP=serialb serialt seriald resp_id code nmbpcks usdrct typpckb typpckd bmcnsd bmcnsmd fdp2wd nmwpchd hohs nmbpcks usdrct ageresp hvchld momnb primshop ftmmom occup employ empby agchld1 agchld2 gnchld1 gnchld2 agqual gnqual food itpp3m itpp6m brpp3m bumos prcvals numuss numchs scntlks nvrprcs pottys pumos pumocs bmcons bmconcs sknprbs medisus incomus incomcs educus empus ethnic pstprt seg1 seg2 prchbws mis nmbrbms bumotyp locatn prfopd prfappd prfsftd prfthkd prfslkd prfcmfd prfbmcd prfstrd prfprtd prfgldd prfamtd prfezcd prfprsd prfmstd prfplsd prfcshd prfntsd prftxtd prfpayd prfstsd expst1d expst2d expst3d stmbstd stmdeld stmvald stmsacd stmexpd stmndmd stmclnd stmsamd stmnbtd stmcurd agrseld agrcard agrwipd hdld2 revd2.
- /NULL=KEEP.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement