Hi Jing, i guessed it. You must install 64 bit office. But please know that when you install 64 bit office then sas 4.0 will work fine but same problem may occure with sas 9.3 (couse of the 32 bit) ... View more

Did you tried txt import wizard. ... View more

You can use compress with 'kd' argument: Sample; string='StudySAS Blog! 17752. ' ; string11=compress(string,'','kd') ; Result: string11=17752 ... View more

Dear jzhu3, if its possible, could you please check office 2016 youre usins is 32 bit or 64 bit. Because i got many problem with this issue and all of them is related with office version. Thanks. ... View more

I think sas 9.4 64 bit not compitable with office 32 bit. Please try upgrade office 64 bit. ... View more

1.) Please write full path. Like Libname mylib "D:\mydata"; 2.) If account_id is string it must be like "00001" 3.) Are you working on Sas base or sas EG, If sas Eg server maybe you have an authorization problem ... View more

I didnt try but maybe give idea. "set AB:;" line is critical. Union all datasets which name begin "AB_" data AB_all_data; tday=substr(put(today(),date9.),1,2); If tday="01" then do; Set AB_:; end; run; %let month=substr(put(today(),Ddmmyy10.),4,2); %let year=substr(put(today(),Ddmmyy10.),7,4); Data _&month.&year; Set AB_all_data; Run; proc sql; drop table AB_:; quit; ... View more

Would you like to dublicate variables ? Could you explain what is the main aim please ? ... View more

In sas EG you can write sas codes, from menu bar select "program "and proper section. I couldnt remember now. ... View more

Second solution ; proc sql noprint; select * into : first_variable1 from work.tablehave; quit; Data tablewant; X=&first_value1; Run; ... View more

For examle you have an excel file has 2 colums "a and b", and excel has 100 rows. You imported this sheet into sas as "tablehave". When you run this code it gives you only first row (obs=1). And "drop b" command deletes column b.finally you got only A1 cell as of excel mentallity. Data tablewant: Set tablehave (obs=1); Sample=substr(a,1, 3); Drop b; Run; ... View more