About webart999ARM

webart999ARM · ‎02-03-2022

Interesting approach. I will definitely try it. Thank you 🙂

webart999ARM · ‎02-03-2022

Thank you @Reeza Added 'options validvarname=v7;' at the top of my program. Now I have _1, _2, and _3 variables instead of 1, 2, and 3. Appreciate all your responses guys. Have a good rest of your day. Regards Artur

webart999ARM · ‎02-03-2022

Thank you for your response @maguiremq and @Tom , but it doesn't work that way. I tried to perform three different actions with that variable with a numeric name, but had no success.

webart999ARM · ‎02-03-2022

Hello folks. I faced some strange thing today which I have never seen before. After running a reference code that I have to use, I find out that some variables have numeric variable names (i.e. 1, 2, 3). I want to make some changes to them but I have no idea how to refer them. Task needs to be accomplished - Convert values in variables 1, 2, and 3 from numeric to char. Thank you in advance. Kind Regards Artur

webart999ARM · ‎09-06-2021

Thank you all for your suggestions. The solution(temporary) was to convert .xlsx to .xls format. After that using the same import procedure the excess characters were gone. Kind Regards Artur

webart999ARM · ‎09-06-2021

Thanks for your reply Tom. Value of automatic macro variable &SYSENCODING. is latin1

webart999ARM · ‎09-06-2021

It's even worse. Everything crashed, and the output was just one column. Thank you for your response.

webart999ARM · ‎09-06-2021

Dear community, I am here with another unknown problem, I am facing this first time. Hope your wise advice could help me. Here is the part of xlsx file I am importing Here is the import syntax I am using proc import out =aexls datafile='xxxxxxxxxxxxxxxxxxxxxxxx/AESI.xlsx' dbms=xlsx replace; getnames = no; run; Here is the aexls dataset. I have no idea how these characters are appearing. I don't want to remove them with hardcoding. Could you please suggest any turnaround here? And here is the log. Which is fine I think. Thank you all in advance. Kind Regards Artur

webart999ARM · ‎06-04-2021

Thank you @Tom, I will definitely include this kind of solutions in my daily routine work. Kind Regards Artur

webart999ARM · ‎06-04-2021

Thank you @Kurt_Bremser and @Tom for your suggested methods, that's exactly what I want. To be honest I don't understand actually how it works without retain statement. If you could explain that would be great, if no then I will try to investigate myself. My question is pretty simple and I thought it doesn't necessary to provide details like you asked me. Sorry for not being too clear. Thank you again for your prompt answers and efficient solutions. Kind Regards Artur

webart999ARM · ‎06-04-2021

Dear @Tom , Thank you for your suggested method. That's what I want to get. Solution is not quite clear for me, because I used to methods like first., last., retain, for this kind of tasks. Could you please explain in two wards how this works, I mean the part z+first.y ? Thank you in advance. Kind Regards Artur

webart999ARM · ‎06-04-2021

Sorry but I can't explain it in more details. New variable is NOT computed yet. If I knew how it should be computed then I would not post this question here.

webart999ARM · ‎06-04-2021

Dear, @PaigeMiller As you can see from my reply above. Y is a fake variable here, instead of it I have dates in numerical representation. E.g. 01JAN1996 01JAN1996 01JAN1996 02JAN1996 02JAN1996 02JAN1996 03JAN1996 03JAN1996 03JAN1996 I need to derive Z variable, which will have(in this example) 3 different values, 1, 2 and 3 accordingly. Kind Regards Artur

webart999ARM · ‎06-04-2021

Dear @Aku Thank you for your answer. Please consider that Y is a test variable, instead of Y in my real dataset I have dates. I can't apply your solution. I need data driven solution here. Thank you Kind Regards Artur

webart999ARM · ‎06-04-2021

Good afternoon community. I have one small simple question for which I would like to ask you for some efficient solutions. I have the below dataset. I need to derive new variable Z, which will have unique values for each unique Y variable value(marked with red). It seems pretty simple but I am struggling to find any effective solution. I just don't want to use nodupkey/merge back solution which is pretty straightforward. Thank you in advance for your suggestions. Kind Regards Artur

Online Status	Offline
Date Last Visited	‎11-20-2025 03:44 PM

Re: Exclude records with a '-' in the variable value

Re: How do I randomly select controls from within a large administrati...

Re: PROC SURVEYIMPUTE VERIFICATION

Re: How do I randomly select controls from within a large administrati...

Re: How do I randomly select controls from within a large administrati...

Re: PROC SURVEYIMPUTE VERIFICATION

Re: Scoring Mixed Bayesian Model

Re: Is there a way to externally determine the arguments a macro is ex...

Re: Is there a way to externally determine the arguments a macro is ex...

Re: Is there a way to externally determine the arguments a macro is ex...

Re: Unreadable X-AXIS of Spaghetti Plot

Re: By group summary of distributed values in the variable

Re: By group summary of distributed values in the variable

Re: How to skip data step processing (output if the condition met)

Re: Reference to a numeric variable name

Re: PROC SURVEYIMPUTE VERIFICATION

Re: How do I randomly select controls from within a large administrati...

Re: Scoring Mixed Bayesian Model

Re: PROC SURVEYIMPUTE VERIFICATION

Re: Competing risk with time dependent covariates

Re: Reference to a numeric variable name

Re: Reference to a numeric variable name

Re: Reference to a numeric variable name

How to reference to a numeric variable name

Re: PROC IMPORT: Unknown characters, Unicode problem maybe

Re: PROC IMPORT: Unknown characters, Unicode problem maybe

Re: PROC IMPORT: Unknown characters, Unicode problem maybe

PROC IMPORT: Unknown characters, Unicode problem maybe

Re: first./last./retain

Re: first./last./retain

Re: first./last./retain

Re: first./last./retain

Re: first./last./retain

Re: first./last./retain

first./last./retain