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.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
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.