Here is my code:     libname file0 'x/y/z';   data _null_; yest = today() -1; a = 'hamming_'; call symput('inventions',put("file0.",$6.)||put(a,$8.)||put(yest,yymmddn8.)); options symbolgen; run;   data temp0; set &inventions (obs=1); run;   proc print data=temp0; run;   symbolgen returns 'file0.hamming_20180417' and i get an error in the set statement saying FILE 'file0.hamming_20180417.DATA' does not exist.   How can I remove this '.DATA'?   Thanks, Jon   ... View more

Hi,   I'm having trouble keeping a date format when concatenating to a char.   i want to attach a char variable to yesterday's date, for example:   abc_20180416.   here is the code I made:   data temp0; yest =today() -1; format yest yymmddn8.; var1='abc_'; var2= cat(var1,yest); run; proc print data=temp0 (keep=yest var2); run;   The result is:   yest                     var2 20180416            abc_21290;   I've tried a few different things, but can't seem to pin down how to get var2= abc_20180416.     Any tips out there?   Thanks         ... View more

    The high level view of my program is that i have to query a database and i need to determine if observations in a particular variable are formatted correctly.  Here is my filtering criteria:   if position 4 is not "_" if any position includes "." if position 4-8 not numeric if last 4 chars not match variable q   then put this observation in a new variable called Q    It seems to me that these are all possible, but part of my problem is that i don't know how to look up in the documentation on how to go about this.  I'm not necessarily looking for someone to give me the answer here, but offer how I can go about finding out how to do this on my own...perhaps give me one example and let me go off on my own.    Any help here is greatly appreciated.   Thank you. ... View more

What i want to do is get a value from a variable in multiple pdb's.   code: -- libname in0 '/aaa/bbb/ccc' ; data temp0; set in0.z in0.y in0.x in0.w in0.v; keep mmm; run; proc print data=temp0 (obs=5); run; --   so i want to see the value of mmm from z,y,x,w,v.  Im trying to do this as efficently as possible.  Any pointers on how to do with without multiple libname statements?  thank you. ... View more

Hello,   I want to see the variables in a pdb.  here's my code: libname pdb '/a/b/c/d/e/2017/0501'; proc contents data=pdb; proc print data=pdb;     what am i doing wrong here?  please help.   ... View more