As the first step in the decommissioning of sasCommunity.org the site has been converted to read-only mode.


Here are some tips for How to share your SAS knowledge with your professional network.


User:Nirmalsas2302

From sasCommunity
Jump to: navigation, search

The bellow Script will help to import an Excel file created with the same firstname but different dates. For example i have 3 files scope_20131101, scope_20131102,scope_20131103. This (20131103) is acutally a date in yyyymmdd format. Below is the code for that.

LIBNAME Scope '/mycomputer/desktop/versionone/test/data;

%macro yyyymmdd(DATEVAR) ; COMPRESS(PUT(&DATEVAR,YYMMDD10.),'-'); %mend ;

data test; date=date()-5; date1=%yyyymmdd(date); CALL SYMPUT("date1",date1); F1 ="Scope_" ||date1 ||" "; CALL SYMPUT("F1",F1); run;

%LET DT1 = &F1;

PROC IMPORT OUT= TAH1 FILE = "/prod/user2/ITStrategy/V1/Data/&DT1" DBMS=xlsx REPLACE; SHEET="Scope"; GETNAMES = YES; RUN;