Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Importing multiple files into SAS
You can use the infile statement to specify wildcards within the filename statement. I.e. Data Out ; Infile "c:\users\amit\test*.csv" ; Input A : $4. B C D ; Run ; This would read in test1.csv test2.csv etc- Amitok
- Post #3
- Forum: SAS Institute, Inc. solutions
-
Run a subset of code based on weekday
Using a SAS Macro: %MACRO Depend ; %If %SYSFUNC(WEEKDAY(%SYSFUNC(TODAY()))) = 1 %then %do; <CODE HERE> %END ; %MEND Depend ; You could also use a call execute: Data _NULL_ ; IF WEEKDAY(TODAY())=1 THEN CALL EXECUTE ("<Code within quotes here>") ; RUN;- Amitok
- Post #5
- Forum: SAS Institute, Inc. solutions
-
Moving multiple rows to single row
Proc Sort Data=NEW ; By TiliA ; Run; Data New ; Retain TiliB ; Set Old ; By TiliA ; If First.TiliA Then DO; TiliB = "" ; TiliB = TiliB!!" "!!TiliA ; END; IF Last.TiliA Then Output ; RUN;- Amitok
- Post #5
- Forum: SAS Institute, Inc. solutions
