topic Re: Code to move one or more values from column and substitute the number by respective category val in SAS Programming

Code to move one or more values from column and substitute the number by respective category value

Moraes86 — Fri, 30 Apr 2021 16:12:35 GMT

Hi guys,

I am trying to move the values from column "lot" according to each category in different columns A, B and C, according to respective category (A, B or C)

Each column A b and C has the number of the Lots but I would like to substitute the amount of category A (for example 2) by the corresponding Lot ( example Lot 123 and 321).

You can see the attach filed and please let me know how I could create this code

Thanks,

Daniel

Re: Code to move one or more values from column and substitute the number by respective category val

ballardw — Fri, 30 Apr 2021 16:30:50 GMT

Many users here don't want to download Excel files because of virus potential, others have such things blocked by security software. Also if you give us Excel we have to create a SAS data set and due to the non-existent constraints on Excel data cells the result we end up with may not have variables of the same type (numeric or character) and even values.

Re: Code to move one or more values from column and substitute the number by respective category val

Reeza — Fri, 30 Apr 2021 16:37:50 GMT

Is it ever possible to have values in multiple columns of A, B or C?
Is it only 3 possible categories or will this need to scale to more columns/values?