About smw10

smw10 · ‎03-12-2017

Sorry I'm just getting to this now. Thank you for your answer. I'm still a bit confused on the second question. I thought that the input pointer would advance to the next row regardless of the else input statement. Is there any way you can dumb it down more for me? I did try it without the else input.

smw10 · ‎03-10-2017

I hope you are all having a good day. I am currently studying for my Base SAS Certification and I have two questions. My first question deals with concatenation. Why does the code below give a value of "FA" for job category rather than "FA1"? data jobcat; jobcategory="FA"; joblevel="1"; jobcategory=jobcategory||joblevel; run; For the code below, why do we need "else input"? What exactly is this saying? Name $ 1-14 / Address $ 1-14 / City $ 1-12; if City='New York ' then input @1 State $2.; else input; datalines; Joe Conley 123 Main St. Janesville WI Jane Ngyuen 555 Alpha Ave. New York NY Jennifer Jason 666 Mt. Diablo Eureka CA ; run;

smw10 · ‎03-05-2017

Thank you for the explanation and the article. Just to make sure I understand, when we read a date value as numeric, it represents the number of days between January 1, 1960, and a specified date. Even after formatting it as mmddyy8., date9., or any other date format for that matter, the underlying value is still the number of days between January 1, 1960, and a specified date. The only way to make that specific date have a length of 9 is to convert it to character with a format of date9. Is this correct?

smw10 · ‎03-05-2017

Thank you for your response. I meant to say date rather than date1. Why does it have a length of 8 rather than a length of 9?

smw10 · ‎03-05-2017

I hope all of you are having a good afternoon. After the code below is executed, why is the length of date1 equal to 8 rather than 9? data test; date=input("09MAR2013",date9.); run; For the footnote question, why does the following only create the footnotes "A" and "E"? footnote1 "A"; footnote2 "B"; footnote3 "C"; footnote4 "D"; proc print data=data1; footnote2 "E"; run;

smw10 · ‎03-04-2017

This makes sense. Thank you!

smw10 · ‎03-04-2017

Thank you for showing me the strip function 😄

smw10 · ‎03-04-2017

Art, after playing around with concatenation more, I noticed some strange results. For the following code, the value of concat1 has a lot of spaces between first and second. Upon further inspection, I found that the length of first is 4 and the length of second is 12. Thus, second is the culprit. I added the line "length second 4." before "second=1001" and still the length ends up being 12. The only way I found to fix this is using the "strip" function around second within the concat1 assignment statement. Why does it set the defualt of this numeric as 12? I thought numerics have a default of 8 bytes. Additionally, why can't I change the length with a length statement? data concat2; first="1568"; X=length(first); second=1001; Y=length(second); concat1=first||second; Z=length(concat1); run;

smw10 · ‎03-04-2017

Once again you completely answered my question. Thank you Art!

smw10 · ‎03-04-2017

Good afternoon everyone. I have two questions about the substring function. I'm looking at a Base SAS certification study guide and there are two questions I got wrong. Additionally, this particular study guide does not explain the answers. The first question pertains to the following code: data test1; first="Ipswich, England"; City=substr(first,1,7); City_Country=City!!", "!!"England"; run; Why wouldn't the value for City_Country be "Ipswich, England."? I thought the substr was taking out 7 characters from the first observation which would be Ipswich. However, the value ends up being "Ipswich , England"; notice the space after "Ipswich." My second question pertains to the following code: data test1; first="Ipswich, England"; City_Country=substr(first,1,7)!!", "!!"England"; run; Why wouldn't the length of City_Country be 16? In the previous example, the result of City_Country is "Ipswich , England" which is 16 characters. Shouldn't the value of City_Country be the same in this example. The length ends up being 25 in this example.

smw10 · ‎03-04-2017

I completely understand now. Thanks!

smw10 · ‎03-04-2017

Art, not to be annoying, but I tested it out and removing the output statement resulted in one observation as expected. What was unexpected is that the observation had a value of "5" for quarter. Do you know why it is doing this?

smw10 · ‎03-04-2017

Thank you!!!

smw10 · ‎03-04-2017

Art, this has helped me a lot! Thank you so much for always being an amazing contributor. Now I understand why it is retaining the style value. One last thing, can you explain how it knows to move on to create a second observation? I realize the @ sign after rain makes it stay on the line "delhi 50 45 55 67." However, I don't know how it knows to create a second observation of "Dehli,2,45" without just overwriting the first observation, "dehli,1,50."

smw10 · ‎03-03-2017

Thank you for your answer. I just want to clarify to see if I understand: The @ at the end of "input city :$ @;" means that we are going to stay on the first row of the datalines statement, "delhi 50 45 55 67," after assigning Dehli to the variable city (since, after an input statement, without the @ sign we would skip to the second row of data which in this case there is none). Next, we enter a loop with the first iteration being quarter=1 and rain=45. What I don't understand is how city retains its value across all 4 observations and how, after the first output within the do loop, that it knows to move on and to create a second observation where quarter=2 and rain=55. Sorry if I'm not understanding everything quickly.

Online Status	Offline
Date Last Visited	‎03-22-2017 08:12 PM

Re: Two Questions: One concatenation question and one input question

Two Questions: One concatenation question and one input question

Re: Date length question and footnote question

Re: Date length question and footnote question

Date length question and footnote question

Re: substr function question

Re: substr function question

Re: substr function question

Re: substr function question

substr function question

Re: Column sum using do until loop

Re: Column sum using do until loop

Re: Two Questions: One concatenation question and one input question

Two Questions: One concatenation question and one input question

Re: Date length question and footnote question

Re: Date length question and footnote question

Date length question and footnote question

Re: substr function question

Re: substr function question

Re: substr function question

Re: substr function question

substr function question

Re: @ in the input statement

Re: @ in the input statement

Re: @ in the input statement

Re: @ in the input statement

Re: @ in the input statement