topic Re: how to edit a dataset using sas studio in SAS Studio

how to edit a dataset using sas studio

cellurl — Mon, 14 Aug 2017 20:46:03 GMT

I am following this

link

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

Thanks!

Re: how to edit a dataset using sas studio

Reeza — Mon, 14 Aug 2017 20:49:30 GMT

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

Re: how to edit a dataset using sas studio

cellurl — Mon, 14 Aug 2017 21:11:29 GMT

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

Re: how to edit a dataset using sas studio

Reeza — Mon, 14 Aug 2017 21:26:45 GMT

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.

Re: how to edit a dataset using sas studio

LinusH — Tue, 15 Aug 2017 11:53:42 GMT

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

Re: how to edit a dataset using sas studio

cellurl — Tue, 15 Aug 2017 13:49:15 GMT

thanks Reeza.

Re: how to edit a dataset using sas studio

lochan — Thu, 26 Oct 2017 16:31:02 GMT

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

Re: how to edit a dataset using sas studio

Reeza — Thu, 26 Oct 2017 16:41:51 GMT

@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.