I have made a small change, if you see any error, please post the log %macro creation(Value); Proc Sql; Create table Target as select t2.NUM, t2.ID, t2.NCEID, t4.POLOBJECTID, t3.PRODUCTVERSIONOBJECTID, t4.EXTERNALIDENTIFIER as ExternalID, t4.Value as Value length = &Value. *Change; from &wrkschema.. lkp_policyinstance t2 inner join &tgtschema.. INS t3 on t2.rpinstid = t3.POLICYINSTANCEID and t2.cdnumpol = '002011216756' inner join &tgtschema.. POLOBJt4 on t3.identifier = t4.POLINOBJ Where t4.externalidentifier = &extrniden. and t3.CHECK= &objMotorbike. ; quit; %mend; %creation(Value=40); ... View more

You can use a Macro to pass the lengths to the columns during table creation %macro creation(var1=, var2=); proc sql; create table testcase ( var1 char(&var1.), var2 char(&var2.) ); quit; %mend; %creation(var1=12, var2=8);   ... View more

You have to divide your code to 2 parts. first mark accounts to delete based on the default flag. A sample code written please fix it before running. data yor_data; set yor_data; if _n_=1 then flagship='Keep'; retain flagship; by quarter account; if first.account then flagship='Keep'; if flagship ne 'Remove' then do if DEFault=1 then flag= 'keep' flagship='Remove' end else flag= 'Remove' flagship='Remove' end run; Write a proc sql to group by account and get sum of Default and based on that output create a format. If Account have a default then it is on one category else the account in some default category Then It is fairly simple you need to write a code similar to above. and you have that format where the account says have a default based on the format skip it from processing as it is already manipulated in above code. And remember to use a accumulator variable for counting when the count is > 2 then put all the flag to delete. This is a tricky code. Put your mind for 1 hour, it will be fixed. I do not have the SAS Engine with me to compile the code that's why you are getting this code skeleton. Sorry for the issues. Hope it helps. ... View more

This code will work, if not try to debug it, there might be some problem with position of retain variable.   proc sort data=sheet3; by studycode atc_codes date_of_supply; run; data final_extract(drop=date_of_supply1); set sheet3; retain date_of_supply1; by studycode atc_codes; if first.atc_codes then do; diff=0; date_of_supply1=date_of_supply; end; else do; diff=date_of_supply1 date_of_supply1=date_of_supply; if diff ge 60 then output; end; run; ... View more

For SASBASE 9.4 in Windows this is how it will work:   <SASBASE instaled path>\sas.exe -CONFIG <SASBASE instaled path>\nls\en\sasv9.CFG -sysin <prgram with path name> -autoexec <if any with path name> -log <log path with log name>   the last tag will print the logs where you want it to print. And it will print the batch log. Not Applog.   Hope this helps. ... View more

I assume that the code you written is working. remove the replace in the code. if you are in linux then use find /pathname/ -name "*.csv" as pipe to get all the CSV file in the parent directory. In your case pathname is /myshare/HHFit Put your code inside a macro like following, I have skipped the part of importing filenames to the DS. %macro ImportCSV(MyFile=); proc import out= AllState datafile="&MyFile" dbms=CSV; run; %mend; Data _null_; set listofFiles; command2execute='%ImportCSV('||filenames||');'; call execute(command2execute); run; Please let me know if it works out for you. ... View more

  You do not have a closing semicolon after end of SQL statement You have a open and statement condition in the query. Please follow the answer provided by @Reeza, It is the most effective way of doing it. Please check the macro variable &TYPE, most of the time they are wrongly entered with quotation attached ('Y' insted of Y) that fails both condition in your macro if condition. proc sql; ... where REPORT_VW.TYPE_GROUP_CD = "&TYPE"; quit; ... View more