04-27-2014 11:46 PM
I am to
Use seed_ as the label in your format. Note, labels are text but the seed_field is
numeric. Use a put function to convert the number to a text. Assume the number will
be in the 2. format.
libname bask 'C://users/zscott1/forsas';
create table changed as
select Team as Start,seed_ as Label
group by Start;
alter table changed
add Fmtname char;
select Label as put(Label_,$2.)
Neither are creating variables for me that work and are created as character variables from the numeric variable 'label';
How will I do this?
04-28-2014 02:43 AM
You need to study the basics of assignments, both in SQL and the data step. Syntax in SQL is:
select expression as colname
You put it other way which clearly doesn't work.
When putting a numerical variable, you use a numeric format, not a char format.
Need further help from the community? Please ask a new question.