About Chris_LK_87

Chris_LK_87 · ‎11-17-2021

Hello, My dataset looks like this: data have; length id $10 dcode $48; input id$ dcode$ &; datalines; 1 MCB10 PCF01 AAA30 2 AC003 PL000 TAC25 3 QC000 CAB50 FCE10 4 MA100 CA500 DE100 ; run; I would like to flag (1 or 0) every row if they have a code that starts with two letters. data want; length id $10 dcode $48; input id$ dcode$ & $let_flag; datalines; 1 MCB10 PCF01 AAA30 0 2 AC003 PL000 TAC25 1 3 QC000 CAB50 FCE10 1 4 MA100 CA500 DE100 1 ; run; Thanks!

Chris_LK_87 · ‎09-23-2021

Thank!

Chris_LK_87 · ‎09-23-2021

Thanks! This might be a silly question, but howe do add "free text " in a SAS dataset? I have tried: Data logg; file print; put 'Hello world'; run;

Chris_LK_87 · ‎09-22-2021

Hello, My dataset look like this (see below) and is exported to excel with ods. I would like to add free text in a different sheet in the same excel file. The free text should look like this (like a log): 2021-09-22: Changed variabelname for City 2021-09-20: Made uppercase fo City 2021-09-18: Created dataset 2021-09-15: Created a mean I have tried different ways but have not found any good solution to export free text to excel. data have; ; input City$ month$ year2017 year2018 year2019 mean2017_2019; datalines; London Jan 10 15 20 15 Rom Jan 20 25 30 25 Paris Jan 20 10 10 13.33 Berlin Jan 50 60 70 60 London Feb 20 30 40 30 Rom Feb 40 50 60 50 Paris Feb 40 20 20 26.67 Berlin Feb 100 90 50 80 ; run; ODS EXCEL FILE='c:\file-path\Cities.xlsx' options (sheet_interval='none' suppress_bylines="off" sheet_name="City); PROC REPORT data=have; run; ODS EXCEL CLOSE;

Chris_LK_87 · ‎09-19-2021

I have a dataset that have two variables, period (character) and sales. The time series starts in Januari 2021 and grows every month when a new month’s salesfigures is added. The variable period contains information about month and year. Even months that have not yet occurred are in the dataset. I would like to create a macro so I can select periods that have occurred. That is possible to update very month. I have tried this: %Let t_period='Apr_2021' <=period<= 'Sep_2021'; Not sure if I am doing it right. data have; ; input period$ sales; datalines; Jan_2021 100 Feb_2021 200 Mar_2021 150 Apr_2021 320 May_2021 220 Jun_2021 250 Jul_2021 320 Aug_2021 400 Sep_2021 550 Oct_2021 . Nov_2021 . Dec_2021 . Jan_2022 . Feb_2022 . Mar_2022 . ; run; data want; ; input Period$ Sales; datalines; Jan_2021 100 Feb_2021 200 Mar_2021 150 Apr_2021 320 May_2021 220 Jun_2021 250 Jul_2021 320 Aug_2021 400 Sep_2021 550 ; run; Thanks

Chris_LK_87 · ‎07-07-2021

Thanks!

Chris_LK_87 · ‎07-07-2021

I have a dataset that contains data by city and month. The numerical columns contain sales figure for each year and an average. I have tried to use proc transpose but I am not sure that I am doing it right. Or is there an other solution? data have; ; input city$ month$ year2017 year2018 year2019 mean2017_2019; datalines; London Jan 10 15 20 15 Rom Jan 20 25 30 25 Paris Jan 20 10 10 13.33 Berlin Jan 50 60 70 60 London Feb 20 30 40 30 Rom Feb 40 50 60 50 Paris Feb 40 20 20 26.67 Berlin Feb 100 90 50 80 ; run; I would like to create a table that looks like this: Data want; city$ year$ month$ sales mean2017_2019 Berlin 2017 Jan 50 60 Berlin 2018 Jan 60 60 Berlin 2019 Jan 70 60 Berlin 2017 Feb 100 80 Berlin 2018 Feb 90 80 Berlin 2019 Feb 50 80 London 2017 Jan 10 15 etc. Thanks!

Chris_LK_87 · ‎07-05-2021

I have a dataset that is sorted in years and months. Se data have: data have; ; input Year$ month$ sales; datalines; 2017 Jan 10 2017 Feb 20 2018 Jan 20 2018 Feb 25 2019 Jan 15 2019 Feb 30 2020 Jan 50 2020 Feb 40 2021 Jan 20 2021 Feb 35 ; run; I would like to compare against a reference period. The reference period is the average of the years 2017, 2018 and 2019 sorted for each month. The reference period is calculated like this: (2017+2018+2019)/3 for each month. I would like to compare the years 2020 and 2021 to reference period. The comparison should have difference absolute number This is what I want my table to look like: data want; Year$ Month diff_num; 2020 jan 35 2020 feb 15 2021 jan 5 2021 feb 10

Chris_LK_87 · ‎06-04-2021

Hello, I want to use PRINTMISS when I do proc tabulate. But I dont get it to work. How should I write it out? Here is my code: options byline; ods excel file="c" style=sasweb options(sheet_interval="none" sheet_name="Country_states" suppress_bylines="off"); PROC TABULATE DATA=state_list; VAR year2019 year15_18 difference; CLASS State / ORDER=UNFORMATTED MISSING; CLASS gender / ORDER=UNFORMATTED MISSING; CLASS age / ORDER=UNFORMATTED MISSING; CLASS weeks/ ORDER=UNFORMATTED MISSING; by state; TABLE /* Row Dimension */ /*state={LABEL=''},*/ weeks=''* (year2019*F=6. *sum='' year15_18*F=6.* sum='' difference*F=6. *sum='' ) , /* Column Dimension */ gender={LABEL=''}*age={LABEL=''} ; RUN; ods excel close;

Chris_LK_87 · ‎05-25-2021

Thank you! Your solution worked. Of course BALANCE should be numerical, my mistake.

Chris_LK_87 · ‎05-25-2021

Hello, I have a dataset with individuals that contains their balance. The individuals can appear multiple times. I would like to select the individuals that both have positive and negative balance. data have; length id $10 balance $48; input id$ balance$; datalines; 1 25 1 10 2 20 2 -30 3 40 3 80 4 -7 4 2 ; run; Data want; set have; id$ balance$ 2 20 2 -30 4 -7 4 2

Chris_LK_87 · ‎05-06-2021

Thanks!

Chris_LK_87 · ‎05-04-2021

Hello, I have dataset that looks like this. Each line contains an individual and codes attached to that individual. The codes are stored with spaces in one variable. data have; length id $10 dcode $48; input id$ dcode$ &; datalines; 1 MCB10 PC001 AAA30 2 AC003 PA000 TAC25 3 QC000 CAB50 FCE10 ; run; I would like to select every code that begins with tree alphabetic characters and place each code in a new variable. Data want; set have; id$ dcode1$ dcode2$ dcode3$ 1 MCB10 AAA30 2 TAC25 3 CAB50 FCE10

Chris_LK_87 · ‎10-12-2020

Yes, they have a length of 3 bytes.

Chris_LK_87 · ‎10-11-2020

Hello, In my dataset each row cointains information about one individual and their diagnosis code. The information on each individual's different diagnos is stored in one variable that can contain multiple diagnosis ( see 'data have'). I would like to split each diagnos code in to separate variables. ('data want'). data have; input id $ ICD $; cards; 1 I63 H45 T11 2 C03 D25 3 J11 S54 A10 R45 ; run; Data want; id $ ICD1 $ ICD2 $ ICD3 $ ICD4 $; 1 I63 H45 T11 . 2 C03 D25 . . 3 J11 S54 A10 R45 ; run; Thanks in advance!

Online Status	Offline
Date Last Visited	‎10-28-2022 06:30 AM

selecting cases meeting one condition

Random sampling

Assign sequencenumber

Question about duplicates

Re: Hash tables - find code

Hash tables - find code

Re: Selection of dates

Re: Automatic selection of periods/date

Selection of dates

Re: Automatic selection of periods/date

Re: selecting cases meeting one condition

Re: Assign sequencenumber

Re: Question about duplicates

Re: Automatic selection of periods/date

Re: Selection of dates

Select codes that starts with two letters

Re: Export free text to Excel

Re: Export free text to Excel

Export free text to Excel

Macro for character_date range

Re: Issue transpose

Issue transpose

Calculated columns - compare to reference period

Proc tabulate printmiss

Re: Multiple row condition

Multiple row condition

Re: Select codes that begins with tree alphabetic characters

Select codes that begins with tree alphabetic characters

Re: Splitning one variable to multiple variables

Splitning one variable to multiple variables