Hi SAS users,   Are there any automatic variables like SQLOBS for counting the number of observations from pass through SQL ?   SQLOBS worked for me for SAS Proc SQL's , but not Pass through.   In my code I have count the extraction for each iterations and load those counts into Oracle table for statistics.   Thanks, Ana ... View more

Hi SAS users,   Need ahelp with figuring out this error in age calculations.   First service date and date of birth are coming as  DATETIME20 format like below examples.   FSTSRVDT    = 07OCT2019:00:00:00 bth_dt  =  21APR1950:00:00:00   below is my query -   proc sql; create table age_threshold_claims as select claim, FSTSRVDT, bth_dt, case when yrdif(datepart(bth_dt),datepart(FSTSRVDT),'AGE') <=18 then 'Y' else '' end as tag_it from SAS_dataset ; Quit;   Error :  NOTE: Invalid (or missing) arguments to the DATEPART function have caused the function to return a missing value. NOTE: Invalid argument to function YRDIF. Missing values may be generated.   Thanks, Ana ... View more

Hi SAS users,   Need help to clear the SCAN error. 'all_exclusions' macro variable has 30 variables with comma delimiter inbetween  and 'temp_exclusions' has 30 variables.   %Do i = 1 %to &count;  %LET exclusion1 = %scan(&all_exclusions,&i, ',');     %LET exclusion2 = %scan(&temp_exclusions,&i, ','); %if %upcase(&exclusion1) = Y %then %Do; %let ...............%End; %END;     Thanks, Ana     ... View more

Hi SAS users,   Need a help !   I have a macro that is resolving to client as abc in the log.But when i call that in a macro, i am getting the below error.   client is resolving correctly like example abc.   %macro &client._call (parms = ); ERROR: Invalid macro name &. It should be a valid SAS identifier no longer than 32 characters. ERROR: A dummy macro will be compiled.     Thanks, Ana ... View more

Hi SAS users, Need help with converting this character date to DATE9 like below.   date1 is the input format data is coming in. Date_out should be '01APR2019'd   data test; date1 = '2019-04-01' ; date2 = dequote(date1); call symputx("date2" , "'"|| input(put(dequote(date1), yymmdd10.),date9.) ||"'d",'g'); run;   %put &date2;   Thanks, Ana ... View more

Hi SAS users,     i need some help in going to last  word which is after  last slash (/) and get word  "file" ( scan and find the first word after first underscore(_) currently i am printing all words.    %let filenm=/path1/div1/test1/list1/file_client_case1; data run_type; length type $30; do i=1 to countw("&filenm.","/"); type=scan("&filenm.",i,"/"); output; end; run; Thanks, Ana ... View more