Help using Base SAS procedures

proc import and data management

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 6
Accepted Solution

proc import and data management

I am trying to read an SPSS dataset into SAS using proc import and subsequently modify a few of the variables. I am relatively new to SAS and know that data modifying belongs in a data step, but I cannot seem to get the order right. If I put the data step after proc import, I lose the dataset that I imported, but if I try to put the proc import statement within a data step (like below), I get an error in the log that says that the "if" statement is used out of proper order. Please advise. Thank you!

data nida.ppi;

     proc import datafile = "SPSS dataset.sav" data = nida.ppi replace;

     if inform_r < 5 then inform = "Bio Parent";

     proc contents short;

run;


Accepted Solutions
Solution
‎02-17-2012 10:08 AM
PROC Star
Posts: 7,483

proc import and data management

Break the task into steps and create new datasets.  e.g.,

proc import datafile = "SPSS dataset.sav" data = nida.ppi replace;

run;

data step2;

  set nida.ppi;

  if inform_r < 5 then inform = "Bio Parent";

run;

proc contents data=step2 short;

run;

View solution in original post


All Replies
Solution
‎02-17-2012 10:08 AM
PROC Star
Posts: 7,483

proc import and data management

Break the task into steps and create new datasets.  e.g.,

proc import datafile = "SPSS dataset.sav" data = nida.ppi replace;

run;

data step2;

  set nida.ppi;

  if inform_r < 5 then inform = "Bio Parent";

run;

proc contents data=step2 short;

run;

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 122 views
  • 0 likes
  • 2 in conversation