This isn't necessarily a coding issue. If you Google your error you will see this: Can you use FTP successfully from a command line using the FTP command?   Are you using a SAS server or not? If you are then the most likely cause is a firewall rule blocking your connection. You will need to talk to your IT support to confirm this.   Your FILENAME statement also includes a double quote which shouldn't be there:    ... View more

SAS Usage Note 24275 should answer your question.  ... View more

With a data step: data have (drop=_:); length subject 8 time_pt 4 ; format time_pt yymmddd10.; array var {3} 8.; do subject = 1 to 3; do _rows = 1 to 100; time_pt = today()-ceil(ranuni(1)*400); do _i = 1 to dim(var); var[_i]=ceil(ranuni(1)*50); end; output; end; end; run; data want; set have; by subject; retain peak1-peak3 date1-date3; if first.subject then call missing(of peak:,of date:); array peaks {3} peak:; array dates {3} date:; array vars {3} var:; format date: yymmddd10.; do _i = 1 to 3; if vars{_i} > peaks{_i} then do; peaks{_i} = vars{_i}; dates{_i} = time_pt; end; end; if last.subject; drop time_pt var: _:; run; ... View more

@Reeza wrote: I'm guessing someone set it up at some point as a permanent library. Have you tried deleting the permanent library first and then seeing if it is recreated once you delete it? I guess that attempt would fail. As long as SAS uses the directory as its Current Working Directory, you can't remove it. Both on Windows and UNIX.. ... View more

Ok just an update on what I did. I used proc freq and did a 2x2 to output the flags and reasons . I used data step to concatenate. ... View more

If you have problems moving datasets between computers, trying using PROC CPORT to create a transport file.  If all else fails, dump the dataset contents to a flat file then reimport it. ... View more

@saslove wrote: I have an ID list    %let study1_ids="ab","xy","we","st","ut","po","vc","gh"; (study 1)   Now, for another study (let's say study 2) with a different set of IDS, I need to go over each ID list (which is entirely different from the above list- but for each id, I need to assign each id above.   For ex abc (study 2) = ab (study 1) d3e (study 2) = xy (study 1)   Thoughts?  Question the need for quotes and commas in that study1_ids.   This makes no sense in SAS: what are ABC, AB, d3e or xy. If they are values of a variable then what is the name of the variable? abc (study 2) = ab (study 1) d3e (study 2) = xy (study 1) Provide a few concrete examples with values from both "lists" and what the result should be.   This sort of sounds like you probably should have the values involved in data sets and then SQL to match things. ... View more

  In this statement call symputx ("cohortct&num.",COHORTCT); COHORTCT is a variable that does not exist in your proc freq output dataset named COHORTCT       data adae_subs ; set sashelp.class(rename=(weight=cohort)); run; proc freq data=adae_subs nlevels noprint; tables cohort/out=cohortct(rename=(count=cohortct)) outcum; run; ... View more