We've a process where clients will update the file (say sales details) when there is a need and they intimate us about the change. So our job is to load those updated records to SQL DB table by maintaing the history.   For the first time while loading the data to SQL we just did a 'proc append' to SQL table after reading the file via data step infile Statement. However this method will not work to track the history in SQL when there is a update in the file.   I'm not Aware of SCDs as well.  We are not using any Primary/foreign key stuff in SQL.I would like to understand how I can tackle the situation to update the history. I tried with 'Proc SQL update' and 'If first. and last.' but it didn't helped either. Appericiate your help here. I'm OK with any approach to implement this exercise.   Assume I've a file like this.   Id  Name Sales Transaction Example Values Act_Ind Valid_From Valid_To 1 Unit True 6 58001 Y 19000101T000000 99991231T235959 2 Key True 6 121216 Y 19000101T000000 99991231T235959 3 Value True 18 820595,2 Y 19000101T000000 99991231T235959   Assume I've received an update to the file like this. If you notice Transaction value has changed for Key from 6 to 8.   Id  Name Sales Transaction Example Values Act_Ind Valid_From Valid_To 2 Key True 8 121216 Y 20200404T000000 99991231T235959   So now I want data like this SQL table.   Id  Name Sales Transaction Example Values Act_Ind Valid_From Valid_To 1 Unit True 6 58001 Y 19000101T000000 99991231T235959 2 Key True 6 121216 N 19000101T000000 20200403T000000 2 Key True 8 121216 Y 20200404T000000 99991231T235959 3 Value True 18 820595,2 Y 19000101T000000 99991231T235959 ... View more

We've a process where clients will update the file (say sales details) when there is a need and they intimate us about the change. So our job is to load those updated records to SQL DB table by maintaing the history.   For the first time while loading the data to SQL we just did a 'proc append' to SQL table after reading the file via data step infile Statement. However this method will not work to track the history in SQL when there is a update in the file.   I'm not Aware of SCDs as well.  We are not using any Primary/foreign key stuff in SQL.I would like to understand how I can tackle the situation to update the history. I tried with 'Proc SQL update' and 'If first. and last.' but it didn't helped either. Appericiate your help here.   Assume I've a file like this.   Id Name Sales Transaction Example Values Act_Ind Valid_From Valid_To 1 Unit True 6 58001 Y 19000101T000000 99991231T235959 2 Key True 6 121216 Y 19000101T000000 99991231T235959 3 Value True 18 820595,2 Y 19000101T000000 99991231T235959   Assume I've received an update to the file like this. If you notice Transaction value has changed for Key from 6 to 8.   Id  Name Sales Transaction Example Values Act_Ind Valid_From Valid_To 2 Key True 8 121216 Y 20200404T000000 99991231T235959   So now I want data like this SQL table.   Id  Name Sales Transaction Example Values Act_Ind Valid_From Valid_To 1 Unit True 6 58001 Y 19000101T000000 99991231T235959 2 Key True 6 121216 N 19000101T000000 20200403T000000 2 Key True 8 121216 Y 20200404T000000 99991231T235959 3 Value True 18 820595,2 Y 19000101T000000 99991231T235959     ... View more

I would like to how to change the value of automatic macro variable &syscc. I tried the code below, but it's not working. Any help?  Also I want to know some examples where we get this error in real life. I knew that error code 1012 means 'General error condition' what does mean is my question.   %let syscc=1012; data _null_; if &syscc.=1012 then call symput(syscc,0); run;   Error: NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column). 29:36 29:42 ERROR: Symbolic variable name . must begin with a letter or underscore. NOTE: Invalid argument to function SYMPUT(' .',' 0') at line 29 column 29. SYSCC=. _ERROR_=1 _N_=1 NOTE: The SAS System stopped processing this step because of errors. ... View more