SAS Studio Long Variables

tcg15d0 — Fri, 20 Oct 2017 01:12:32 GMT

I have a data set with a variable named "State" so some of the entries are very long and multiple words like "North Carolina" and I am wondering how I can keep that variable word together.

Also I have a variable "Salary" with a dollar sign and a comma in it and I don't know how to read in that variable in as one numeric variable.

Thank you!

Re: SAS Studio Long Variables

Reeza — Fri, 20 Oct 2017 01:19:41 GMT

Make sure your data is well structured and has a delimiter. In a CSV file, the proper structure is to have the character variables quoted with comma's separating the values. If a field is numeric but has comma's it can be read in if enclosed in quotes.

But...depending on your data there may be other ways. In fact, this sounds like class work and a question that gets asked on here incredibly regularly so if you search I'm sure you'll find the exact answer on here, possibly with your exact data if it's homework.

topic Re: SAS Studio Long Variables in SAS Studio

SAS Studio Long Variables

Re: SAS Studio Long Variables