About GN0001

GN0001 · ‎05-13-2021

Hello kawakami, Thanks for the response! This outputs everything less than 1000. I need only one observation: only the first observation which is less than 1000. Please let me know if this makes sense. Respectfully, Blue Blue

GN0001 · ‎05-12-2021

Hello team, I have a code and I want to write a code that finds the max amount before the last amount in do until loop? I can eye ball and say what it is. How can I do this by writing code? Thanks, Blue Blue data salyr; input salary year; cards; 134 2019 run; data increaseit; set salyr; do until (salary gt 1000); salary = salary + salary * 0.06; year = year + 1; output; end; Run;

GN0001 · ‎05-10-2021

Hello team, This is my code, it runs successfully; it gives me only a line. How to view the increase year by year: data salyr; input salary year; cards; 134 2019 run; data increaseit; set salyr; do until (salary gt 1000); salary = salary + salary * 0.06; year = year + 1; end; output; Run; Thanks, Blue Blue

GN0001 · ‎05-10-2021

Hello team, How to get the line numbers in SAS Enterprise editor? Regards, Blue Blue

GN0001 · ‎05-10-2021

Hello all, What is sashelp.class? What do we use it for? Respectfully, Blue Blue

GN0001 · ‎05-09-2021

Hello all, I wrote a loop that goes through variables to replace dot (a missing value) with zero; Now I want to add another loop to go through observations as well. This is my code and your help is greatly appreciated. Blue Blue Data simpleData; Input Var1 Var2 Var4 Var5 Var6 Var7 Var8 ; cards; 5 7 3 6 5 8 3 4 7 3 6 5 8 3 3 6 3 3 5 8 3 5 4 3 . 3 8 3 5 4 3 3 3 8 3 5 . 3 3 3 8 3 5 7 3 3 3 8 1 5 7 3 3 3 8 0 run; data mathtop; set simpleData; varResult = var1 * var2; Array varArr(7) Var1 Var2 Var4 Var5 Var6 Var7 Var8; Do i = 1 to 7; if varArr(i)=. Then varArr(i)=0; var9 = var4 + var8; end; Run;

GN0001 · ‎05-07-2021

Thanks for all this. I have to think about each piece to digest it. I think it would be easier to understand. I didn't write the code and I was trying to understand it to be able to use it later. Well, I understood Data _null_; doesn't do anything, it only writes on the log. Blue Blue

GN0001 · ‎05-07-2021

The documentation was not simple to understand. I will look into it more. Respectfully, Blue Blue

GN0001 · ‎05-07-2021

Hello KurtBremser, I have no idea where you are referring to. On documentation, I can see maxims and that's about it. One thing that is interesting, on my phone, I can see links to topics that I am excited for. I can't see it on my computer. Thanks for all, Blue Blue

GN0001 · ‎05-07-2021

Thanks for the response. Is its result used in another statement? Is it save in memory for further use? Regards, Blue Blue

GN0001 · ‎05-07-2021

Hello, What do you mean by saying: "Since there is no NOBOS= option, this will simply fail with a syntax ERROR" Respectfully, Blue Blue

GN0001 · ‎05-07-2021

Data sales; Input dept: $10. Jan feb mar; Datlines; Shoes 4344 355 266 Houseware 33 44 55 ; Data _null_; Set sales; qtrTot = jan + feb + mar; put ‘total quarterly sales: ‘ qtrtot dollar12.: Run;

GN0001 · ‎05-07-2021

%end? Or %mend? Thanks, blue blue

GN0001 · ‎05-06-2021

That is why I asked what it does. Thanks, Blue Blue

GN0001 · ‎05-06-2021

1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 72 73 %macro Mylist(); 74 *Create Loop; 75 76 %let totalofRecords =0; 77 78 Data mydata; 79 set readfromMyolddata nobs=nobs; 80 Run; 81 82 data _null_ ; 83 set mydata nobs=nobs; 84 call symput('totalofRecords', compress(nobs)); 85 put nobs; 86 stop; 87 run; 88 89 %do; 90 %i = 1 %to &totalofRecords.; ERROR: Improper use of macro reserved word TO. 91 92 data _null_; 93 set mydata ; 94 if _n_ = &i; 95 call symput ('abc_file', compress (abc_file)); 96 run; 97 end; 98 %mend; ERROR: There were 1 unclosed %DO statements. The macro MYLIST will not be compiled. ERROR: A dummy macro will be compiled. 99 100 ; 101 102 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 114 Regards, blue 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

call symputx vs. symput

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: To write a code that finds the max amount before the last amount i...

To write a code that finds the max amount before the last amount in do...

How to view the result of a loop in SAS?

How to get the line numbers in SAS Enterprise editor?

What is sashelp.class?

To treat missing values with zeros

Re: nobs and symput and put and stop?

Re: nobs and symput and put and stop?

Re: What does this code do? What is purpose of data _null_;? Can we th...

Re: What does Data _null_ ; do?

Re: nobs and symput and put and stop?

What does Data _null_ ; do?

Re: What does this code do? What is purpose of data _null_;? Can we th...

Re: What does this code do? What is purpose of data _null_;? Can we th...

Re: What does this code do? What is purpose of data _null_;? Can we th...