cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
rgjpot
‎03-24-2022
  • 9 Posts
  • 0 Likes Given
  • 0 Solutions
  • 0 Likes Received

Re: merge and sum based on multiple variables and colum names

by Calcite | Level 5 in SAS Programming
‎08-26-2021 03:21 AM
‎08-26-2021 03:21 AM
Thank you Tom this works as a charm. ... View more

merge and sum based on multiple variables and colum names

by Calcite | Level 5 in SAS Programming
‎08-24-2021 11:47 AM
‎08-24-2021 11:47 AM
I have a problem with merging my data.   If have the following two tables Table 1             x y z 2019-01 2019-02 2020-06 2021-01 a b c 1 2 1 10 a b d 0 3 1 11 b a d 2 1 3 8 a c b 1 4 5 2   Table 2               x y z 2019-01 2019-05 2020-07 2021-01 2021-02 a b c 0 0 1 8 11 a b d 1 4 3 2 20 b a d 0 1 0 0 2 a e e 0 0 0 2 1   When I merge them i get x y z 2019-01 2019-02 2020-06 2021-01 2019-05 2020-07 2021-02 a b c 0 2 1 8 0 1 11 a b d 1 3 1 2 4 3 20 a c b 1 4 5 2 . . . a e e 0 . . 2 0 0 1 b a d 0 1 3 0 1 0 2   However i need to get this x y z 2019-01 2019-02 2019-05 2020-07 2020-06 2021-01 2021-02 a b c 1 2 0 1 1 18 11 a b d 1 3 4 3 1 13 20 b a d 2 1 1 0 3 8 2 a c b 1 4 0 0 5 2 0 a e e 0 0 0 0 0 2 1   I found some posts that came close to the awnser i needed but there is a second problem that i don't now the year-month upfront and the differ every time i get a new file. (origanal files contain over 40000 records with up to 80 colums) .       ... View more

Re: THE SUM FUNCTION CALL DOES NOT HAVE ENOUGH ARGUMENTS.

by Calcite | Level 5 in SAS Programming
‎07-16-2021 05:49 AM
‎07-16-2021 05:49 AM
This works great thank you. ... View more

Re: THE SUM FUNCTION CALL DOES NOT HAVE ENOUGH ARGUMENTS.

by Calcite | Level 5 in SAS Programming
‎07-16-2021 04:48 AM
‎07-16-2021 04:48 AM
thank you for your reply. I am relativly new in programmming. I indeed do not have _201x or _2020 columns in my dataset. But i tought that when using the _ before the number of the variable name it means that it is a varible name and not a number. What i want to now is de total before 2021 (Eerder dan 2021 in dutch). ... View more

Re: THE SUM FUNCTION CALL DOES NOT HAVE ENOUGH ARGUMENTS.

