When asking question on the forum, it's incredibly helpful to provide sample data. Sometimes you can get away with referencing SASHELP datasets, but it's also nice to be able to use your own data, especially if you have a complex structure or just code that will work on your computer.
Mark Jordan has written a SAS macro that will generate a data step version of your data. This post goes through how to use it in SAS. It's untested, but should work with any version of SAS. Note that this currently generates a warning, that I'll look into later, but does not change the results.
This post has been simplified from previous runs. Now, you would modify the first two lines below.
Replace sashelp.class with your data set name.
Replace 5 with the number of observations you want in the demo data set.
Then run the whole program posted below. The data step will be in the log.
*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);
In the log this would generate the following code that you can easily include in your posts. Make sure to use the {i} or running-man icon to conserve formatting. This is IMPORTANT to prevent the browser from modifying your code and turning colon parenthesis ( : ) into smiley faces :).
data WORK.CLASS(label='Student Data');
infile datalines dsd truncover;
input Name:$8. Sex:$1. Age:32. Height:32. Weight:32.;
datalines;
Alfred M 14 69 112.5
Alice F 13 56.5 84
Barbara F 13 65.3 98
Carol F 14 62.8 102.5
Henry M 14 63.5 102.5
;;;;
I would highly recommend you run this once first to test if it works as shown.
If it does, then try and do it again with your own data.
EDIT:
It's been shown that this doesn't always produce the correct results, unfortunately.
Here's another method from the comments (thanks to @rogerjdeangelis, with the fix indicated from @ChrisNZ
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;
Note that I've modified this slightly to create a txt file, instead of a .sql file, so the user can easily open it. You can open it and verify and then paste it into your question.
