I was working on a task and just wanted to import a xlsx file. The code is just a normal proc import step as below. Proc import datafile = “//path” out=“want” dbms=xlsx replaces; run; Say there is a column (rating) and contains some varibles like “4B”, “1A”, “3C” etc. But after running the code, It shows as “_x0034_B”, “_x0031_A”, “_x0033_C”, and this also happens on other character format columns. And this issue only exists on a single xlsx file, all other files are worked as usual. I was wondering if there is any error on the specific file. Please help, many thanks. ... View more

Hi all, I have been working on a task, and i need to find those variables that contain the words of a list. Lets say ITEM WORDS 1 AAA 2 BBB 3 CCC 4 DDD 5 EEE COMPANY PROD1 PROD2 PROD3 C1 FAAAC FQQQ FPPP FZZZ C2 FTTTW FUUU FPPP FLLL C3 FOOOC FBBB FPPP FMMM C4 FIIIIC FOOO FPPP FLLL And i want to have the result like COMPANY PROD1 PROD2 PROD3 C1 FAAAC FQQQ FPPP FZZZ C3 FOOOC FBBB FPPP FMMM as the product name in company C1 and C3 hit the words of the list. ... View more