About GN0001

GN0001 · ‎06-29-2023

Hello, To define a new variable use a LENGTH statement (or the LENGTH= option of the ATTRIB statement). [blueblue]: Are you saying we don't need to use format statement? To define other characteristics of the variable you can also optionally add FORMAT, INFORMAT and LABEL statements (or the corresponding options of the ATTRIB statement). [blueblue]: Are you saying we use format, informat and label statement only when we need to format our character/ date/ datetime filed? Then what is the syntax for adding a new variable to a dataset in a data step? Define length only? or Define length and format only? I appreciate your resposne. Thanks, Blue Blue

GN0001 · ‎06-29-2023

Hello, Thanks for your input. Thanks, Blue Blue

GN0001 · ‎06-29-2023

Hello team, This statement: rename = (patient_stat = Patient_stat2) Doesn't read from right to left? Don't we need format statement when we add a variable to our dataset? Is length statement by itself enough? How do we add a variable to our dataset outside of assignment statement (We don't want to use that variable in an assignment statement in our code)? Thanks for your response. Blue blue

GN0001 · ‎06-29-2023

Data abc; set abc2 (Keep= firstname lastname patient_stat); format Product $10.; product = "ddd"; format PATIENT_STAT $25.; format sex2 $4.; if PATIENT_STAT = 'L' then PATIENT_STAT2 = "LBC"; if PATIENT_STAT = 'U' then PATIENT_STAT2 = "UBC"; rename = (patient_stat = Patient_stat2); drop patient_stat2; run; Hello team, I have this code on the top. The log doesn't show any errors. The program runs and produces the results. The problem is that rename appears as a variable name, as a numeric variable with all 0 across the column. How can I fix this? Regards, Blue Blue

GN0001 · ‎06-02-2023

I acknowledged it, but input data was member Id. If I share it, I can be jailed. My input data is personal health information, I can’t share it. I have mentioned it several times. I always Google before posting my question to this forum if I can’t find the answer, or if I find the answer, again I want to make sure that what I am trying to do is 100 percent correct. Please kindly bear with me. Regards Blue

GN0001 · ‎06-02-2023

Yes correct, it gave me number 17 on my own data. I used it in in substr, Thanks for it, Respectfully, Blue blue

GN0001 · ‎06-01-2023

@Quentin wrote: Please read Tom's answer again. As he explained, SQL doesn't have an assignment statement. He showed examples of creating a new variable via DATA step assignment statement and on a SQL select clause. Yes, I used in both cases, but how about if we don't want to use it in assignment statement. Regards, Blue

GN0001 · ‎06-01-2023

I used Anyalpha, that gave me number 17. I need to use this in a substr function, to get all the string till 17 or till whatever number Anyalpha gives. Regards, blue

GN0001 · ‎06-01-2023

Hello Harry, This didn't work. it gave me 17. Thanks for your input anyway. Respectfully, Blue

GN0001 · ‎06-01-2023

Hello, I tried to use anyalpha, but I couldn't. Can you please kindly guide me? Regards, blue

GN0001 · ‎06-01-2023

Hello team, I am doing an inner join. I have one left table and 4 right tables, I need to do inner joins with these 4 tables. left table with first right table then output left table with second right table then output until the end, but each time I do the joins, the second join should be with the rest of observations that were not joined in the first attempt. I hope this makes sense, if not, please let me know. Respectfully, blue

GN0001 · ‎06-01-2023

Hello, Thanks for response. How can we do it without using assignment statement? Is that possible? Regards Blue

GN0001 · ‎06-01-2023

Hello team, I have a string as this: 1234568F888. I need to find the position of the character in this string. Any help is greatly appreciated. Blue

GN0001 · ‎05-23-2023

Hello team, I have a variable called key and this variable is mapped to many subkeys. Both variables are present in the table. 1-key variable has many values 2- Each key maps to a couple of subkeys. 3-How can I write the program in a data step that I only capture a couple of subkeys for each key, I don't need all of them. 4-Do I need to put it in if else statement? If yes, how can I reach there? Thanks, blue

GN0001 · ‎05-23-2023

Hello, I need to add one assignment statement in the proc sql. New variable = thisvariable - that variable. Please let me know if this is clear. Respectfully, blue

Online Status	Offline
Date Last Visited	‎07-29-2023 03:52 PM

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

How to use rename and drop statements in a data step

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: how to add a new variable in an assignment statement

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

what does && means in a macro in SAS?

Can anyone kindly please explain about this syntax as what it does?

Where clause requires a compatible variable.

To find the difference of two dates

Re: How to clean data to be able to join through it?

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

Re: How to use rename and drop statements in a data step

How to use rename and drop statements in a data step

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: how to add a new variable in an assignment statement

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Re: Find the first occurrence of character in a string.

Output the result of a join

Re: how to add a new variable in an assignment statement

Find the first occurrence of character in a string.

how to write a variable that maps to several variable in a data step

Re: how to add a new variable in an assignment statement