Please help me here as I am using below code I am getting multiple spaces within the ABC_clm.    proc sql outobs=100; create table test as SELECT C.CLM_ID, C.CLM_VER_NBR, cats('0000'||C.CLM_ID||(put(c.CLM_VER_NBR,z2.))) as ABC_clm from NET.CLAIM C where CLM_VER_NBR ne 0; QUIT;       ... View more

Hello SAS Community,   I am not getting desired output from below code while calculating mode with SAS SQL. Can anyone help me to get the problem fixed.    data new; set sashelp.class; if name in ('Alfred' 'Barbara' 'Carol') then name='Alice'; If name in ('Janet' 'Jane' 'Jeffrey' 'John' 'Joyce') then name='Judy'; if name in('William' 'Louise' 'Mary' 'Philip' 'Robert') then name='Ronald'; run;   proc sort data=new; by name sex; run;   proc sql; create table new_1 as select name, sex, age as mode from ( select name, sex, age, count(1) as count from new group by name, sex, age) group by name, sex having count=max(count); quit;   Desired Output Name Sex Age Alice F 13 Alice M 14 Henry M 14 James M 12 Judy F 11 Judy M 12 Ronald F 12 Ronald M 12 Thomas M 11                           ... View more

I have below table with variables and their labels and there are multiple observations against each value/labels.   Variable Value Label Pre_1 1 Use every day Pre_1 2 Use some days Pre_1 3 Don't use, but have tried in the past Pre_1 4 Heard a lot & never tried Pre_1 5 Heard a little & never tried Pre_1 6 Never heard of it Pre_2 1 Use every day Pre_2 2 Use some days Pre_2 3 Don't use, but have tried in the past Pre_2 4 Heard a lot & never tried Pre_2 5 Heard a little & never tried Pre_2 6 Never heard of it   How can I get below output using proc freq:   Q225  pre_1_2 Frequency Percent Cumulative Frequency Cumulative Percent Use every day 30 6.32 30 6.32 Use some days 98 20.63 128 26.95 Not at all 347 73.05 475 100.00           ... View more

From the below string how can I count the no of upcase letter?   data abc; input name$30.; datalines; Name is Good Name SHould Change Name NOT Changed ;run;   ... View more

  Hi There-   Please help to understand when I am sorting the data by below code and using the new created data set abc123 with by keyword on sorted variables, why SAS is showing error ''BY variables are not properly sorted on data set WORK.ABC1234"   Also how can I use variable actual with by keyword in data step ?   proc sort data=sashelp.prdsal2 (keep=country actual) out=abc1234; by country descending actual; run;   data abc; set abc1234; by country actual; run;     ... View more

  Please help me to get the 6 month next date and previous date from the below dates.  Also suggest me where I am mistaking?     Set-A Migration_Date 1-Oct-10 1-Jun-10 1-Apr-11 1-Oct-10 1-Nov-10 1-Jun-10 1-Oct-10 1-Jan-14 1-Mar-11     data date_treat; set A; sixmonth_backdt=intnx('month','Migration_dt'd,-6,'B'); format sixmonth_backdt date9.; run; ... View more

  Hello,   Please help me to change the no 198704 to a SAS date, where 1987 is Year and 04 is month. Actually I want to calculate the difference (L.O.R)  b/w to Date2 and Date1 in months.   Please tell me where is I am mistaking.   data abc; set ab1; Date1_changed = put(input(put(Date1,6.),yymmn6.),yymmn6.); Date2_changed = put(input(put(Date2,6.),yymmn6.),yymmn6.); LOR = intck('Months',date1, date2); run;     Set - ab1 Date1 Date2 198704 201106 200601 201103 198709 200901 201307 201307 201310 201310 199411 200412 199308 200306 200607 201304         ... View more

  I know proc means with N and Nmiss option provides the no of populated and missing observation for numeric variable. But which proc/options we use to know the missing value of character variable ?   Lets have the below data set as an example.   data abc; input name $ state $; datalines; a up b mp c . d hp e . f mp . gj h hp ; run; ... View more