It can be done in a few different ways.  I think this one would be the easiest to understand. It uses CALL Execute to write code the uses the PROC DATASETS procedure to do the rename.    data work.have; x = 1; y = 'Y'; output; run; data renames; oldname = "X"; NewName = "X_NEW"; OUTPUT; oldname = "Y"; NewName = "Y_NEW"; OUTPUT; run; data _null_; set renames end= finished; if _n_ = 1 then do; call execute("proc datasets library=work nolist;"); call execute(" modify have;"); end; call execute(" rename " || oldname || " = " || NewName || ";"); if finished then do; call execute("quit;"); end; run; ... View more

VBAR wants the data structured differently.  The stack value needs to be a variable.  Something like this.   data have; infile cards dsd; input weekday $ var1 var2; format datetime1 datetime2 datetime20.; cards; Monday,23,12 Tuesday,21,4 Wednesday,4,5 Thursday,5,29 Friday,8,9 ; run; data want; set have; actual = var1; cat="cat1"; output; actual = var2; cat="cat2"; output; run; proc sgplot data=want; title 'Actual Sales by Day'; vbar weekday / response=actual group=cat stat=sum; xaxis display=(nolabel); yaxis grid label='Sales'; run; ... View more

It looks like you are confusing the macro parameter name with its default name. I think you want something like this, although this is difficult to test outside of your environment.   %MACRO IMPORT_TXT(FILENAME=ID,OUTFILENAME=ID); proc import datafile="C:\Users\bmrg2\Box Sync\Mizzou 2019\Research\RBI Project\Task 8_Back-casting\NBI Data from Fhwa site\ID_All years\&FILENAME..txt" dbms=dlm out=&OUTFILENAME replace; delimiter=''; run; %MEND; ... View more

I was right about the input not being closed.  This works as well.   data all; input id $ @@; url=compress("https://query1.finance.yahoo.com/v7/finance/download/"||id|| "?period1="||dhms("1jan1901"d,0,0,0)-315619200|| '&period2='||dhms("31dec2100"d,23,59,59)-315619200); infile dummy url filevar=url firstobs=2 dsd truncover end=last; do until(last); input @; if index(_infile_,"null")=0 then do; input date yymmdd10. +1 open hi lo close adj vol; output; end; else input; end; cards; ^irx ^gspc ; ... View more

I wasn't sure if different IDs should automatically be assigned different NEW_IDs.  Your example NEW_IDs appear to work one way for some records and the other for others.  Both approaches are done in the following examples.   proc sort data=have; by ID Datetime1 Datetime2; run; data want; set have; by ID Datetime1 Datetime2; retain NEW_ID2 0; sep1 = intck('hour',lag(Datetime1),Datetime1); sep2 = intck('hour',lag(Datetime2),Datetime2); if first.ID then NEW_ID2 = rand('integer', 100, 999); else if sep1 > 1 and sep2 > 1 then NEW_ID2 = rand('integer', 100, 999); run; proc sort data=have; by Datetime1 Datetime2; run; data want2; set have; by Datetime1 Datetime2; retain NEW_ID2 0; sep1 = intck('hour',lag(Datetime1),Datetime1); sep2 = intck('hour',lag(Datetime2),Datetime2); if _n_ = 1 then NEW_ID2 = rand('integer', 100, 999); else if sep1 > 1 and sep2 > 1 then NEW_ID2 = rand('integer', 100, 999); run; ... View more