how to edit a dataset using sas studio

[cellurl]

I am following this

link

It says to  do this but I can't find that button. I even searched youtube.

Thanks!

[Reeza]

Are you referring to SAS Studio or Data integration studio? They are different products.

[cellurl]

sas studio.  I just want to modify one-cell like EG allows....

[Reeza]

So you're looking at the DI documentation which is incorrect. I don't believe SAS Studio allows for manual data editing at this point but changing a single value via code is easy enough. TBH, changing data manually is never a good idea so even if they were considering implementing this it's not a good idea to do it.

[cellurl]

thanks Reeza.

[LinusH · Accepted solution]

http://support.sas.com/software/products/sas-studio/faq/data_edit.htm

[lochan]

so what if i wanted to change variable type will SAS Studio allows it. suppose i have a Titanic data set which has 'survived' variable typed as numerical but for Modeling purpose i want it to be Binary categorical variable.

will sas studio automatically marks 

[Reeza]

@lochan Welcome to the SAS forum. 

Your question is about changing a variable type. 

First, please note that typically the usage of the variable is what defines the type, ie categerical variables are included in the CLASS statement, not necessarily the variable type. 

SAS has two variable types, character and numeric. You can apply formats to those variables. 

If you have a numerical variable, and it has only two levels then it will be treated correctly. If you're using the variable in PROC REG it would need to be numeric anyways, so it's unlikely you need to change the type.

Good Luck with your analysis. 

PS. If you search on here, there's been some posts on analyzing the Titanic data in SAS.