08-04-2014 11:51 AM
proc Hi guys,
I worte the following code to create a data set named CC and then insert 6 observations into the new data set CC.
However, the data set comes with first row value of each variable are null, it is from the second row to the seventh row that contains the obs that I just inserted.
How come I receive this result?
create table CC
insert into Cc
ID Name Jobcode Salary
2 001 Albert PT1 50000
3 001 Brenda PT1 70000
By the way, if I input variable values directly in Viewtable just like we input data in Excel, then how to insert the variable names into the data set? If I've already change the default variable attribute and lead to that I cannot put variable name above numeric and length specified column?
08-04-2014 12:44 PM
It must be something you did between the two SQL steps. Running the code you provided simply doesn't give an empty first observation. - PG