I'm in SAS 9.4. The log implies this code ran with no issues. But where is my table saved?   filename data temp; proc http url = "https://lectures.mhhe.com/connect/richardson_daa1e_1260375196/data_files/Chapter_2/Lab_2_5_CollegeScorecard_RawData.txt" out=data; run; quit; ... View more

 I ran some code in SAS 9.4 where I did not want to see all the errors so I turned the log off. Then I turned the log back on.   proc printto log=junk; run;                              *turn log off;      data fees1 ; set fees;           sic2=put(sich,4.);           sic2=substr(sic2,1,find(sic2,'.')+2);           put sich= / sic2=;      run; proc printto ; run;                                           *turn log back on;   However, when I run my next line of code (shown below just to show it's simple), I can see it creates a new dataset, but the log doesn't respond. I.e., any code I run after the code above works, but the log doesn't respond.   data delete; set fees; run;                          *the dataset delete gets created, but the log doesn't respond; ... View more

I'm using zip codes, some of which start with a zero. I used the CATX, CATT, CATS, and CAT functions to try to concatenate a 0 then the remaining four digits to fix my current variable where the leading zero is missing. None of these worked. I'm left with a new variable with no leading zero for these. It's a character variable. (I need to fix this problem first because another issue I'll fix after this is dealing with xxxxx-xxxx zip codes. I don't think using LENGTH will fix my 4-digit issue since I'll need to chop off the correct side of my 9-digit ones later.)   data new; set old; if length_zip=4 and state_code='CT' then zipcode=catt('0',zip); if length_zip=4 and state_code='ME' then zipcode=catt('0',zip); if length_zip=4 and state_code='MA' then zipcode=catt('0',zip); if length_zip=4 and state_code='MA' then zipcode=catt('0',zip); if length_zip=4 and state_code='NH' then zipcode=catt('0',zip); if length_zip=4 and state_code='NJ' then zipcode=catt('0',zip); if length_zip=4 and state_code='RI' then zipcode=catt('0',zip); if length_zip=4 and state_code='VT' then zipcode=catt('0',zip); else zipcode=zip; run; ... View more

I have data that looks like this: Obs    Date    CompanyID 1         7/15/15        1 2         12/31/01      2 3         12/31/02      2 4         3/31/05        3 5         5/15/05        3   What I need to do is keep the observations 1-4 and drop (or at least flag) observation 5. Observation 2 & 3 are not duplicates because there is a year in between those dates. Observations 4 and 5 will be treated as duplicates because they fall less than 60 days apart.  Is the retain function appropriate? ... View more