Hi,
Thank you. I just have one issue. When I run the code in SAS Studio it runs fine. However, when I
run the code in SAS 9.4 I receive an error on this part of code:
if (PUT(Chararacteristic,$subs.)='*') then sub_char = Chararacteristic;
that the Error 48-59: The format subs was not found or could not be loaded. The format was created successfully
in the previous step.
My results were FMTSEARCH=(WORK LIBRARY)
Hmm!, In this case I would double check the formats catalog in the WORK library, to ensure the $subs. format is created correctly.
You might as well test it on a different data set.
@AhmedAl_Attar @A_Kh Thank you both for all of your help. I was able to get the code to work
perfectly. As it turns out, I misspelled characteristic which was why I received the error 🙂
Ugly...but I have done this lol.
Save it as a CSV file.
Read the file in using a data step:
Census bureaus have a format for these type of files that are shared via CSV and this is roughly how they do it.
Or...manually clean up the file, since it's likely a one time read 🙂
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.