Update. Thanks for the clear and free of jargons explanation.   I am not sure if the first Macro in this post contain problems, but columns did not separate. The first Macro also did not work if there are too many columns   For example:   *data set you want to create demo data for; %let dataSetName = WORK.QUERY_FOR_AVERAGE; *number of observations you want to keep; %let obsKeep = 1; ****************************************************** DO NOT CHANGE ANYTHING BELOW THIS LINE ******************************************************; %let source_path = https://gist.githubusercontent.com/statgeek/bcc55940dd825a13b9c8ca40a904cba9/raw/865d2cf18f5150b8e887218dde0fc3951d0ff15b/data2datastep.sas; filename reprex url "&source_path"; %include reprex; filename reprex; option linesize=max; %data2datastep(dsn=&dataSetName, obs=&obsKeep);     produced the following data sample in the log: data WORK.QUERY_FOR_AVERAGE; infile datalines dsd truncover; input File_Ref:$72. _TYPE_:32. _FREQ_:32. avgmarkettop5:32.; label PremiumRank="Rank for Variable Premium"; datalines; Input_100 0 5 14.17 ;;;; When pasting this into SAS Studio for testing, all data were written into the first column:     -------------------- There are short articles about how to write data into data step Jedi SAS Tricks: The DATA to DATA Step Macro - SAS Learning Post   How to create a data step version of your data AKA generate sample dat... - SAS Support Communities Running the snippet gave warning  *data set you want to create demo data for; %let dataSetName = sashelp.Class; *number of observations you want to keep; %let obsKeep = 5; ****************************************************** DO NOT CHANGE ANYTHING BELOW THIS LINE ******************************************************; %let source_path = https://gist.githubusercontent.com/statgeek/bcc55940dd825a13b9c8ca40a904cba9/raw/865d2cf18f5150b8e887218dde0fc3951d0ff15b/data2datastep.sas; filename reprex url "&source_path"; %include reprex; filename reprex; option linesize=max; %data2datastep(dsn=&dataSetName, obs=&obsKeep);   WARNING: Apparent symbolic reference LBLLIST not resolved.       filename tagset url "https://gist.githubusercontent.com/statgeek/7be124b98b37d51e7c002b85b6e9cf72/raw/ec0bc5cf8e1a3386c5cf71d2280b242b7f87dadd/SAS_tagsets_sql_reprex.sas"; %include tagset; ods tagsets.sql file="/folders/myfolders/class.txt"; proc print data=sashelp.class ; run; ods tagsets.sql close;  Running the above gave errors:   ERROR: Physical file does not exist, E:\folders\myfolders\class.txt. ERROR: No body file. TAGSETS.SQL output will not be created.   How to create data steps for forum questions?   If sample data has lots of rows, then how to take a portion?  ... View more