by Calcite | Level 5 in SAS Programming
‎07-16-2021 04:26 AM
‎07-16-2021 04:26 AM
Dear Cris,   Thanks for the reply. As requested the proc contents   The CONTENTS Procedure  Data Set NameObservationsMember TypeVariablesEngineIndexesCreatedObservation LengthLast ModifiedDeleted ObservationsProtectionCompressedData Set TypeSortedLabel Data Representation Encoding  GD.GLIMS_DATA_2021_MERGE 30169 DATA 27 V9 0 16-07-2021 09:54:27 264 16-07-2021 09:54:27 0   NO   NO     WINDOWS_64   wlatin1 Western (Windows)    Engine/Host Dependent InformationData Set Page SizeNumber of Data Set PagesFirst Data PageMax Obs per PageObs in First Data PageNumber of Data Set RepairsExtendObsCounterFilenameRelease CreatedHost CreatedOwner NameFile SizeFile Size (bytes) 65536 122 1 248 232 0 YES H:\Mijn Documenten\Finacien\mi\Mi 2021\Glims\glims_data_2021_merge.sas7bdat 9.0401M6 X64_7PRO DS\rpot 8MB 8060928  Alphabetic List of Variables and Attributes# Variable Type Len Format Informat Label789101112131415161718192021222324252627162354 2019-01 Num 8 BEST17.   2019-01 2019-02 Num 8 BEST3.   2019-02 2019-03 Num 8 BEST3.   2019-03 2019-04 Num 8 BEST3.   2019-04 2019-05 Num 8 BEST3.   2019-05 2019-08 Num 8 BEST3.   2019-08 2019-10 Num 8 BEST3.   2019-10 2019-11 Num 8 BEST3.   2019-11 2020-01 Num 8 BEST3.   2020-01 2020-02 Num 8 BEST3.   2020-02 2020-03 Num 8 BEST3.   2020-03 2020-05 Num 8 BEST3.   2020-05 2020-06 Num 8 BEST3.   2020-06 2020-07 Num 8 BEST3.   2020-07 2020-08 Num 8 BEST3.   2020-08 2020-09 Num 8 BEST3.   2020-09 2020-10 Num 8 BEST3.   2020-10 2020-11 Num 8 BEST3.   2020-11 2020-12 Num 8 BEST3.   2020-12 2021-01 Num 8 BEST5.   2021-01 2021-02 Num 8 BEST5.   2021-02 AanvragerType Char 12 $12. $12. AanvragerType Bedrag(ODV/Trial) Char 23 $23. $23. Bedrag(ODV/Trial) CodeAanvrager Char 14 $14. $14. CodeAanvrager Kostenplaats Char 14 $14. $14. Kostenplaats Requestcode Char 21 $21. $21. Requestcode Tarief Char 12 $12. $12. Tarief ... View more

THE SUM FUNCTION CALL DOES NOT HAVE ENOUGH ARGUMENTS.

by Calcite | Level 5 in SAS Programming
‎07-16-2021 04:12 AM
‎07-16-2021 04:12 AM
I have a data set with a lot of variables with the year and month as variable name like 2014-01,2019-01,2019-02,2019-05,2020-01,2020-03,2021-01,2021-02,2021-03, 2021-04, 2021-05. I would like to sum the total of 2014-2020. I tried code below but get the error The sum functio call does not have enough argumensts. What do i do wrong?   Eerder_2021 = (Sum(of _201:)+sum(of _2020:)); ... View more

Re: libref asingment worked but when using libname refrence is wrong

by Calcite | Level 5 in SAS Enterprise Guide
‎07-09-2021 05:53 AM
‎07-09-2021 05:53 AM
Hello Bruno, Thank you for your reply. This works but the reason I want to use a libname is that I need to import data from 3 years with 2 files per month so I would like to prevent typing the hole path every time. Is there a way to do this?   ... View more

libref asingment worked but when using libname refrence is wrong

by Calcite | Level 5 in SAS Enterprise Guide
‎07-09-2021 04:25 AM
‎07-09-2021 04:25 AM
I tried to assingn a libref name so that i don't have to us the full pathname every time. The name is assinged but when i try to use it is does not work.   This is the code i used.   libname GD "H:\Mijn Documenten\Finacien\mi\Mi 2021\Glims"; run; proc import datafile = "GD\Factuur_210201_01.xls" out=glims_data_2021; range="blad1$B12:0"; run;   This is the log I get  NOTE: Libref GD was successfully assigned as follows: Engine: V9 Physical Name: H:\Mijn Documenten\Finacien\mi\Mi 2021\Glims 30 run; 31 *importeren van de data; 32 proc import 33 datafile = "GD\Factuur_210201_01.xls" out=glims_data_2021; 34 range="blad1$B12:0"; 35 36 run; ERROR: Unable to open file C:\WINDOWS\system32\GD\Factuur_210201_01.xls. It does not exist or it is already opened exclusively by another user, or you need permission to view its data. NOTE: The SAS System stopped processing this step because of errors. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.03 seconds cpu time 0.01 seconds   Can someone tell me what i do wrong. Thanks in advance ... View more
Contact Me
Online Status
Offline
Date Last Visited
‎03-24-2022 07:48 AM
Quick links