Hi,
I was wondering if it is possible to have a row zero, that will not be counted in an analyis, but would contain, important information.
Best,
I would ask what you are doing that this is causin issues but the OBS number is not in the data set. So add a variable with the value you want:
Data work.one4;
set work.one3;
Obs = _n_ -1;
run;
Well, the information I am storing tells the total amount of row entries divided by 3 for each row, in order to find a solution for the total amount of moves needed for a puzzel. In this case it will not be a label, however it will indicate how far you are from the solution.
The number of observations in a dataset can either be read from sashelp.vtable (dictionary.tables in PROC SQL), or you can use the nobs= option in the set statement to create a data step variable that holds that value.
Wouldn't that be a column? Please post sample input and desire output.
Here is my output. To rephrase my question: Is there a way to make an observation 0. I want obersevation 1 to be 0.
I would ask what you are doing that this is causin issues but the OBS number is not in the data set. So add a variable with the value you want:
Data work.one4;
set work.one3;
Obs = _n_ -1;
run;
There.is.no.observation.zero.in.a.SAS.dataset. Never.
You only can do that:
data want;
set have;
retain counter;
if _n_ = 1
then do;
counter = 1;
output;
counter = 0;
* set values for your "0" observation;
output;
counter = 1;
end;
else do;
counter + 1;
output;
end;
run;
proc sort data=want;
by counter;
run;
This creates a virtual obs 0, but be aware that any sort other than by counter will move that "zero obs" to another place.
Check WEIGHT statement. if you are using proc freq , check ZEROS option of WEIGHT.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.