For starts, yes my variable is misspelled...   Also, I am extremely novice at SAS and SQL so I'm not sure what I'm doing wrong.   Can someone enlighten me what I'm doing wrong? I thought that making the input with quotation marks would make it a character type; or is there something like string(n) for SAS?   proc sql; alter table collegepayback add Classifciation varchar(10); run;   proc sql; update collegepayback SET Classifciation = CASE When m_major = 'Aerospace Engineering' or m_major = 'Biology' or m_major = 'Chemical Engineering' or m_major = 'Chemistry' or m_major = 'Computer Engineering' or m_major = 'Computer Science' or m_major = 'Geography' or m_major = 'Geology' or m_major = 'Industrial Engineering' or m_major = 'Information Technology' or m_major = 'Math' or m_major = 'Mechanical Engineering' or m_major = 'Physics' THEN Classifciation = 'STEM' ELSE Classifciation = 'nonSTEM' END; run; ... View more

So my goal is to take two data sets and make an output table in which I take the difference between two fields while also keeping one of the fields from both data sets that correspond to their records.   E.g., import(major, median, ...) and import1(name, region, strtMedian, ...)   data Diff_Acct_Cali;    set work.accounting_major, work.cali_region;    difference = (accounting_major.median - cali_region.startMedian);    keep accounting_major.major cali_region.name difference; run;   What I'm trying to do is take a record from work.accounting_major and work.cali_region particularly median and startMedian respectively. Save the difference into a new record that has the field major from accounting_major and name from cali_region.   All that gets outputted is a table with a column labeled difference with nothing in it. What am I doing wrong? ... View more

Sorry if this is rant-ish   Anyway, I am trying to do a simple summary statistics on my data set. However, all of the variables are of type char when I need some of them to be numeric. So I am trying to change their type but for the life of me cannot figure out how. Furthermore, I am also overthinking it to some extent as the variable names in the table contain white spaces and the values are of the form: $65,000.00 -- with that said, to me at least I think I need to remove the dollar sign, the comma, and the decimal point and its following digits.   In the example to change types, all the data is being created in the proc and not pulled in from a table. I tried something like the following:   data work.import1;             set work.import1;                But I do not know how to reference the variables in work.import1 because of the whitespace. ... View more

Sorry if this is the wrong forum for this type of question   Recently I've been getting an error when trying to upload data sets. It started when I tried uploading an extremely large set e.g. 150k by 200 of rows and columns.    The first thing I did(after the error) was to check the file size and it was roughly 34mb then I realized SAS studio has a 10mb upload capacity if I recall. It was odd that it uploaded but would cause an error when trying to run it.   So the next thing I did was use a much smaller sample size like 100 x 100 and the file was ~5kb. However after uploading the file then hitting run I get the same error: " Errors detected in submitted DATA step. Examine log. 102 rows created in WORK.IMPORT1 from REFFILE. " Furthermore, to make matters more confusing if I change from the proc import for the GETNAMES and set it to No and rerun the file it works?! Any help would be greatly appreciated. ... View more