Hello.
I am having some trouble with a Proc Summary that I am hoping to get some help on.
Here is what I am trying to run:
PROC SUMMARY DATA=ONHAND;
BY STKCD;
VAR ONHAND;
OUTPUT OUT = SUM_ONHAND
SUM=;
RUN;
However my ONHAND column from ONHAND is listed as a character because when this was imported from a .txt file when the ONHAND count is negative they have a minus sign and the number in between a lot of spaces. (ie. - 4), So I compressed it to take away the spaces but now when I run the PROC SUMMARY I get the following message:
ERROR: Variable ONHAND in list does not match type prescribed for this list.
I appreciate any help that can be given.
You need to create a numeric variable.
data fixed_onhand;
set onhand (rename=(onhand = char_onhand));
onhand = input(char_onhand,best.);
run;
thanks for the help
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.