I am having a lot of trouble for something that should be easy. I've used proc import to covert a .txt file to a .sas7bdat file and I am interested in one variable named date.   So the import coverts it to a BEST12. format and if I try to convert this year and quarter data which looks like   Have (BEST 12.)      Want (YYQC6.) 200001                     2000:1 200002                     2000:2 200003                     2000:3 200004                     2000:4 200101                     2001:1 ...   The problem is that if I convert it to YYQC6. I get those dates based on the time from 1960, not the actual year and quarter I want. I could use substr and cats, but that doesn't give me the right format even though it looks like what I want. Any help on how to proceed?   Here is some starting code: data have; input date:BEST12.; format date BEST12.; datalines; 200001 200002 200003 200004 200101 ; run; proc contents data=have; run; ... View more

So basically I want to use the prior and prior prior values as my features for my label which is the same value, y. I've changed the data into what I think is easiest to understand. I done something like this in Python, but not sure how to in SAS. Any code on how to change the have dataset into the want dataset would be much appreciated!   data have; infile datalines delimiter=','; input id $ y year 8.; datalines; 1,20,2016 1,10,2015 1,5,2014 2,60,2016 2,30,2015 2,15,2014 3,36,2016 3,18,2015 3,9,2014 ;   data want; infile datalines delimiter=','; input id $ y year lag_1_y lag_2_y 8.; datalines; 1,20,2016,10,5 1,10,2015,5,. 1,5,2015,.,. 2,60,2016,30,15 2,30,2015,15,. 2,15,2014,.,. 3,36,2016,18,9 3,18,2015,9,. 3,9,2014,.,. ; ... View more

I was able to succesfully count the number of files in the New Folder in unix shell and output it to My SAS files folder   cd H:\My_SAS_Files\New_Folder count='ls | wc -w' { echo -n 'Number of Files is ' & eval "$count"; } >> H:\My_SAS_Files\output   To Check Number of Files: cd .. tail output   I need to execute this in SAS to encoperate a loop and some macros, but I'm not sure how to get the X comamnd to work. Any ideas?   X "cd H:\My_SAS_Files\New_Folder"; X "count='ls | wc -w'"; X "{ echo -n 'Number of Files is ' & eval "$count"; } >> H:\My_SAS_Files\output"; ... View more

I know how to supress the notes in SAS by options nonotes;  I am wondering how I can supress specific notes that have a certin text strings because I have to read though a huge log, but still want to see unexpected notes. For example, omit: WARNING: The variable ORDER in the DROP, KEEP, or RENAME list has never been referenced.   ... View more