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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.