Posted 11-03-2019 05:22 AM (3793 views) | In reply to RADAGBE9 newvar = cats(put(date,mmddyy10.),c1,c2); Maxims of Maximally Efficient SAS ProgrammersHow to convert datasets to data stepsThe macro for direct download as ZIPHow to post codePlease vote for Provide Sequential Search...
Before creating the "Want", i fixed some issues with your "have" datasets: IDs should always be alphanumeric. data work.Have1; length ID $ 5 Customer1-Customer3 $ 2 Cat_Customers $ 20; infile cards missover delimiter='|'; input Id Customer1 Customer2 Customer3 Cat_Customers; cards; ...
Posted 12-11-2019 05:02 AM (1477 views) | In reply to Ronein You need to define the new variable with a sufficient length, or it will default to the length of W and be too short. Maxims of Maximally Efficient SAS ProgrammersHow to convert datasets to data stepsThe macro for...
As you can see, the lengths add up correctly, and there is no space (hex 20) in the variable. In fact, you can see that there's only digits (hex codes 30 to 39). Maxims of Maximally Efficient SAS ProgrammersHow to convert datasets to data stepsThe macro for direct download as ZIP...
Maxims of Maximally Efficient SAS ProgrammersHow to convert datasets to data stepsThe macro for direct download as ZIPHow to post codePlease vote for Provide Sequential Search Capability for Hash ObjectsHow to deal with locked files on UNIX View solution in original post 1 Like 6 REPLIES ...
Posted 12-11-2019 05:02 AM (1457 views) | In reply to Ronein You need to define the new variable with a sufficient length, or it will default to the length of W and be too short. Maxims of Maximally Efficient SAS ProgrammersHow to convert datasets to data stepsThe macro for direct...
Posted 12-11-2017 06:06 AM (1822 views) | In reply to Rohit12 Not using the right tool is plain stupid. @PeterClemmensen's suggestion aptly demonstrates the power of the data step for such a task. Maxims of Maximally Efficient SAS ProgrammersHow to convert datasets to data stepsThe mac...