I recently posted a question on how to strip leading zeros so that I could build up a FTP put statement. It worked great but the first put statement referenced a file that doesn't exist. I was wondering if there is a way to grab a directory and put it into a data set? Once this is accomplished I can then join the valid files in the directory. Nick ... View more

I'm using a data step to build up multiple ftp put statements and I need to remove all leading zeros. The person ID is the value with the leading zeros. I'm also trying to figure how to put the quit keyword after the last occurence. I thought last. would work but it isn't coming out correctly. Below is the data step. data _null_; set work.display_data; by person_id_nb; file max_pics; line1 = 'cd incoming'; line2 = 'put \\location\of\thepics' ||trim(person_id_nb) || '.jpg'; Line3 = 'quit'; if _N_ = 1 then put line1; put line2; if _N_ = lastobs then put line3; run; ... View more

I run some weekly data integrity checks that I'm moving to SAS. I want to put the output in a spreadsheet and email it to the contact. Is there a way that if the report returns 0 records, no spreadsheet and no email is generated? I was thinking about first. Thanks ... View more

I'm trying to send a file to a SFTP site and not having any luck. I have installed PUTTY based on some notes I found online. Here is the code I'm using: filename outfile sftp 'd:/temp/test.txt' host="server" user="user"; data _null_; file outfile; do i=1 to 10; put i=; end; run; ... View more

I'm trying to incorporate a retain statement in a data step to display the data a certain way. Below is what the output looks like now: 0715954 --person_id_nb CHE-120 TR 8:00:00 AM - 9:50:00 AM ********** 0715954 CHE-126 R 10:00:00 AM - 12:15:00 PM ********** Need it to look like this: 0715954 CHE-120 TR 8:00:00 AM - 9:50:00 AM CHE-126 R 10:00:00 AM - 12:15:00 PM ********** Here is the data step that I'm using: Data _null_; set work.stud_courses; *FILE MAX_File; retain person_id_nb; format Start_tm timeampm.; format End_tm timeampm.; Line1=person_id_nb; Line2=trim(course_nm) || ' ' || trim(Dayofweek) || '' || put(Start_tm,timeampm.) || ' - ' || put (End_tm,timeampm.); header_record='**********'; put Line1; put Line2; put header_record; run; ... View more