BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

while working with SAS Enterprise Guide I used the following code:

/* ----------------------------------------
Code exported from SAS Enterprise Guide
DATE: Wednesday, February 12, 2003 TIME: 04:34:43 PM
PROJECT: Project
PROJECT PATH:
---------------------------------------- */

DATA work.UpdateOrders;
INFILE datalines
DELIMITER=','
MISSOVER
DSD
FIRSTOBS=2
;
LENGTH
'OrderNum'n $ 4
'AcctNumber'n $ 10
'ProductName'n $ 35
'UnitsInStock'n 4
'ProdID'n $ 4
'Quantity'n 4
'SellPrice'n 8
;
INFORMAT
'SellPrice' n DOLLAR15.2
;
FORMAT
'SellPrice' n DOLLAR15.2
;
INPUT
'OrderNum' n$
'AcctNumber'n$
'ProductName'n$
'UnitsInStock'n
'ProdID'n$
'Quantity'n
'SellPrice'n
;
LABEL
'OrderNum'n = 'OrderNum'
'AcctNumber'n = 'AcctNumber'
'ProductName'n = 'ProductName'
'UnitsInStock'n = 'UnitsInStock'
'ProdID'n = 'ProdID'
'Quantity'n = 'Quantity'
'SellPrice'n = 'SellPrice'
;
datalines;
"OrderNum","AcctNumber","ProductName","UnitsInStock","ProdID","Quantity","SellPrice"
4619,0000463065,"Laughing Lumberjack",52,"0067",5,$17.50
1176,0000050709,"Sasquatch Ale",111,"0034",20,$17.50
0326,0000466226,"Sasquatch Ale",111,"0034",14,$17.50
0231,0000973716,"Sasquatch Ale",111,"0034",10,$17.50
2560,0000166482,"Sasquatch Ale",111,"0034",36,$17.50
4120,0000608695,"Sasquatch Ale",111,"0034",10,$17.50
3356,0000781170,"Steeleye Stout",20,"0035",20,$22.50
2454,0000726832,"Steeleye Stout",20,"0035",4,$22.50
4249,0000622982,"Steeleye Stout",20,"0035",100,$22.50
3599,0000799136,"Steeleye Stout",20,"0035",10,$22.50
3812,0000663596,"Steeleye Stout",20,"0035",70,$22.50
4726,0000906749,"Steeleye Stout",20,"0035",40,$22.50
1000,0000084543,"Steeleye Stout",20,"0035",30,$22.50
4858,0000883089,"Steeleye Stout",20,"0035",35,$22.50
4934,0000181721,"Steeleye Stout",20,"0035",60,$22.50
0713,0000862086,"Gnocchi di nonna Ali",21,"0056",2,$43.70
2413,0000688133,"Gnocchi di nonna Ali",21,"0056",4,$43.70
1025,0000082689,"Gnocchi di nonna Ali",21,"0056",20,$43.70
0169,0000799872,"Gnocchi di nonna Ali",21,"0056",12,$43.70
2183,0000016572,"Gnocchi di nonna Ali",21,"0056",20,$43.70
3840,0000883308,"Gnocchi di nonna Ali",21,"0056",18,$43.70
1929,0000721168,"Gnocchi di nonna Ali",21,"0056",20,$43.70
3505,0000981108,"Gnocchi di nonna Ali",21,"0056",70,$43.70
2260,0000582968,"Gnocchi di nonna Ali",21,"0056",5,$43.70
4738,0000513427,"Gnocchi di nonna Ali",21,"0056",30,$43.70
3996,0000908448,"Gnocchi di nonna Ali",21,"0056",28,$43.70
3853,0000565367,"Gnocchi di nonna Ali",21,"0056",40,$43.70
2051,0000694250,"Ravioli Angelo",36,"0057",15,$22.40
2844,0000737667,"Ravioli Angelo",36,"0057",50,$22.40
4630,0000251396,"Ravioli Angelo",36,"0057",2,$22.40
1353,0000603989,"Ravioli Angelo",36,"0057",16,$22.40
4192,0000491521,"Ravioli Angelo",36,"0057",25,$22.40
2864,0000080635,"Ravioli Angelo",36,"0057",25,$22.40
1067,0000624692,"Ravioli Angelo",36,"0057",20,$22.40
2117,0000294823,"Chef Anton's Cajun S",53,"0004",20,$24.60
0945,0000647165,"Chef Anton's Cajun S",53,"0004",24,$24.60
2690,0000873353,"Chef Anton's Cajun S",53,"0004",18,$24.60
0012,0000589163,"Chef Anton's Cajun S",53,"0004",10,$24.60
0703,0000093415,"Chef Anton's Cajun S",53,"0004",35,$24.60
1877,0000009257,"Chef Anton's Gumbo M",0,"0005",65,$23.90
3891,0000846611,"Chef Anton's Gumbo M",0,"0005",12,$23.90
4030,0000513693,"Chef Anton's Gumbo M",0,"0005",20,$23.90
3591,0000897406,"Chef Anton's Gumbo M",0,"0005",32,$23.90
3521,0000259500,"Louisiana Fiery Hot",76,"0065",15,$23.60
4711,0000646425,"Louisiana Fiery Hot",76,"0065",20,$23.60
1335,0000823580,"Louisiana Fiery Hot",76,"0065",30,$23.60
3896,0000983596,"Louisiana Fiery Hot",76,"0065",40,$23.60
2735,0000224145,"Louisiana Fiery Hot",76,"0065",10,$23.60
3654,0000923283,"Louisiana Fiery Hot",76,"0065",5,$23.60
3021,0000109648,"Louisiana Fiery Hot",76,"0065",15,$23.60
2451,0000185907,"Louisiana Fiery Hot",76,"0065",20,$23.60
2046,0000417567,"Louisiana Fiery Hot",76,"0065",20,$23.60
2647,0000032509,"Louisiana Hot Spiced",4,"0066",30,$19.00
3338,0000082678,"Escargots de Bourgog",62,"0058",30,$17.20
1247,0000517084,"Escargots de Bourgog",62,"0058",30,$17.20
2203,0000125785,"Escargots de Bourgog",62,"0058",80,$17.20
3308,0000014884,"Escargots de Bourgog",62,"0058",15,$17.20
4900,0000401624,"Aniseed Syrup",13,"0003",30,$11.20
1148,0000176661,"Aniseed Syrup",13,"0003",50,$11.20
3986,0000409130,"Chai",39,"0001",45,$22.50
4642,0000920873,"Chai",39,"0001",18,$22.50
0662,0000651274,"Chai",39,"0001",20,$22.50
3579,0000929158,"Chai",39,"0001",15,$22.50
1903,0000822346,"Chai",39,"0001",12,$22.50
2223,0000123874,"Chai",39,"0001",15,$22.50
4216,0000516983,"Chai",39,"0001",10,$22.50
2920,0000755603,"Chai",39,"0001",24,$22.50
4726,0000245715,"Chang",17,"0002",20,$23.80
2811,0000904737,"Chang",17,"0002",50,$23.80
4890,0000615439,"Chang",17,"0002",35,$23.80
1722,0000310272,"Chang",17,"0002",40,$23.80
3982,0000698899,"Chang",17,"0002",25,$23.80
3374,0000588039,"Chang",17,"0002",7,$23.80
1552,0000571101,"Chang",17,"0002",24,$23.80
2520,0000295687,"Chang",17,"0002",25,$23.80
4697,0000901139,"Chang",17,"0002",60,$23.80
1561,0000995791,"Chang",17,"0002",10,$23.80
1388,0000157775,"Sirop d'érable",113,"0061",16,$31.90
4520,0000178610,"Tarte au sucre",17,"0062",15,$62.60
4226,0000278300,"Tarte au sucre",17,"0062",12,$62.60
2206,0000443510,"Tarte au sucre",17,"0062",40,$62.60
1180,0000916022,"Tarte au sucre",17,"0062",15,$62.60
0377,0000778668,"Tarte au sucre",17,"0062",10,$62.60
3603,0000969423,"Tarte au sucre",17,"0062",5,$62.60
0852,0000878136,"Tarte au sucre",17,"0062",25,$62.60
0719,0000128550,"Tarte au sucre",17,"0062",70,$62.60
2041,0000463689,"Tarte au sucre",17,"0062",28,$62.60
0476,0000177844,"Tarte au sucre",17,"0062",20,$62.60
2096,0000515706,"Tarte au sucre",17,"0062",10,$62.60
1440,0000795900,"Tarte au sucre",17,"0062",35,$62.60
2791,0000990698,"Tarte au sucre",17,"0062",40,$62.60
2001,0000911962,"Gorgonzola Telino",0,"0031",20,$15.10
4665,0000476027,"Gorgonzola Telino",0,"0031",40,$15.10
1898,0000240719,"Gorgonzola Telino",0,"0031",15,$15.10
4326,0000876788,"Gorgonzola Telino",0,"0031",4,$15.10
2987,0000978106,"Gorgonzola Telino",0,"0031",25,$15.10
2702,0000577140,"Gorgonzola Telino",0,"0031",56,$15.10
1201,0000461897,"Gorgonzola Telino",0,"0031",30,$15.10
0490,0000827651,"Gorgonzola Telino",0,"0031",70,$15.10
2065,0000171049,"Gorgonzola Telino",0,"0031",20,$15.10
3409,0000152078,"Gorgonzola Telino",0,"0031",30,$15.10
4928,0000462008,"Gorgonzola Telino",0,"0031",42,$15.10
4911,0000025117,"Gorgonzola Telino",0,"0031",60,$15.10
0463,0000428437,"Gorgonzola Telino",0,"0031",32,$15.10
0677,0000758451,"Gorgonzola Telino",0,"0031",14,$15.10
1366,0000575381,"Mascarpone Fabioli",9,"0032",6,$38.70
3935,0000737762,"Mascarpone Fabioli",9,"0032",40,$38.70
3421,0000410989,"Mascarpone Fabioli",9,"0032",6,$38.70
0822,0000931290,"Mozzarella di Giovan",14,"0072",5,$42.10
1043,0000758033,"Mozzarella di Giovan",14,"0072",4,$42.10
3436,0000257772,"Mozzarella di Giovan",14,"0072",20,$42.10
4018,0000878407,"Mozzarella di Giovan",14,"0072",24,$42.10
3586,0000977031,"Mozzarella di Giovan",14,"0072",7,$42.10
3307,0000501523,"Mozzarella di Giovan",14,"0072",3,$42.10
2698,0000305493,"Mozzarella di Giovan",14,"0072",20,$42.10
3119,0000298127,"Mozzarella di Giovan",14,"0072",40,$42.10
0434,0000989902,"Mozzarella di Giovan",14,"0072",25,$42.10
0006,0000597046,"Mozzarella di Giovan",14,"0072",25,$42.10
0860,0000420250,"Mozzarella di Giovan",14,"0072",42,$42.10
4953,0000372038,"Mozzarella di Giovan",14,"0072",24,$42.10
2102,0000118775,"Mozzarella di Giovan",14,"0072",21,$42.10
0826,0000309503,"Mozzarella di Giovan",14,"0072",10,$42.10
0668,0000175111,"Camembert Pierrot",19,"0060",40,$41.10
4373,0000962176,"Camembert Pierrot",19,"0060",35,$41.10
4301,0000285432,"Camembert Pierrot",19,"0060",20,$41.10
3548,0000533076,"Camembert Pierrot",19,"0060",21,$41.10
0346,0000350766,"Camembert Pierrot",19,"0060",8,$41.10
2688,0000884666,"Camembert Pierrot",19,"0060",80,$41.10
0941,0000496869,"Camembert Pierrot",19,"0060",55,$41.10
0978,0000712965,"Camembert Pierrot",19,"0060",70,$41.10
3220,0000499278,"Camembert Pierrot",19,"0060",6,$41.10
1448,0000812921,"Camembert Pierrot",19,"0060",15,$41.10
0254,0000116562,"Camembert Pierrot",19,"0060",20,$41.10
1663,0000047307,"Camembert Pierrot",19,"0060",60,$41.10
1605,0000000175,"Raclette Courdavault",79,"0059",30,$66.60
2820,0000726151,"Raclette Courdavault",79,"0059",70,$66.60
4120,0000992432,"Raclette Courdavault",79,"0059",6,$66.60
0013,0000197794,"Raclette Courdavault",79,"0059",15,$66.60
3653,0000411039,"Raclette Courdavault",79,"0059",30,$66.60
4172,0000377228,"Raclette Courdavault",79,"0059",10,$66.60
4103,0000615917,"Raclette Courdavault",79,"0059",40,$66.60
1984,0000862821,"Raclette Courdavault",79,"0059",9,$66.60
4571,0000799298,"Raclette Courdavault",79,"0059",9,$66.60
4128,0000585057,"Raclette Courdavault",79,"0059",12,$66.60
4638,0000954954,"Raclette Courdavault",79,"0059",16,$66.60
4755,0000299349,"Raclette Courdavault",79,"0059",9,$66.60
4169,0000825147,"Raclette Courdavault",79,"0059",20,$66.60
4344,0000164995,"Raclette Courdavault",79,"0059",70,$66.60
3851,0000639493,"Filo Mix",38,"0052",20,$8.10
1113,0000011780,"Filo Mix",38,"0052",8,$8.10
4494,0000267200,"Filo Mix",38,"0052",20,$8.10
4886,0000050966,"Manjimup Dried Apple",20,"0051",40,$64.70
2740,0000710782,"Manjimup Dried Apple",20,"0051",35,$64.70
0470,0000435543,"Manjimup Dried Apple",20,"0051",2,$64.70
0354,0000602385,"Manjimup Dried Apple",20,"0051",48,$64.70
1980,0000328459,"Manjimup Dried Apple",20,"0051",20,$64.70
2971,0000115772,"Manjimup Dried Apple",20,"0051",18,$64.70
2883,0000412688,"Gumbنr Gummibنrchen",15,"0026",50,$39.70
0013,0000296024,"Gumbنr Gummibنrchen",15,"0026",24,$39.70
1584,0000651672,"Gumbنr Gummibنrchen",15,"0026",16,$39.70
2654,0000942264,"Gumbنr Gummibنrchen",15,"0026",70,$39.70
3285,0000652615,"Gumbنr Gummibنrchen",15,"0026",30,$39.70
0605,0000779796,"Gumbنr Gummibنrchen",15,"0026",30,$39.70
2301,0000292975,"Gumbنr Gummibنrchen",15,"0026",2,$39.70
4860,0000525115,"Gumbنr Gummibنrchen",15,"0026",10,$39.70
1629,0000010706,"NuNuCa Nuك-Nougat-Cr",76,"0025",4,$17.80
2778,0000049363,"NuNuCa Nuك-Nougat-Cr",76,"0025",10,$17.80
2236,0000060510,"NuNuCa Nuك-Nougat-Cr",76,"0025",50,$17.80
1271,0000132725,"NuNuCa Nuك-Nougat-Cr",76,"0025",7,$17.80
3596,0000774147,"Schoggi Schokolade",49,"0027",25,$55.80
3763,0000488741,"Schoggi Schokolade",49,"0027",15,$55.80
1907,0000790909,"Chartreuse verte",69,"0039",42,$22.50
2305,0000117847,"Chartreuse verte",69,"0039",6,$22.50
4819,0000651805,"Chartreuse verte",69,"0039",60,$22.50
2640,0000175014,"Chartreuse verte",69,"0039",30,$22.50
4744,0000601333,"Chartreuse verte",69,"0039",4,$22.50
4408,0000686847,"Chartreuse verte",69,"0039",50,$22.50
2868,0000369195,"Chartreuse verte",69,"0039",54,$22.50
4718,0000124934,"Chartreuse verte",69,"0039",20,$22.50
0930,0000571953,"Côte de Blaye",17,"0038",20,$329.40
3146,0000613898,"Côte de Blaye",17,"0038",20,$329.40
3508,0000283011,"Côte de Blaye",17,"0038",50,$329.40
3206,0000893315,"Côte de Blaye",17,"0038",10,$329.40
2965,0000710500,"Côte de Blaye",17,"0038",40,$329.40
3591,0000881460,"Côte de Blaye",17,"0038",50,$329.40
1038,0000685054,"Côte de Blaye",17,"0038",49,$329.40
2475,0000843850,"Lakkalikِِri",57,"0076",15,$22.50
4827,0000080836,"Lakkalikِِri",57,"0076",33,$22.50
1698,0000806130,"Lakkalikِِri",57,"0076",6,$22.50
1348,0000949351,"Lakkalikِِri",57,"0076",30,$22.50
3255,0000992781,"Lakkalikِِri",57,"0076",15,$22.50
1626,0000861789,"Lakkalikِِri",57,"0076",12,$22.50
3215,0000022651,"Lakkalikِِri",57,"0076",35,$22.50
4546,0000822287,"Lakkalikِِri",57,"0076",14,$22.50
2735,0000916049,"Lakkalikِِri",57,"0076",20,$22.50
3989,0000670940,"Lakkalikِِri",57,"0076",18,$22.50
2792,0000782730,"Maxilaku",10,"0049",40,$25.40
2236,0000917670,"Maxilaku",10,"0049",15,$25.40
4847,0000242978,"Maxilaku",10,"0049",30,$25.40
0802,0000425769,"Maxilaku",10,"0049",35,$25.40
4330,0000013459,"Maxilaku",10,"0049",30,$25.40
4545,0000927676,"Maxilaku",10,"0049",30,$25.40
3206,0000701518,"Valkoinen suklaa",65,"0050",15,$20.60
3281,0000660471,"Valkoinen suklaa",65,"0050",15,$20.60
0191,0000872391,"Valkoinen suklaa",65,"0050",40,$20.60
3742,0000463335,"Grandma's Boysenberr",120,"0006",30,$28.00
3921,0000232788,"Grandma's Boysenberr",120,"0006",6,$28.00
4834,0000518717,"Northwoods Cranberry",6,"0008",70,$44.80
2804,0000505569,"Northwoods Cranberry",6,"0008",70,$44.80
0169,0000071627,"Uncle Bob's Organic",15,"0007",15,$36.60
2742,0000924857,"Uncle Bob's Organic",15,"0007",10,$36.60
1066,0000469947,"Gula Malacca",27,"0044",16,$21.80
2002,0000780080,"Gula Malacca",27,"0044",21,$21.80
2912,0000079997,"Gula Malacca",27,"0044",24,$21.80
0276,0000976773,"Gula Malacca",27,"0044",77,$21.80
1793,0000049124,"Gula Malacca",27,"0044",40,$21.80
0508,0000730367,"Ipoh Coffee",17,"0043",25,$57.50
0520,0000469821,"Ipoh Coffee",17,"0043",15,$57.50
1886,0000299860,"Ipoh Coffee",17,"0043",12,$57.50
1465,0000276510,"Ipoh Coffee",17,"0043",20,$57.50
0254,0000903685,"Ipoh Coffee",17,"0043",24,$57.50
2798,0000568514,"Ipoh Coffee",17,"0043",40,$57.50
4752,0000003183,"Singaporean Hokkien",26,"0042",10,$16.10
2170,0000975017,"Singaporean Hokkien",26,"0042",2,$16.10
0239,0000448156,"Singaporean Hokkien",26,"0042",6,$16.10
3863,0000976307,"Singaporean Hokkien",26,"0042",10,$16.10
0943,0000202678,"Singaporean Hokkien",26,"0042",9,$16.10
3679,0000084872,"Singaporean Hokkien",26,"0042",40,$16.10
0436,0000636744,"Rّgede sild",5,"0045",15,$12.40
4533,0000287045,"Spegesild",95,"0046",15,$15.60
2656,0000604801,"Spegesild",95,"0046",30,$15.60
3320,0000333540,"Spegesild",95,"0046",45,$15.60
1200,0000378426,"Spegesild",95,"0046",28,$15.60
1939,0000878249,"Spegesild",95,"0046",2,$15.60
0504,0000780243,"Spegesild",95,"0046",20,$15.60
3635,0000176610,"Spegesild",95,"0046",5,$15.60
0048,0000724419,"Pâté chinois",115,"0055",21,$29.50
1749,0000385930,"Pâté chinois",115,"0055",20,$29.50
3754,0000808281,"Pâté chinois",115,"0055",40,$29.50
3093,0000856479,"Pâté chinois",115,"0055",12,$29.50
2401,0000061203,"Pâté chinois",115,"0055",15,$29.50
3694,0000805738,"Pâté chinois",115,"0055",120,$29.50
4808,0000845961,"Pâté chinois",115,"0055",10,$29.50
1766,0000348269,"Tourtière",21,"0054",10,$9.20
4513,0000704152,"Tourtière",21,"0054",5,$9.20
0455,0000294750,"Tourtière",21,"0054",15,$9.20
3681,0000148215,"Tourtière",21,"0054",24,$9.20
0210,0000116754,"Tourtière",21,"0054",20,$9.20
4716,0000028822,"Tourtière",21,"0054",28,$9.20
2778,0000347486,"Tourtière",21,"0054",24,$9.20
3520,0000595701,"Tourtière",21,"0054",18,$9.20
0840,0000371175,"Tourtière",21,"0054",10,$9.20
0154,0000648070,"Tourtière",21,"0054",6,$9.20
1627,0000461557,"Tourtière",21,"0054",40,$9.20
2298,0000085506,"Genen Shouyu",39,"0015",20,$17.40
3642,0000261378,"Genen Shouyu",39,"0015",5,$17.40
0316,0000978846,"Konbu",24,"0013",10,$7.80
1456,0000387623,"Konbu",24,"0013",20,$7.80
3310,0000142653,"Konbu",24,"0013",12,$7.80
0322,0000451140,"Konbu",24,"0013",20,$7.80
2006,0000510557,"Konbu",24,"0013",18,$7.80
1271,0000421573,"Konbu",24,"0013",10,$7.80
4280,0000980758,"Konbu",24,"0013",2,$7.80
0592,0000042432,"Tofu",35,"0014",9,$28.40
4618,0000032979,"Tofu",35,"0014",9,$28.40
2954,0000841635,"Tofu",35,"0014",10,$28.40
0526,0000693937,"Tofu",35,"0014",15,$28.40
3158,0000897684,"Tofu",35,"0014",42,$28.40
0190,0000918055,"Tofu",35,"0014",12,$28.40
3608,0000212844,"Tofu",35,"0014",20,$28.40
3297,0000413938,"Tofu",35,"0014",35,$28.40
0204,0000050656,"Boston Crab Meat",123,"0040",50,$23.90
0556,0000427929,"Boston Crab Meat",123,"0040",60,$23.90
2820,0000791226,"Boston Crab Meat",123,"0040",40,$23.90
1653,0000032826,"Boston Crab Meat",123,"0040",10,$23.90
2684,0000779665,"Boston Crab Meat",123,"0040",40,$23.90
0280,0000644746,"Boston Crab Meat",123,"0040",4,$23.90
1186,0000456642,"Boston Crab Meat",123,"0040",2,$23.90
3938,0000720201,"Boston Crab Meat",123,"0040",50,$23.90
3300,0000901464,"Jack's New England C",85,"0041",10,$12.50
3111,0000961137,"Jack's New England C",85,"0041",16,$12.50
2307,0000889845,"Jack's New England C",85,"0041",25,$12.50
1810,0000970794,"Jack's New England C",85,"0041",10,$12.50
1457,0000401761,"Jack's New England C",85,"0041",20,$12.50
1042,0000792909,"Jack's New England C",85,"0041",12,$12.50
2965,0000745997,"Jack's New England C",85,"0041",13,$12.50
2837,0000149309,"Jack's New England C",85,"0041",8,$12.50
4464,0000952153,"Jack's New England C",85,"0041",25,$12.50
1762,0000837692,"Nord-Ost Matjesherin",10,"0030",60,$33.70
4847,0000811776,"Nord-Ost Matjesherin",10,"0030",6,$33.70
4226,0000852984,"Nord-Ost Matjesherin",10,"0030",10,$33.70
4847,0000932626,"Nord-Ost Matjesherin",10,"0030",35,$33.70
3981,0000987161,"Nord-Ost Matjesherin",10,"0030",8,$33.70
4276,0000362476,"Nord-Ost Matjesherin",10,"0030",15,$33.70
2178,0000531218,"Nord-Ost Matjesherin",10,"0030",18,$33.70
3116,0000510169,"Nord-Ost Matjesherin",10,"0030",18,$33.70
4139,0000910024,"Flّtemysost",26,"0071",20,$26.00
2970,0000413101,"Flّtemysost",26,"0071",2,$26.00
1063,0000405565,"Flّtemysost",26,"0071",3,$26.00
4394,0000618539,"Flّtemysost",26,"0071",30,$26.00
0574,0000381611,"Flّtemysost",26,"0071",40,$26.00
2909,0000767071,"Flّtemysost",26,"0071",5,$26.00
3626,0000379135,"Flّtemysost",26,"0071",50,$26.00
2809,0000111330,"Flّtemysost",26,"0071",6,$26.00
3891,0000304149,"Flّtemysost",26,"0071",15,$26.00
0446,0000896192,"Flّtemysost",26,"0071",60,$26.00
1980,0000972982,"Flّtemysost",26,"0071",30,$26.00
1028,0000058355,"Flّtemysost",26,"0071",60,$26.00
2195,0000903459,"Flّtemysost",26,"0071",15,$26.00
1987,0000869688,"Geitost",112,"0033",25,$3.00
1025,0000107507,"Geitost",112,"0033",60,$3.00
1956,0000987436,"Geitost",112,"0033",24,$3.00
0594,0000698117,"Geitost",112,"0033",20,$3.00
2352,0000889975,"Geitost",112,"0033",8,$3.00
4744,0000651488,"Geitost",112,"0033",60,$3.00
2067,0000104904,"Geitost",112,"0033",49,$3.00
0227,0000751610,"Geitost",112,"0033",50,$3.00
1995,0000383285,"Geitost",112,"0033",20,$3.00
1328,0000963964,"Gudbrandsdalsost",26,"0069",15,$43.60
1596,0000731226,"Gudbrandsdalsost",26,"0069",1,$43.60
3248,0000586957,"Gudbrandsdalsost",26,"0069",7,$43.60
0032,0000172603,"Gudbrandsdalsost",26,"0069",18,$43.60
2225,0000276308,"Gudbrandsdalsost",26,"0069",20,$43.60
4771,0000324286,"Gudbrandsdalsost",26,"0069",30,$43.60
1022,0000894772,"Gudbrandsdalsost",26,"0069",50,$43.60
3047,0000527375,"Gudbrandsdalsost",26,"0069",8,$43.60
0101,0000908215,"Gudbrandsdalsost",26,"0069",15,$43.60
1165,0000961157,"Gudbrandsdalsost",26,"0069",20,$43.60
0042,0000029328,"Gustaf's Knنckebrِd",104,"0022",6,$24.20
3900,0000514993,"Gustaf's Knنckebrِd",104,"0022",12,$24.20
4172,0000603413,"Tunnbrِd",61,"0023",40,$10.40
1924,0000014387,"Tunnbrِd",61,"0023",25,$10.40
0599,0000178267,"Tunnbrِd",61,"0023",40,$10.40
3225,0000946316,"Tunnbrِd",61,"0023",60,$10.40
1435,0000758613,"Alice Mutton",0,"0017",30,$48.00
4050,0000449946,"Alice Mutton",0,"0017",15,$48.00
3816,0000864919,"Alice Mutton",0,"0017",15,$48.00
3456,0000550503,"Alice Mutton",0,"0017",40,$48.00
0155,0000482557,"Alice Mutton",0,"0017",8,$48.00
4167,0000071137,"Alice Mutton",0,"0017",20,$48.00
4954,0000370647,"Alice Mutton",0,"0017",70,$48.00
2061,0000553514,"Alice Mutton",0,"0017",36,$48.00
4534,0000563330,"Alice Mutton",0,"0017",2,$48.00
0732,0000900154,"Alice Mutton",0,"0017",45,$48.00
4189,0000927466,"Alice Mutton",0,"0017",50,$48.00
0190,0000297097,"Carnarvon Tigers",42,"0018",12,$81.30
1607,0000924015,"Carnarvon Tigers",42,"0018",25,$81.30
1744,0000518941,"Carnarvon Tigers",42,"0018",40,$81.30
2612,0000615818,"Carnarvon Tigers",42,"0018",20,$81.30
0050,0000466767,"Carnarvon Tigers",42,"0018",9,$81.30
0582,0000237474,"Outback Lager",15,"0070",21,$18.80
1520,0000915010,"Outback Lager",15,"0070",20,$18.80
4461,0000825925,"Outback Lager",15,"0070",20,$18.80
3246,0000412145,"Outback Lager",15,"0070",5,$18.80
4193,0000696925,"Outback Lager",15,"0070",30,$18.80
3639,0000710733,"Outback Lager",15,"0070",30,$18.80
3302,0000096823,"Outback Lager",15,"0070",30,$18.80
4035,0000722159,"Outback Lager",15,"0070",8,$18.80
1322,0000667129,"Pavlova",29,"0016",35,$22.20
0578,0000640811,"Pavlova",29,"0016",60,$22.20
4364,0000261097,"Pavlova",29,"0016",40,$22.20
3197,0000072922,"Pavlova",29,"0016",30,$22.20
3365,0000000499,"Pavlova",29,"0016",10,$22.20
3464,0000591389,"Pavlova",29,"0016",21,$22.20
4001,0000836612,"Pavlova",29,"0016",56,$22.20
0165,0000549131,"Pavlova",29,"0016",21,$22.20
1704,0000604830,"Vegie-spread",24,"0063",8,$49.20
0152,0000511479,"Vegie-spread",24,"0063",5,$49.20
0254,0000789840,"Vegie-spread",24,"0063",80,$49.20
0403,0000231020,"Vegie-spread",24,"0063",16,$49.20
4544,0000437249,"Vegie-spread",24,"0063",65,$49.20
2642,0000961978,"Vegie-spread",24,"0063",35,$49.20
2718,0000089272,"Original Frankfurter",32,"0077",12,$14.60
2205,0000123607,"Original Frankfurter",32,"0077",15,$14.60
3145,0000192425,"Original Frankfurter",32,"0077",10,$14.60
2180,0000745184,"Original Frankfurter",32,"0077",5,$14.60
3168,0000661410,"Original Frankfurter",32,"0077",7,$14.60
3286,0000222005,"Original Frankfurter",32,"0077",14,$14.60
1055,0000083489,"Original Frankfurter",32,"0077",35,$14.60
0493,0000153538,"Original Frankfurter",32,"0077",10,$14.60
1971,0000408126,"Rhِnbrنu Klosterbier",125,"0075",30,$9.70
4200,0000308737,"Rhِnbrنu Klosterbier",125,"0075",6,$9.70
3456,0000164355,"Rhِnbrنu Klosterbier",125,"0075",6,$9.70
4688,0000449891,"Rhِnbrنu Klosterbier",125,"0075",10,$9.70
1974,0000186592,"Rhِnbrنu Klosterbier",125,"0075",50,$9.70
0402,0000750731,"Rhِnbrنu Klosterbier",125,"0075",6,$9.70
3503,0000733247,"Rhِnbrنu Klosterbier",125,"0075",12,$9.70
1847,0000051162,"Rhِnbrنu Klosterbier",125,"0075",24,$9.70
1987,0000064127,"Rِssle Sauerkraut",26,"0028",20,$55.60
1693,0000885537,"Rِssle Sauerkraut",26,"0028",28,$55.60
0044,0000425048,"Rِssle Sauerkraut",26,"0028",4,$55.60
1241,0000920420,"Rِssle Sauerkraut",26,"0028",14,$55.60
2715,0000174037,"Rِssle Sauerkraut",26,"0028",30,$55.60
4002,0000802901,"Rِssle Sauerkraut",26,"0028",13,$55.60
4150,0000501489,"Rِssle Sauerkraut",26,"0028",20,$55.60
1201,0000398583,"Rِssle Sauerkraut",26,"0028",6,$55.60
4145,0000091599,"Rِssle Sauerkraut",26,"0028",42,$55.60
1104,0000141919,"Thüringer Rostbratwu",0,"0029",10,$152.30
2985,0000712339,"Thüringer Rostbratwu",0,"0029",15,$152.30
1593,0000030968,"Thüringer Rostbratwu",0,"0029",25,$152.30
1957,0000428298,"Thüringer Rostbratwu",0,"0029",4,$152.30
2333,0000982031,"Thüringer Rostbratwu",0,"0029",35,$152.30
1726,0000417889,"Thüringer Rostbratwu",0,"0029",20,$152.30
4319,0000203970,"Thüringer Rostbratwu",0,"0029",14,$152.30
3930,0000422638,"Thüringer Rostbratwu",0,"0029",21,$152.30
1071,0000678519,"Wimmers gute Semmelk",22,"0064",9,$38.20
2086,0000518920,"Wimmers gute Semmelk",22,"0064",50,$38.20
0966,0000724756,"Wimmers gute Semmelk",22,"0064",35,$38.20
3966,0000911118,"Wimmers gute Semmelk",22,"0064",30,$38.20
1692,0000213256,"Wimmers gute Semmelk",22,"0064",7,$38.20
2081,0000906508,"Wimmers gute Semmelk",22,"0064",30,$38.20
1756,0000174953,"Queso Cabrales",22,"0011",12,$25.40
2260,0000783390,"Queso Cabrales",22,"0011",12,$25.40
1539,0000964124,"Queso Cabrales",22,"0011",50,$25.40
2389,0000811390,"Queso Cabrales",22,"0011",12,$25.40
3629,0000074252,"Queso Cabrales",22,"0011",24,$25.40
2826,0000673531,"Queso Cabrales",22,"0011",30,$25.40
0861,0000502571,"Queso Cabrales",22,"0011",6,$25.40
2670,0000683512,"Queso Manchego La Pa",86,"0012",12,$46.00
4792,0000742837,"Guaranل Fantلstica",20,"0024",15,$5.60
0662,0000083080,"Guaranل Fantلstica",20,"0024",28,$5.60
1668,0000267030,"Guaranل Fantلstica",20,"0024",12,$5.60
2001,0000540218,"Guaranل Fantلstica",20,"0024",12,$5.60
1584,0000479790,"Guaranل Fantلstica",20,"0024",6,$5.60
0233,0000337440,"Guaranل Fantلstica",20,"0024",10,$5.60
0774,0000367948,"Guaranل Fantلstica",20,"0024",10,$5.60
3698,0000912987,"Guaranل Fantلstica",20,"0024",25,$5.60
2189,0000525998,"Guaranل Fantلstica",20,"0024",10,$5.60
3409,0000978569,"Guaranل Fantلstica",20,"0024",15,$5.60
1576,0000054035,"Guaranل Fantلstica",20,"0024",15,$5.60
1364,0000102558,"Scottish Longbreads",6,"0068",3,$15.90
1408,0000140314,"Scottish Longbreads",6,"0068",20,$15.90
2733,0000218234,"Scottish Longbreads",6,"0068",15,$15.90
2393,0000945516,"Scottish Longbreads",6,"0068",3,$15.90
4524,0000449564,"Scottish Longbreads",6,"0068",10,$15.90
0910,0000881591,"Scottish Longbreads",6,"0068",10,$15.90
2351,0000082084,"Scottish Longbreads",6,"0068",4,$15.90
1051,0000250516,"Scottish Longbreads",6,"0068",8,$15.90
0481,0000954226,"Scottish Longbreads",6,"0068",60,$15.90
0264,0000374937,"Scottish Longbreads",6,"0068",36,$15.90
4532,0000618309,"Scottish Longbreads",6,"0068",30,$15.90
0921,0000696764,"Sir Rodney's Marmala",40,"0020",40,$102.90
1965,0000599398,"Sir Rodney's Marmala",40,"0020",6,$102.90
1417,0000594235,"Sir Rodney's Marmala",40,"0020",20,$102.90
4188,0000572627,"Sir Rodney's Marmala",40,"0020",12,$102.90
1504,0000438170,"Sir Rodney's Marmala",40,"0020",28,$102.90
3435,0000852181,"Sir Rodney's Scones",3,"0021",10,$12.70
0000,0000737664,"Sir Rodney's Scones",3,"0021",20,$12.70
4662,0000034698,"Sir Rodney's Scones",3,"0021",10,$12.70
2955,0000223169,"Sir Rodney's Scones",3,"0021",5,$12.70
4975,0000372237,"Sir Rodney's Scones",3,"0021",10,$12.70
0422,0000417338,"Sir Rodney's Scones",3,"0021",30,$12.70
0057,0000377056,"Sir Rodney's Scones",3,"0021",12,$12.70
1222,0000407854,"Sir Rodney's Scones",3,"0021",50,$12.70
4654,0000755071,"Teatime Chocolate Bi",25,"0019",1,$11.70
2519,0000460712,"Teatime Chocolate Bi",25,"0019",18,$11.70
1624,0000767987,"Teatime Chocolate Bi",25,"0019",15,$11.70
3763,0000889414,"Teatime Chocolate Bi",25,"0019",10,$11.70
1389,0000088801,"Teatime Chocolate Bi",25,"0019",80,$11.70
1220,0000346147,"Teatime Chocolate Bi",25,"0019",18,$11.70
1247,0000436561,"Teatime Chocolate Bi",25,"0019",20,$11.70
1348,0000306916,"Teatime Chocolate Bi",25,"0019",4,$11.70
3020,0000004030,"Gravad lax",11,"0037",1,$33.80
1525,0000520901,"Gravad lax",11,"0037",28,$33.80
0985,0000486406,"Gravad lax",11,"0037",10,$33.80
2409,0000353906,"Inlagd Sill",112,"0036",25,$24.70
4315,0000918890,"Inlagd Sill",112,"0036",30,$24.70
0474,0000739325,"Inlagd Sill",112,"0036",40,$24.70
0802,0000756425,"Inlagd Sill",112,"0036",12,$24.70
0434,0000353054,"Inlagd Sill",112,"0036",20,$24.70
1854,0000009806,"Inlagd Sill",112,"0036",40,$24.70
0969,0000086725,"Inlagd Sill",112,"0036",20,$24.70
0568,0000550383,"Inlagd Sill",112,"0036",6,$24.70
4072,0000771609,"Inlagd Sill",112,"0036",5,$24.70
1142,0000141796,"Rِd Kaviar",101,"0073",25,$19.50
3543,0000373029,"Rِd Kaviar",101,"0073",20,$19.50
0394,0000769811,"Ikura",31,"0010",24,$40.30
0204,0000183296,"Ikura",31,"0010",15,$40.30
0476,0000018822,"Ikura",31,"0010",30,$40.30
1227,0000568485,"Ikura",31,"0010",16,$40.30
0459,0000013341,"Longlife Tofu",4,"0074",21,$12.20
2413,0000495544,"Longlife Tofu",4,"0074",36,$12.20
1430,0000404393,"Longlife Tofu",4,"0074",20,$12.20
3085,0000477137,"Longlife Tofu",4,"0074",14,$12.20
1129,0000412345,"Longlife Tofu",4,"0074",50,$12.20
2515,0000322476,"Longlife Tofu",4,"0074",15,$12.20
1116,0000278584,"Mishi Kobe Niku",29,"0009",20,$119.30
1841,0000037879,"Chocolade",15,"0048",70,$16.20
0533,0000240040,"Zaanse koeken",36,"0047",16,$12.10
1236,0000642680,"Zaanse koeken",36,"0047",55,$12.10
1357,0000997413,"Zaanse koeken",36,"0047",30,$12.10
;
RUN;

%LET _EGTASKLABEL =;


but an error message appeared:
An error occured executing the workspace job "Code1". Integration technologies failed to submit the code. the parameter is incorrect.

and the LOG was empty from any messages, errors or warnings.

Note: Code1 is the name of my file.
Note: I used the same code with Basic SAS 9.1 and it worked and the result appeared in a data set.

Please, can you help with this?
1 REPLY 1
darrylovia
Quartz | Level 8
Dara
You just made a few typos. In the INFORMAT statement the n for 'SellPrice'n is over by a space, you have an extract space between the variable name and the n. The INPUT statements needs a space separating the n from the $. After you make those changes it should work.


Regards
-Darryl

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 2613 views
  • 0 likes
  • 2 in conversation