topic Re: Add a column to sas file in SAS Programming

Add a column to sas file

yael — Thu, 08 Mar 2018 15:36:55 GMT

Hello

I have SAV file that includes 124 columns and 4000 lines.

I do not know why I can not import an excel file to SAS (working via the university), so now I am trying to do other action in order to add data.

I want to add an additional column (new variable) with 4000 lines to the existing SAV file. How do you suggest to do it (I check in this community and find many options like SQL but I am not sure about it).

Thanks for any clue

Hedva

Re: Add a column to sas file

RW9 — Thu, 08 Mar 2018 15:44:22 GMT

What is a SAV file?

"I do not know why I can not import an excel file to SAS (working via the university)" - we don't know either, perhaps if you told us what you were doing, what errors you get etc. As UE runs on a virtual linux image which Office is not, then yes SAS cannot process Excel files. You can of course save the Excel file as CSV and then import that into SAS (the problem here lies with Office which is proprietary Windows only software).

As for adding another column, you can do this in any number of ways through datastep (this is the main language) or sql sub component. For example here I add a column to the dataset have outputting to a new dataset want:

data want;
  set have;
  new_var=1 + 2;
run;

new_var will default to numeric length 8 as I did not specify any format or type. You need to provide more information on your specifics for us to help.

Re: Add a column to sas file

Reeza — Thu, 08 Mar 2018 16:35:44 GMT

SAS UE can deal with Excel files and SPSS files without issues.

How are you importing your data? If you're not sure of the code and such and are more familiar with SPSS point and click interface, I recommend using the GUI tasks instead of trying to code.

Re: Add a column to sas file

SuryaKiran — Thu, 08 Mar 2018 16:50:19 GMT

Also note that upgrading the VirtualBox from 5.2.6 to 5.2.8 have issues with shared folder. In case if you have problem accessing the local files in SAS UE then downgrade the VirtualBox to 5.2.6. You can find the previous version of Virtual Box here VirtualBox-5.2.6-120293-Win.exe