Also why are you implying a decimal place before the last digits?  Do the strings intentionally not include the period character to indicate the location of the decimal place?   That what the .2 in the informat specification 18.2 means.    Read in 18 characters and if there is not explicit decimal point then divide the resulting value by 10**2. Note also that the INPUT() function does not care if the width of the informat is longer than the string being read. So just use the maximum width that the informat allows.  And there is no need to remove the spaces if the variable is not longer than 32 bytes.  And if it is you only need to remove the leading spaces. E_IMPAIRMENT_AMNT=input(left(IMPAIRMENT_AMOUNT_V_120_CD),32.); If you want to test anything you should test that the string is not longer than 32 bytes. if length(left(IMPAIRMENT_AMOUNT_V_120_CD))<= 32 then E_IMPAIRMENT_AMNT=input(left(IMPAIRMENT_AMOUNT_V_120_CD),32.) ;   And using STRIP here makes no sense either: if strip(IMPAIRMENT_AMOUNT_V_120_CD)=" " SAS will treat a string of 100 spaces and one with only one space as being equal since it ignores the trailing spaces.     ... View more

If a client (who hires me because they're less expert than me) wants to tell me which method to use to achieve the goal, I tell them (in very polite words) that they're idiots and should not interfere with the doings of grown-ups. All that a client may tell you without disqualifying them as imbeciles is we have ... (the data they start with) we want ... (the result which should be obtained) we can provide ... (the extent of their SAS license, the available storage, memory etc) How you get from 1 to 2 using 3 is up to you, the expert. ... View more

Good morning Kurt, thank you for your helping explanation. I will keep in mind your advice. The reason of this problem is that I have a database in my company. They said me that I have to do these solutions through updating existing columns (which are added through alter table step). So, the problem is how I can update these. Many thanks ... View more

Hello @Anto180788  It is indeed possible to create a table structure / empty table for the columns highlighted in yellow. As a proof of concept I am giving the code that would create an emtpy table or structure .The variable names, types and size are indicative examples and need to be subsituted with actual values. Data can be stored in the table so created.  Reports can be produced using the data stored in the table. /*This portion creates the table*/ Proc sql; create table work.Empty_table (label="Impact and Substitutability Analysis") ( Market_share num length=8 format=best12. label="Market Share", Impact_on_market char length=100 label="Impact On Market", Substitutability char length=100 label="Substitutability", Critical_function char length=100 label="Critical Function" ); quit; /* This portion gives the details of the table*/ proc contents data=work.empty_ds3; run; The operative portion of the output of the content portion are reproduced below : This shows the structure of the table: This extract shows the table label:       ... View more

If you have macro variable, call it X, with a value like JAN2021 and you want to use it to generate a date you could use it like this: "01&x"d Which will resolve to "01JAN2021"d Which SAS will see is a date. ... View more