Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- About Kiteulf
01-19-2023
Kiteulf
Quartz | Level 8
Member since
06-13-2014
- 100 Posts
- 3 Likes Given
- 2 Solutions
- 3 Likes Received
-
Latest posts by Kiteulf
Subject Views Posted 2617 09-05-2022 07:30 AM 2644 09-05-2022 06:31 AM 2652 09-05-2022 06:27 AM 2662 09-05-2022 06:22 AM 2707 09-05-2022 04:56 AM 2729 09-05-2022 04:40 AM 1831 03-17-2022 04:48 AM 1863 03-17-2022 04:18 AM 1864 03-17-2022 04:16 AM 1875 03-17-2022 04:06 AM -
Activity Feed for Kiteulf
- Posted Re: Group by to summarize values on SAS Programming. 09-05-2022 07:30 AM
- Posted Re: Group by to summarize values on SAS Programming. 09-05-2022 06:31 AM
- Posted Re: Group by to summarize values on SAS Programming. 09-05-2022 06:27 AM
- Posted Re: Group by to summarize values on SAS Programming. 09-05-2022 06:22 AM
- Posted Re: Group by to summarize values on SAS Programming. 09-05-2022 04:56 AM
- Posted Group by to summarize values on SAS Programming. 09-05-2022 04:40 AM
- Posted Re: Formatting of sas datetime on SAS Programming. 03-17-2022 04:48 AM
- Posted Re: Formatting of sas datetime on SAS Programming. 03-17-2022 04:18 AM
- Posted Re: Formatting of sas datetime on SAS Programming. 03-17-2022 04:16 AM
- Posted Formatting of sas datetime on SAS Programming. 03-17-2022 04:06 AM
- Got a Like for Formatting of sas datetime. 03-17-2022 04:06 AM
- Posted proc import on SAS Programming. 02-10-2022 10:26 AM
- Posted Sysfunc date on SAS Programming. 02-08-2022 07:12 AM
- Posted Giving a number by unique string on SAS Programming. 12-15-2021 04:51 AM
- Posted Re: SQL select statement on SAS Programming. 09-09-2021 08:30 AM
- Posted Re: SQL select statement on SAS Programming. 09-09-2021 08:08 AM
- Posted Re: Divide population into macro variables on SAS Programming. 09-09-2021 08:06 AM
- Posted Divide population into macro variables on SAS Programming. 09-09-2021 07:24 AM
- Posted Re: SQL select statement on SAS Programming. 09-09-2021 05:08 AM
- Posted SQL select statement on SAS Programming. 09-09-2021 04:52 AM
-
Posts I Liked
Subject Likes Author Latest Post 1 1 1 -
My Liked Posts
Subject Likes Posted 1 03-17-2022 04:06 AM 2 08-24-2017 03:13 AM
09-09-2021
08:06 AM
I think I am misunderstood, (my poor explanation to blame)
I want the ids to be in a list
each macro containing ids
first cohort : id 1-7500
second cohort: id 7501-15000
... View more
09-09-2021
07:24 AM
I want to divide up a population into cohorts of subpopulations where I have the numbers in a macro var.
data Population; do ids = 1 to 100000; output; end; ; run;
proc sql noprint;
select ceil(count(*)/7500)
into :cohort
from Population;
quit;
%put &cohort;
%macro test;
%do i = 1 %to &cohort;
proc sql noprint;
select distinct ids
into :KSIds
from Population(firstobs = &i cohort = &i);
quit;
%end;
%mend;
First I am finding out how many cohorts I need, then I am trying to get a macro to write no more than 7500 KSids from the Population file into the KSIds0, KSIds1. KSids2 etc
I just
... View more
09-09-2021
05:08 AM
So then I will need to do;
from test.account
where delete_ind = 'N'
and current_record_ind ='Y'
and appid in(select id from test2)
The problem then is that the query bogs down. At the moment I have only 3 records from test2 but there will be more later.
If I am doing it manually and
from test.account (where =(delete_ind = 'N'
and current_record_ind ='Y'
and appid in(3819532,3809511,3812779))) as t0
it is super fast
... View more
09-09-2021
04:52 AM
I want to select in proc sql with a where statement from a list
from test.account(where =(delete_ind = 'N'
and current_record_ind ='Y'
and appid in(select id from test2)))
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, a datetime constant, a missing value, -. ERROR 76-322: Syntax error, statement will be ignored. ERROR: Syntax error while parsing WHERE clause. ERROR: Invalid value for the WHERE option.
How should I do this?
... View more
09-08-2021
06:05 AM
A contains ID
B contains
ID, DATE, AMOUNT
pluss a lot more that I don't care about.
... View more
09-08-2021
05:46 AM
Could I use : to choose the column b and c from the big dataset?
data want;
set b; /* big dataset */
if _n_ = 1
then do;
declare hash a (dataset:"a"); /* small dataset */
a.definekey("id");
a.definedata ("id", "b", "c") ;
a.definedone();
end;
if a.check() = 0; /* found an entry */
run;
... View more
09-08-2021
05:01 AM
I have a dataset A that contains about 25 000 records
I have a dataset B that contains about 14 million records
I want some data in dataset B, where A.ID = B.ID, however it takes ages to pull the data.
So far I am using/tried
1. Proc sql : where B.ID in(select ID from A)
(where A only contains distinct numbers of ID)
2.A macro where the smallest A.ID is written and I pull the B.IDs that are greater than that one into a temp file and using that for extraction.
I wish there were a way to write all the A.IDs to a macro and use that, as it looks like my SAS server is having trouble with two tables at the same time
... View more
08-04-2021
04:19 AM
I am sorry for not making my self clear
I was thinking like:
data want;
input Contractnbr $13. month :yymmn6. NGO;
format month yymmn6.;
datalines;
63000-1000538 201110 10077.5
63000-1000538 201111 15428.3
63000-1000538 201112 18102.08
63000-1000538 201201 19393.68
63000-1000538 201202 18998.88
63000-1000538 201203 19429.98
63000-1000538 201204 19170.08
63000-1000538 201205 18928.28
63000-1000538 201206 513.4
63000-1000538 201207 7338.05
63000-1000538 201208 5488.25
63000-1000538 201209 15302.35
63000-1000538 201210 13421.05
63000-1000538 201211 17359.87
63000-1000538 201212 5683.22
63000-1000538 201301 9247.35
63000-1000538 201302 2521.47
63000-1000538 201303 1773.25
63000-1000538 201304 3510.88
63000-1000538 201305 8027.96
63000-1000538 201306 13525.47
63000-1000538 201307 10918.08
63000-1000538 201308 16084.03
63000-1000538 201309 18074.02
63000-1000538 201310 18436.02
63000-1000538 201311 -1156.2
63000-1000538 201312 -1041.4
63000-1000538 201403 1543.6
63000-1000538 201404 -495.9
63000-1000538 201405 259.65
63000-1000538 201406 -1034.1
63000-1000538 201407 -1031.3
63000-1000538 201508 23968.7
63000-1000538 201509 23042.9
63000-1000538 201510 22520.1
63000-1000538 201511 23639.7
63000-1000538 201512 23115.3
63000-1000538 201601 23675
63000-1000538 201602 23155.8
63000-1000538 201603 23716.5
63000-1000538 201604 -1384
63000-1000538 201605 -1265.9
63000-1000538 201607 23734.1
63000-1000538 201608 23924.9
63000-1000538 201609 24411.9
63000-1000538 201610 -1386.4
63000-1000538 201611 -1388.8
63000-1000538 201612 -1387
63000-1000538 201706 18613
63000-1000538 201707 -1610.7
63000-1000538 201708 -1386
63000-1000538 201709 23614
63000-1000538 201710 -1742.1
63000-1000538 201711 -1489.5
63000-1000538 201809 -1267.5
63000-1000538 201810 1924.7
63000-1000538 201811 8962.64
63000-1000538 201812 -10272.6
63000-1000538 201901 14639.38
63000-1000538 201902 22649.06
63000-1000538 201903 23673.12
63000-1000538 201904 -2079.28
63000-1000538 201905 -1713.58
63000-1000538 201906 -1712.68
63000-1000538 201907 -763.68
63000-1000538 201908 -14156.2
63000-1000538 201909 385.69
63000-1000538 201910 4523.32
63000-1000538 201911 17569.64
63000-1000538 201912 -2361
63000-1000538 204902 -2294
63000-1000918 201111 -200
63000-1000918 201112 -200
63000-1000918 201207 -0.12
63000-1000918 201208 3883.7
63000-1000918 201209 -1194.53
63000-1000918 201210 -476.01
63000-1000918 201211 -1204.7
63000-1000918 201212 -1194.5
63000-1000918 201301 -490.25
63000-1000918 201302 -110
63000-1000918 201303 -492.5
63000-1000918 201304 -239.4
63000-1000918 201305 5337.15
63000-1000918 201306 1460.44
63000-1000918 201307 3138.49
63000-1000918 201308 23455.63
63000-1000918 201309 -1072.36
63000-1000918 201310 -1194.84
63000-1000918 201311 -1073.1
63000-1000918 201312 -1195.6
63000-1000918 201401 -1194.5
63000-1000918 201403 -1194.35
63000-1000918 201404 2182.5
63000-1000918 201405 6324.1
63000-1000918 201406 -1300.32
63000-1000918 201407 5048.83
63000-1000918 201408 3004.53
63000-1000918 201409 868.56
63000-1000918 201410 984.96
63000-1000918 201411 2668.29
63000-1000918 201412 3470.01
63000-1000918 201501 3814.71
63000-1000918 201502 -1266.39
63000-1000918 201503 -1195.09
63000-1000918 201509 39158.41
63000-1000918 201510 39673.71
63000-1000918 201511 38865.02
63000-1000918 201512 -1765.32
63000-1000918 201601 -1194.5
63000-1000918 201604 -1194.89
63000-1000918 201605 -650.54
63000-1000918 201606 -1202.04
63000-1000918 201607 -1194.51
63000-1000918 201703 -265.51
63000-1000918 201704 -1207.6
63000-1000918 201705 -1194.5
63000-1000918 201706 3805.5
63000-1000918 201707 -1264.8
63000-1000918 201708 -164.5
63000-1000918 201709 -1209
63000-1000918 201710 -1194.5
63000-1000918 201711 149.5
63000-1000918 201712 426.6
63000-1000918 201801 -1217.6
63000-1000918 201802 -1194.5
63000-1000918 201808 -1194.5
63000-1000918 201809 -1194.5
63000-1000918 201810 805.5
63000-1000918 201811 -1222.6
63000-1000918 201812 -1194.5
;
Run;
... View more
08-03-2021
08:58 AM
Hi
I would like to have some inputs on how to solve this in an easy way; I have made a solution but I think there could be better ways of doing it;
I have data;
data test;
input Contractnbr $13. date :date9. month :yymmn6. Amount;
format date date9.;
format month yymmn6.;
datalines;
63000-1000538 09SEP2011 201110 23.00
63000-1000538 09SEP2011 201110 300.00
63000-1000538 12SEP2011 201110 -200.00
63000-1000538 16SEP2011 201110 22.00
63000-1000538 16SEP2011 201110 200.00
63000-1000538 19SEP2011 201110 -300.00
63000-1000538 20SEP2011 201110 45.00
63000-1000538 20SEP2011 201110 753.50
63000-1000538 20SEP2011 201110 1337.00
63000-1000538 20SEP2011 201110 2605.00
63000-1000538 26SEP2011 201110 22.00
63000-1000538 26SEP2011 201110 200.00
63000-1000538 29SEP2011 201110 70.00
63000-1000538 29SEP2011 201110 5000.00
63000-1000538 01OCT2011 201111 25.00
63000-1000538 01OCT2011 201111 38.80
63000-1000538 01OCT2011 201111 500.00
63000-1000538 02OCT2011 201111 30.00
63000-1000538 02OCT2011 201111 1000.00
63000-1000538 06OCT2011 201111 25.00
63000-1000538 06OCT2011 201111 500.00
63000-1000538 07OCT2011 201111 22.00
63000-1000538 07OCT2011 201111 200.00
63000-1000538 08OCT2011 201111 25.00
63000-1000538 08OCT2011 201111 500.00
63000-1000538 09OCT2011 201111 30.00
63000-1000538 09OCT2011 201111 1000.00
63000-1000538 10OCT2011 201111 30.00
63000-1000538 10OCT2011 201111 1000.00
63000-1000538 11OCT2011 201111 26.00
63000-1000538 11OCT2011 201111 600.00
63000-1000538 15OCT2011 201111 30.00
63000-1000538 15OCT2011 201111 1000.00
63000-1000538 19OCT2011 201111 -5000.00
63000-1000538 20OCT2011 201111 45.00
63000-1000538 20OCT2011 201111 1110.00
63000-1000538 20OCT2011 201111 1971.00
63000-1000538 29OCT2011 201111 92.00
63000-1000538 29OCT2011 201111 329.00
63000-1000538 30OCT2011 201111 22.00
63000-1000538 30OCT2011 201111 200.00
63000-1000538 01NOV2011 201112 249.90
63000-1000538 05NOV2011 201112 35.00
63000-1000538 05NOV2011 201112 1500.00
63000-1000538 08NOV2011 201112 139.29
63000-1000538 09NOV2011 201112 71.00
63000-1000538 09NOV2011 201112 205.69
63000-1000538 10NOV2011 201112 22.00
63000-1000538 10NOV2011 201112 200.00
63000-1000538 11NOV2011 201112 26.00
63000-1000538 11NOV2011 201112 579.90
63000-1000538 11NOV2011 201112 600.00
63000-1000538 18NOV2011 201112 -1000.00
63000-1000538 20NOV2011 201112 45.00
63000-1000538 01DEC2011 201201 312.60
63000-1000538 05DEC2011 201201 30.00
63000-1000538 05DEC2011 201201 1000.00
63000-1000538 10DEC2011 201201 23.00
63000-1000538 10DEC2011 201201 300.00
63000-1000538 16DEC2011 201201 -558.00
63000-1000538 20DEC2011 201201 184.00
63000-1000538 01JAN2012 201202 338.20
63000-1000538 15JAN2012 201202 22.00
63000-1000538 15JAN2012 201202 200.00
63000-1000538 18JAN2012 201202 -1000.00
63000-1000538 20JAN2012 201202 45.00
63000-1000538 01FEB2012 201203 340.10
63000-1000538 04FEB2012 201203 22.00
63000-1000538 04FEB2012 201203 24.00
63000-1000538 04FEB2012 201203 200.00
63000-1000538 04FEB2012 201203 400.00
63000-1000538 20FEB2012 201203 -600.00
63000-1000538 20FEB2012 201203 45.00
63000-1000538 01MAR2012 201204 345.10
63000-1000538 20MAR2012 201204 -650.00
63000-1000538 20MAR2012 201204 45.00
63000-1000538 01APR2012 201205 342.20
63000-1000538 13APR2012 201205 149.00
63000-1000538 14APR2012 201205 22.00
63000-1000538 14APR2012 201205 200.00
63000-1000538 19APR2012 201205 -1000.00
63000-1000538 20APR2012 201205 45.00
63000-1000538 01MAY2012 201206 338.60
63000-1000538 04MAY2012 201206 27.00
63000-1000538 04MAY2012 201206 700.00
63000-1000538 15MAY2012 201206 -19525.48
63000-1000538 20MAY2012 201206 45.00
63000-1000538 01JUN2012 201207 166.70
63000-1000538 06JUN2012 201207 25.00
63000-1000538 06JUN2012 201207 500.00
63000-1000538 09JUN2012 201207 26.00
63000-1000538 09JUN2012 201207 600.00
63000-1000538 14JUN2012 201207 35.00
63000-1000538 14JUN2012 201207 497.95
63000-1000538 14JUN2012 201207 1500.00
63000-1000538 15JUN2012 201207 35.00
63000-1000538 15JUN2012 201207 280.00
63000-1000538 15JUN2012 201207 1500.00
63000-1000538 16JUN2012 201207 29.00
63000-1000538 16JUN2012 201207 900.00
63000-1000538 17JUN2012 201207 29.00
63000-1000538 17JUN2012 201207 900.00
63000-1000538 20JUN2012 201207 -199.00
63000-1000538 01JUL2012 201208 79.20
63000-1000538 05JUL2012 201208 26.00
63000-1000538 05JUL2012 201208 600.00
63000-1000538 20JUL2012 201208 45.00
63000-1000538 26JUL2012 201208 -2600.00
63000-1000538 01AUG2012 201209 132.10
63000-1000538 04AUG2012 201209 26.00
63000-1000538 04AUG2012 201209 600.00
63000-1000538 11AUG2012 201209 30.00
63000-1000538 11AUG2012 201209 1000.00
63000-1000538 20AUG2012 201209 -199.00
63000-1000538 20AUG2012 201209 45.00
63000-1000538 24AUG2012 201209 30.00
63000-1000538 24AUG2012 201209 60.00
63000-1000538 24AUG2012 201209 1000.00
63000-1000538 24AUG2012 201209 4000.00
63000-1000538 27AUG2012 201209 30.00
63000-1000538 27AUG2012 201209 1000.00
63000-1000538 28AUG2012 201209 30.00
63000-1000538 28AUG2012 201209 1000.00
63000-1000538 29AUG2012 201209 30.00
63000-1000538 29AUG2012 201209 1000.00
63000-1000538 01SEP2012 201210 149.70
63000-1000538 15SEP2012 201210 24.00
63000-1000538 15SEP2012 201210 400.00
63000-1000538 19SEP2012 201210 -2500.00
63000-1000538 20SEP2012 201210 45.00
63000-1000538 01OCT2012 201211 275.20
63000-1000538 04OCT2012 201211 24.00
63000-1000538 04OCT2012 201211 199.99
63000-1000538 04OCT2012 201211 400.00
63000-1000538 06OCT2012 201211 282.43
63000-1000538 13OCT2012 201211 40.00
63000-1000538 13OCT2012 201211 1172.20
63000-1000538 13OCT2012 201211 2000.00
63000-1000538 19OCT2012 201211 -500.00
63000-1000538 20OCT2012 201211 45.00
63000-1000538 01NOV2012 201212 302.20
63000-1000538 02NOV2012 201212 108.00
63000-1000538 02NOV2012 201212 150.40
63000-1000538 02NOV2012 201212 229.10
63000-1000538 02NOV2012 201212 240.00
63000-1000538 05NOV2012 201212 200.06
63000-1000538 06NOV2012 201212 303.99
63000-1000538 20NOV2012 201212 -14000.00
63000-1000538 20NOV2012 201212 45.00
63000-1000538 26NOV2012 201212 220.99
63000-1000538 26NOV2012 201212 523.61
63000-1000538 01DEC2012 201301 221.06
63000-1000538 01DEC2012 201301 259.50
63000-1000538 03DEC2012 201301 398.00
63000-1000538 12DEC2012 201301 152.07
63000-1000538 13DEC2012 201301 26.00
63000-1000538 13DEC2012 201301 68.00
63000-1000538 13DEC2012 201301 600.00
63000-1000538 20DEC2012 201301 45.00
63000-1000538 27DEC2012 201301 -700.00
63000-1000538 27DEC2012 201301 179.50
63000-1000538 27DEC2012 201301 778.00
63000-1000538 27DEC2012 201301 1537.00
63000-1000538 01JAN2013 201302 145.90
63000-1000538 02JAN2013 201302 150.00
63000-1000538 02JAN2013 201302 200.00
63000-1000538 11JAN2013 201302 24.00
63000-1000538 11JAN2013 201302 99.00
63000-1000538 11JAN2013 201302 225.00
63000-1000538 11JAN2013 201302 400.00
63000-1000538 12JAN2013 201302 302.18
63000-1000538 17JAN2013 201302 300.25
63000-1000538 18JAN2013 201302 -10000.00
63000-1000538 20JAN2013 201302 45.00
63000-1000538 23JAN2013 201302 198.00
63000-1000538 23JAN2013 201302 299.00
63000-1000538 24JAN2013 201302 64.00
63000-1000538 24JAN2013 201302 87.10
63000-1000538 24JAN2013 201302 300.09
63000-1000538 25JAN2013 201302 82.60
63000-1000538 26JAN2013 201302 352.00
63000-1000538 01FEB2013 201303 132.80
63000-1000538 02FEB2013 201303 500.00
63000-1000538 07FEB2013 201303 25.00
63000-1000538 07FEB2013 201303 500.00
63000-1000538 08FEB2013 201303 90.40
63000-1000538 09FEB2013 201303 59.70
63000-1000538 09FEB2013 201303 81.20
63000-1000538 09FEB2013 201303 248.00
63000-1000538 14FEB2013 201303 288.80
63000-1000538 15FEB2013 201303 361.88
63000-1000538 16FEB2013 201303 500.00
63000-1000538 19FEB2013 201303 -5000.00
63000-1000538 20FEB2013 201303 45.00
63000-1000538 28FEB2013 201303 299.00
63000-1000538 28FEB2013 201303 399.00
63000-1000538 28FEB2013 201303 721.00
63000-1000538 01MAR2013 201304 63.10
63000-1000538 01MAR2013 201304 381.00
63000-1000538 02MAR2013 201304 60.00
63000-1000538 16MAR2013 201304 50.00
63000-1000538 16MAR2013 201304 3000.00
63000-1000538 18MAR2013 201304 24.23
63000-1000538 18MAR2013 201304 423.40
63000-1000538 20MAR2013 201304 -3000.00
63000-1000538 20MAR2013 201304 45.00
63000-1000538 27MAR2013 201304 690.90
63000-1000538 01APR2013 201305 70.80
63000-1000538 08APR2013 201305 358.00
63000-1000538 08APR2013 201305 812.15
63000-1000538 10APR2013 201305 50.90
63000-1000538 11APR2013 201305 196.00
63000-1000538 13APR2013 201305 44.00
63000-1000538 16APR2013 201305 -200.00
63000-1000538 20APR2013 201305 45.00
63000-1000538 22APR2013 201305 35.00
63000-1000538 22APR2013 201305 1500.00
63000-1000538 23APR2013 201305 240.60
63000-1000538 23APR2013 201305 355.19
63000-1000538 24APR2013 201305 44.90
63000-1000538 24APR2013 201305 100.00
63000-1000538 25APR2013 201305 240.56
63000-1000538 25APR2013 201305 274.00
63000-1000538 25APR2013 201305 349.98
63000-1000538 01MAY2013 201306 112.80
63000-1000538 03MAY2013 201306 2999.00
63000-1000538 10MAY2013 201306 284.96
63000-1000538 11MAY2013 201306 446.80
63000-1000538 20MAY2013 201306 -500.00
63000-1000538 20MAY2013 201306 45.00
63000-1000538 22MAY2013 201306 311.28
63000-1000538 22MAY2013 201306 600.00
63000-1000538 23MAY2013 201306 80.90
63000-1000538 23MAY2013 201306 180.00
63000-1000538 23MAY2013 201306 211.70
63000-1000538 24MAY2013 201306 25.00
63000-1000538 24MAY2013 201306 500.00
63000-1000538 29MAY2013 201306 200.07
63000-1000538 01JUN2013 201307 119.00
63000-1000538 01JUN2013 201307 224.70
63000-1000538 06JUN2013 201307 72.80
63000-1000538 06JUN2013 201307 185.00
63000-1000538 07JUN2013 201307 110.00
63000-1000538 07JUN2013 201307 9000.00
63000-1000538 15JUN2013 201307 25.00
63000-1000538 15JUN2013 201307 500.00
63000-1000538 20JUN2013 201307 45.00
63000-1000538 26JUN2013 201307 -14500.00
63000-1000538 28JUN2013 201307 743.00
63000-1000538 29JUN2013 201307 200.11
63000-1000538 29JUN2013 201307 298.00
63000-1000538 29JUN2013 201307 370.00
63000-1000538 01JUL2013 201308 80.00
63000-1000538 01JUL2013 201308 92.00
63000-1000538 01JUL2013 201308 355.00
63000-1000538 02JUL2013 201308 99.70
63000-1000538 03JUL2013 201308 39.90
63000-1000538 03JUL2013 201308 75.00
63000-1000538 05JUL2013 201308 57.60
63000-1000538 05JUL2013 201308 527.60
63000-1000538 05JUL2013 201308 608.73
63000-1000538 05JUL2013 201308 816.00
63000-1000538 13JUL2013 201308 949.00
63000-1000538 14JUL2013 201308 335.00
63000-1000538 15JUL2013 201308 28.49
63000-1000918 31OCT2011 201111 -200.00
63000-1000918 25NOV2011 201112 -523.84
63000-1000918 25NOV2011 201112 247.22
63000-1000918 25NOV2011 201112 276.62
63000-1000918 19JUN2012 201207 -276.55
63000-1000918 19JUN2012 201207 276.55
63000-1000918 23JUN2012 201207 -482.74
63000-1000918 23JUN2012 201207 482.74
63000-1000918 25JUN2012 201207 -4179.00
63000-1000918 25JUN2012 201207 45.00
63000-1000918 25JUN2012 201207 4333.88
63000-1000918 01JUL2012 201208 3.50
63000-1000918 09JUL2012 201208 1698.79
63000-1000918 25JUL2012 201208 -45.00
63000-1000918 25JUL2012 201208 45.00
63000-1000918 25JUL2012 201208 482.74
63000-1000918 25JUL2012 201208 1698.79
63000-1000918 01AUG2012 201209 25.30
63000-1000918 07AUG2012 201209 32.00
63000-1000918 07AUG2012 201209 1200.00
63000-1000918 25AUG2012 201209 45.00
63000-1000918 25AUG2012 201209 730.97
63000-1000918 25AUG2012 201209 1194.50
63000-1000918 29AUG2012 201209 -8306.00
63000-1000918 01SEP2012 201210 87.10
63000-1000918 25SEP2012 201210 631.42
63000-1000918 01OCT2012 201211 3.80
63000-1000918 25OCT2012 201211 -7525.56
63000-1000918 25OCT2012 201211 710.75
63000-1000918 25OCT2012 201211 6082.32
63000-1000918 01NOV2012 201212 10.20
63000-1000918 25DEC2012 201301 341.25
63000-1000918 25DEC2012 201301 363.00
63000-1000918 01JAN2013 201302 2.50
63000-1000918 25JAN2013 201302 -716.65
63000-1000918 31JAN2013 201302 1094.40
63000-1000918 01FEB2013 201303 9.90
63000-1000918 08FEB2013 201303 1076.90
63000-1000918 12FEB2013 201303 499.00
63000-1000918 16FEB2013 201303 203.00
63000-1000918 25FEB2013 201303 -2966.31
63000-1000918 25FEB2013 201303 45.00
63000-1000918 25FEB2013 201303 222.80
63000-1000918 25FEB2013 201303 527.21
63000-1000918 01MAR2013 201304 34.10
63000-1000918 26MAR2013 201304 219.00
63000-1000918 01APR2013 201305 13.60
63000-1000918 15APR2013 201305 -6000.00
63000-1000918 25APR2013 201305 171.99
63000-1000918 25APR2013 201305 178.50
63000-1000918 25APR2013 201305 622.00
63000-1000918 25APR2013 201305 1264.63
63000-1000918 25APR2013 201305 2457.83
63000-1000918 25APR2013 201305 5210.00
63000-1000918 27APR2013 201305 1658.00
63000-1000918 01MAY2013 201306 28.90
63000-1000918 11MAY2013 201306 1766.60
63000-1000918 18MAY2013 201306 888.33
63000-1000918 25MAY2013 201306 -17485.00
63000-1000918 25MAY2013 201306 45.00
63000-1000918 25MAY2013 201306 458.00
63000-1000918 25MAY2013 201306 1461.35
63000-1000918 25MAY2013 201306 1961.91
63000-1000918 25MAY2013 201306 6998.20
63000-1000918 01JUN2013 201307 119.20
63000-1000918 25JUN2013 201307 45.00
63000-1000918 25JUN2013 201307 1513.85
63000-1000918 01JUL2013 201308 54.10
63000-1000918 16JUL2013 201308 626.95
63000-1000918 23JUL2013 201308 2190.50
63000-1000918 25JUL2013 201308 45.00
63000-1000918 25JUL2013 201308 933.50
63000-1000918 25JUL2013 201308 1167.03
63000-1000918 25JUL2013 201308 1334.40
63000-1000918 25JUL2013 201308 6733.41
63000-1000918 25JUL2013 201308 8426.25
63000-1000918 29JUL2013 201308 -2000.00
63000-1000918 30JUL2013 201308 806.00
63000-1000918 01AUG2013 201309 155.90
63000-1000918 09AUG2013 201309 469.50
63000-1000918 23AUG2013 201309 -47236.00
63000-1000918 25AUG2013 201309 45.00
63000-1000918 25AUG2013 201309 2075.19
63000-1000918 25AUG2013 201309 19962.42
63000-1000918 01SEP2013 201310 322.70
63000-1000918 25SEP2013 201310 2181.09
63000-1000918 25SEP2013 201310 5904.73
63000-1000918 30SEP2013 201310 -8531.00
63000-1000918 01OCT2013 201311 -322.70
63000-1000918 01OCT2013 201311 31.20
63000-1000918 01OCT2013 201311 322.70
63000-1000918 25OCT2013 201311 521.55
63000-1000918 25OCT2013 201311 1078.15
63000-1000918 25OCT2013 201311 1142.32
63000-1000918 25OCT2013 201311 2348.52
63000-1000918 31OCT2013 201311 -5000.00
63000-1000918 01NOV2013 201312 15.50
63000-1000918 29NOV2013 201312 -138.00
63000-1000918 01DEC2013 201401 -1.20
63000-1000918 01DEC2013 201401 2.30
63000-1000918 25FEB2014 201403 -643.00
63000-1000918 25FEB2014 201403 643.15
;
Run;
I want ;
Per contractnbr, per end of month the outstanding amount. Preferably also showing months even when there is no change in the amount.
... View more
03-16-2021
07:53 AM
I am trying to find data that is 7 digits long and start with the number 4.
data want;
if not prxId then prxId + prxParse("/\d{7}\/");
set CV_misscr14;
start = 1;
stop = length(aj_text);
call prxNext(prxID, start, stop, aj_text, pos, len);
do while (pos > 0);
cmaenum = input(prxPosn(prxId, 1, aj_text), best.);
output;
call prxNext(prxID, start, stop, aj_text, pos, len);
end;
/*drop prxId start stop pos len;*/
run;
What do I need to change here for it to search for that?
... View more
02-27-2021
02:35 PM
Thanks
@Kurt_Bremser and @Astounding and everybody else;
I took the macro I had and split into approx 100 in each data set, then I could split each of those datasets into 1 obs per dataset through looping through the 100 dataset (another macro). Works very well!
The reason I had to have 1 obs per dataset is that the xml in each obs is about 200 000 char long. So instead of opening the file everytime in a subsequent macro I can pick up just one observation/dataset.
Time spent per operation fell with a factor of 30 🙂
... View more
02-26-2021
08:42 AM
1 The SAS System 13:19 Friday, February 26, 2021
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='RDW-174 DenmarkCreditBureau_Felix';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\Colosas SAS prosjekter\RDWs.egp';
6 %LET _CLIENTPROJECTPATHHOST='ZLE02763';
7 %LET _CLIENTPROJECTNAME='RDWs.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28
29 options mprint;
30
31
32 %macro sloop;
33
34 %do s= 1 %to 2;
35 %do j= 1 %to 5;
36
37 filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
37 ! CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&&s_&j..xml" ;
38
39
40
41
42
43
44 DATA DK_PANDE4_SME_&s_&j ;
45 set Temp2.DK_PANDE3_SME_&s_&j;
46
47
48 %END;%END;
49 %MEND SLOOP;
50 %SLOOP;
WARNING: Apparent symbolic reference S_1 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_1.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
2 The SAS System 13:19 Friday, February 26, 2021
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_1 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_1;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_2 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_2.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_1 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_2 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_2;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_3 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_3.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_2 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_2 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
3 The SAS System 13:19 Friday, February 26, 2021
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_3 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_3;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_4 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_4.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_3 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_3 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_4 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_4;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_5 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_5.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_4 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
4 The SAS System 13:19 Friday, February 26, 2021
WARNING: Data set WORK.S_4 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_5 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_5;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_1 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_1.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_5 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_5 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_1 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_1;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_2 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_2.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
5 The SAS System 13:19 Friday, February 26, 2021
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_1 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_1 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.01 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_2 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_2;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_3 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_3.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_2 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_2 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_3 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_3;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
6 The SAS System 13:19 Friday, February 26, 2021
WARNING: Apparent symbolic reference S_4 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_4.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_3 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_3 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_4 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_4;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
WARNING: Apparent symbolic reference S_5 not resolved.
MPRINT(SLOOP): filename out_pipe "\\colosas001\SAS_NORWAY\Risk\B2C Secured\Playground\Sverre\DATA RISK\20200917
CreditBureauXMLs\XMLrun\Output\DK\SME_DK_&s_5.xml" ;
WARNING: Apparent symbolic reference S_ not resolved.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_4 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_4 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): DATA DK_PANDE4_SME_&s_5 ;
WARNING: Apparent symbolic reference S_ not resolved.
22: LINE and COLUMN cannot be determined.
NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY,
KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_.
200: LINE and COLUMN cannot be determined.
7 The SAS System 13:19 Friday, February 26, 2021
NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred.
ERROR 200-322: The symbol is not recognized and will be ignored.
MPRINT(SLOOP): set Temp2.DK_PANDE3_SME_&s_5;
ERROR: File TEMP2.DK_PANDE3_SME_.DATA does not exist.
51
52 %LET _CLIENTTASKLABEL=;
53 %LET _CLIENTPROCESSFLOWNAME=;
54 %LET _CLIENTPROJECTPATH=;
55 %LET _CLIENTPROJECTPATHHOST=;
56 %LET _CLIENTPROJECTNAME=;
57 %LET _SASPROGRAMFILE=;
58 %LET _SASPROGRAMFILEHOST=;
59
60 ;*';*";*/;quit;run;
____
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.DK_PANDE4_SME_ may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.DK_PANDE4_SME_ was not replaced because this step was stopped.
WARNING: The data set WORK.S_5 may be incomplete. When this step was stopped there were 0 observations and 0 variables.
WARNING: Data set WORK.S_5 was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
61 ODS _ALL_ CLOSE;
62
63
64 QUIT; RUN;
65
... View more
02-26-2021
08:21 AM
I did some changes:
%macro sloop; %do s= 1 %to 2; %do j= 1 %to 5;
filename out_pipe "\\xxxx_&s_&j..xml" ;
DATA test_&s_&j ; set Temp2.test_&s_&j;
%END;%END; %MEND SLOOP; %SLOOP;
However it says:
test_&s_1 _ 22 200 ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, /, ;, _DATA_, _LAST_, _NULL_.
... View more
02-26-2021
07:44 AM
I have files like this:
Test_1_1
Test_1_2
Test_1_3
Test_1_4
Test_2_1
Test_2_2
Test_2_3
Test_2_4
etc...
I need to do a nested loop and can I use both the variables s and j to call up each file?
%macro sloop; %do s= 1 %to 2; do j= 1 to 5;
filename out_pipe "\\xxxx_&s_&j..xml" ;
DATA Test4_SME_&s_&j ; set Temp2.Test_&s_&j;
<various code for handeling the data and modifying it>
run;
%END; %MEND SLOOP; %SLOOP;
... View more
02-26-2021
04:55 AM
Hi
I am getting an error due to the number of files that I need to split. The macro worked fine with <100 obs.
53 DATA DK_PANDE2_SME; 54 set DK_Pande END=EOT; 55 RECNUM = STRIP(PUT(_n_, BEST.)); 56 IF EOT THEN DO; 57 CALL SYMPUTX( 'nobs', RECNUM); 58 END; 59 run;
NOTE: There were 17217 observations read from the data set WORK.DK_PANDE. NOTE: The data set WORK.DK_PANDE2_SME has 17217 observations and 12 variables. NOTE: DATA statement used (Total process time): real time 5.62 seconds cpu time 5.56 seconds
%put &nobs; 17217 62 63 proc datasets library=output kill; NOTE: Deleting OUTPUT.ADDRESSHISTORY (memtype=DATA). 64 run;
65 quit;
NOTE: PROCEDURE DATASETS used (Total process time): real time 0.04 seconds cpu time 0.01 seconds
66 67 %macro split (SRC_DATASET=, OUT_PREFIX=, SPLIT_NUM=, SPLIT_DEF=); 68 /* Parameters: 69 /* SRC_DATASET - name of the source data set */ 70 /* OUT_PREFIX - prefix of the output data sets */ 71 /* SPLIT_NUM - split number */ 72 /* SPLIT_DEF - split definition (=SETS or =NOBS) */ 73 74 %local I K S TLIST; 75 76 /* number of observations &K, number of smaller datasets &S */ 77 data _null_; 78 if 0 then set &SRC_DATASET nobs=N; 79 if upcase("&SPLIT_DEF")='NOBS' then 80 do; 81 call symputx('K',&SPLIT_NUM); 82 call symputx('S',ceil(N/&SPLIT_NUM)); 83 put "***MACRO SPLIT: Splitting into datasets of no more than &SPLIT_NUM observations"; 84 end; 85 else if upcase("&SPLIT_DEF")='SETS' then 86 do; 87 call symputx('S',&SPLIT_NUM); 88 call symputx('K',ceil(N/&SPLIT_NUM)); 89 put "***MACRO SPLIT: Splitting into &SPLIT_NUM datasets"; 90 end; 91 else put "***MACRO SPLIT: Incorrect SPLIT_DEF=&SPLIT_DEF value. Must be either SETS or NOBS."; 3 The SAS System 09:23 Friday, February 26, 2021
92 stop; 93 run; 94 95 /* terminate macro if nothing to split */ 96 %if (&K le 0) or (&S le 0) %then %return; 97 98 /* generate list of smaller dataset names */ 99 %do I=1 %to &S; 100 %let TLIST = &TLIST &OUT_PREFIX._&I; 101 %end; 102 103 /* split source dataset into smaller datasets */ 104 data &TLIST; 105 set &SRC_DATASET; 106 select; 107 %do I=1 %to &S; 108 when(_n_ <= &K * &I) output &OUT_PREFIX._&I; 109 %end; 110 end; 111 run; 112 113 %mend split; 114 115 116 %split(SRC_DATASET=WORK.DK_PANDE2_SME, OUT_PREFIX=WORK.DK_PANDE3_SME, SPLIT_NUM=1, SPLIT_DEF=NOBS);
***MACRO SPLIT: Splitting into datasets of no more than 1 observations NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds
ERROR: The text expression length (65540) exceeds maximum length (65534). The text expression has been truncated to 65534 characters.
... View more
Contact Me
| Online Status |
Offline
|
| Date Last Visited |
01-19-2023
07:02 AM
|
