Please review the post a question guidance, it is essential in almost every instance to provide data in the form of a runnable program.  We can't see your computer, and "it does not work" does not tell us anything.  This code for instance does work perfectly well: data have; x="22Sep17:11:30:22"dt; output; x="22Sep17:11:32:11"dt; output; run; data sample1; set have; where x="22Sep17:11:30:22"dt; run; See: https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712 About getting your data usable. ... View more

Two ways: proc transpose data=have out=want prefix=col; by id; var marks; run; data want; set want; length result $200; result=catx(',',of col:); run; Or: data want; length result $200; set have; retain result; by id; result=ifc(first.id,marks,catx(',',result,marks)); if last.id then output; run; Note, unless this is for a repeat, its never a good idea to keep multiple data items in one variable!! ... View more

Sorry, going to repeat, Python and SAS are two different programming languages.  If you have code in one, there is no automatic convert from one to the other, any more than there is in any other language.  You would need to code the logic from one using the syntax and structures of the other.   As for your other point, there are similar things like macro in other languages such as Python.  However its not completely the same.  Macro is simply a text generator.  If the text generated is valid SAS code, then that passes through the SAS compiler and is processed.  In Python there are packages for text generation - such as building generic code generated HTML pages, but something which exactly replicates what SAS macro does then no, not as far as I am aware.   ... View more

SAS and Python are totally different programming languages???   You can pass parameters into a SAS code, but would need to know a lot more information about what is driving one or the other, how its running etc. ... View more

Sorry, you have totally lost me now.  What is it you want to do, show examples - clear examples.  The code I provided creates a series of rename operating system calls to rename a file from one filename to another.  Are you saying now that you want to alter text within a file?  If so then that is a totally different setup, you would read the file in and then write it out again: data _null_; infile "....txt"; file "....txt"; length buff $2000; input buff $; if index(buff,"filename") then do; /* do you text change here */ end; put buff; run; With this you read the file one line at a time then write that back out, the if takes effect on the line read in. ... View more

I would forget the macro.  When a program is run in batch (and its been a while since I did this as its all network or virtual based now), a log file, and list file is placed in the location of the main programs run location, so if you have: c:/test/myprogram.sas And batch submit this, SAS will by default create: c:/test/myprogram.log c:/test/myprogram.lst   Therefore you can read the plain text file with the .log extension to get the log.  This is all the macro is doing, by taking the program name from the system macro variables: put '%let PgmName='"%scan(%scan(&SYSPROCESSNAME,2,' '),1,'.');"; And then using this in a filename for the datastep to read from: filenamerunlog pipe "cat &PgmName..log";  You could do this simply by: data want; fname=catx('.',scan(scan("&sysprocessname.,2,' '),1,'.'),'.log'); infile fname; length buff $2000; input buff $; run; Then you will have the complete log read into want dataset, and can process it as you wish. ... View more